7,368 Topics

Member Avatar for
Member Avatar for Glen_4

I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the …

Member Avatar for Glen_4
0
356
Member Avatar for mohamedrani

Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE …

Member Avatar for andrevanzuydam
0
984
Member Avatar for gcarpanetti

Hello everyone. First of all apologies for my english. It is not my native languate and also if i break any good practice. It is my first Post. I'm triying to learn CGI programming in C. Just for learn purposes and i have been triying litle step by step tests. …

0
245
Member Avatar for vipula65

Hi I have this script to show items in the database. but it is not showing the results. Pls can anyone help? <html> <div><br/><center><h2><font face="Lucida Handwriting" size="+1" color="#00CCFF">Casual Shirts</font></h2></center></div> <div style="width:100%;float:left" > <?php include("config.php"); $dress=$_REQUEST['dress']; $catg=$_REQUEST['catg']; $subcatg=$_REQUEST['subcatg']; $sel=mysqli_query($conn,"select * from items where catg='$catg' and subcatg='$subcatg'"); echo"<form method='post'><table border='0' align='center'><tr>"; $n=1; …

Member Avatar for andrevanzuydam
0
259
Member Avatar for vipula65

this is my script but cannot connect. errot message error . user root has no password. I have created databse using phpmyadmin Warning: mysqli_connect(): (HY000/1049): Unknown database 'shop' in C:\wamp64\www\online_shopping\admin\index.php on line 4 pls help <?php //error_reporting(1); //include("config.php"); $conn=mysqli_connect("localhost","root","", "shop") or die(mysqli_error()); extract($_REQUEST); if($_REQUEST['sub']) { $name=$_REQUEST['t1']; $pass=$_REQUEST['p1']; $sel=mysqli_query($conn,"select name, pass …

Member Avatar for vipula65
0
535
Member Avatar for nanakumi75

Hello, I need some help from experts. I am testing a site I have created. I have an issue with login system. It worked fine using XAMPP on my computer but when I uploaded to a live server, login has been a problem. This is what I get when I …

Member Avatar for rproffitt
0
735
Member Avatar for Glen_4

Hello everybody I'm creating a Windows Desktop App using vb.net, I'm not very knowledgeble and I can say that I'm still a beginner. So I have this project where I'm trying to create a report form using ReportViewer where as after putting the ReportViewer control to my form and select …

Member Avatar for pritaeas
0
667
Member Avatar for SimonIoa

I have three tables(table, table2,table3). From table1 i want to return three rows: Title, Desc,time,'products' AS type From table2 i want to return three rows: group_title, group_desc, created,'groups' AS type From table3 i want to return three rows: name, occupation,birth,'users' AS type $sql = "SELECT DISTINCT * FROM (SELECT table1.title, …

Member Avatar for Biiim
1
1K
Member Avatar for halovalo

Hi all at Daniweb, I'm quite new to PHP and I'm banging my head over this... query 1 WORKS: **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('1','6')";** //both 1 and 6 are IN parameters! query 2 DOESN'T WORK: $id_pictures = 1; $id_names = 6; **$query = "CALL procedure_is_a_great_way_to_let_db_do_some_work('".$id_pictures."','".$id_names."')";** //both 1 and 6 are IN …

Member Avatar for halovalo
-1
823
Member Avatar for Biiim

I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need …

Member Avatar for Biiim
1
1K
Member Avatar for Денис_2

Hello, I'm quite nub in web development, so be gentle please. If this place is wrong for such problems point me to a more appropriate resource please. To became more familiar with web-programming I found good (as I thought) area for self-improvement. One of my friends owns web project. This …

Member Avatar for Денис_2
0
823
Member Avatar for JamieBek04

Really hoping someone can help me out or point me in the right direction. This is my first ever post in a coding forum so I apologize in advance if I’m breaking any forum rules. I already have a bunch of php code sorted from modifying web resources. I need …

Member Avatar for Dani
0
859
Member Avatar for iverve

Now every web developer need a local web development envoiurment but i don't know how to set up Full-Stack ASP.NET Web Developmental Environment. any one can here to explain me.

Member Avatar for pritaeas
0
506
Member Avatar for aecha

hi everyone. can you help me to check why this error occur and how to fix it? when i want to insert the data, this error is coming out and data not insert into database. <?php define('DB_SERVER','localhost'); define('DB_USER','root'); define('DB_PASS' ,'root123'); define('DB_NAME', 'ems'); $con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME); // Check connection if (mysqli_connect_errno()) …

Member Avatar for Dani
0
269
Member Avatar for FarrisFahad

I let users earn money through my site, and I want to record their daily earnings. I want to record their earnings starting from 00:01am I don't know how to do this using PHP and MySQL. I know how to create, update, etc database. But I am streuggling with PHP …

Member Avatar for XxRedSteelxX
0
2K
Member Avatar for benson.tairuakinsola

I am trying to set up a json object.array to retrieve the data from this mysql query. the data required is posted from java and that seems to work fine, but I get parsing errors. I tried testing the php file and I get the "Parse error: syntax error, unexpected …

Member Avatar for Veera_2
0
4K
Member Avatar for Kathy B

Hello, I am new to this site and to php and mySQL...and I need some help. I know this topic is all over the web but after a couple of days of looking and refering to several text books it still doesn't work so please bear with me. I have …

Member Avatar for Biiim
0
1K
Member Avatar for RudyM

Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm …

Member Avatar for kccole01
0
4K
Member Avatar for (MeoW)

this is may code on adding or saving image in to mysql DB Private Sub SAVECATEGORY_Click(sender As Object, e As EventArgs) Handles SAVECATEGORY.Click If PictureBox1.Image Is Nothing Then MessageBox.Show("Please Insert image ") addcategoryclear() 'you call ddcategoryclear() to clear textbox and picturebox ElseIf TextBox1.Text = "" Then MessageBox.Show("Please Insert Image Name") …

Member Avatar for DGPickett
0
1K
Member Avatar for Perry Winkel

New to this site I would like to say hello. My main interest is programming in cpp and especially the use of the Standard Template Library and std:: stuff. More than willing to look into any questions from the community. Perry.

Member Avatar for rproffitt
1
665
Member Avatar for Amna_5

I have developed a game for android mobiles ["Rise Up Air Balloon"](https://play.google.com/store/apps/details?id=com.abacus.riseup). I want to updatte it. Kindly suggest me something if it is better to update https://lh3.googleusercontent.com/rB-fPEBiaGzT_ubSzCtSfftC4pKkIm5buAS2_DhQz4_exYFCrjbcN2T1NhkmM0A3Jj0=s180-rw

Member Avatar for Antionne
2
1K
Member Avatar for (MeoW)

![help1.png](/attachments/large/4/f82a18611583d3d8a689ee71b5a6bc3b.png) it hard for me to explain what the problem, but the thing that i need your help is , how to retrieve the ID to listview, im trying to create a POS project like on restaurant or fastfood store, in the listview it will retrieve image ang name, but …

Member Avatar for (MeoW)
0
415
Member Avatar for (MeoW)

Hello guys , can you help me how to get the ID from mysql DB , if the listview is click the name and the ID well retrieve to textbox1 and textbox2, i dont know how to get the ID?, on the listview the ID wasnt retieve , can you …

Member Avatar for (MeoW)
0
377
Member Avatar for Ashvini_1

<form class="nice-form" action="" method="post"> <?php session_start(); // echo "<script>console.log('test')</script>"; // echo "<script>console.log(".var_dump($_SESSION) .");</script>"; // echo var_dump($_SESSION); // echo var_dump($_POST); include("../connection.php"); if (isset($_POST['action'])) { if ($_POST['action'] == "assign_user") { $doorId = $_POST["door"]; $username = $_POST["username"]; $approverId = $_SESSION["id"]; // echo var_dump($_POST); $sql = "SELECT * FROM user WHERE id = '$username' …

Member Avatar for rproffitt
-1
248
Member Avatar for rickarro

I am using bootstrap modals, when i query to populate a dropdown to fill in to my form, my query is show all but the first record and i can't figure out why. My form looks like this <div class="form-group"> <label for="deptcode">Department</label> <select class="form-control" id="deptcode" name="deptcode" value="<?php echo $mem['deptcode'];?>" <?php …

Member Avatar for rickarro
0
945
Member Avatar for Daryl_10

I am working on an app where a user registers and its passed to the server where there information is added to the database. It passes various checks along the way but ails to add the user. Code below: <?php $con = mysqli_connect('localhost', 'root', 'root', 'eat4lessaccess'); //check connection if(mysqli_connect_errno()) { …

Member Avatar for Daryl_10
0
1K
Member Avatar for (MeoW)

hello, im going to create POS project, can you help me how to retrieve all image from mysql db to listview, so that i can view all image that i save to my db, i already save image and use sreach button on retrieve image from db to picturebox. thank …

Member Avatar for (MeoW)
0
1K
Member Avatar for Kathy B

I need help on a new problem. On my women’s golf club web site I have a Members Directory page which consists of a table, 5 columns in width, and enough 2 rows sets to hold the members photo in the odd numbered rows with the members name in the …

Member Avatar for Gieroja
0
1K
Member Avatar for JamieBek04

Heres a pic of my database table ![Screen_Shot_2019-11-16_at_2_35_54_AM.png](/attachments/large/4/0749479693675147a0ccc8219b89e87f.png) Im trying to create a search page with drop down selectors to filter through each of the last 8 columns. I want the the drop down selectors to be able to select multiple entries (I have this working already) I also want …

0
485
Member Avatar for guyinpv

Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, …

Member Avatar for Saudi_2
0
4K

The End.