[RESOLVED] Not showing records in MySQL db

shanba_kay

Hi!

I'm trying to write into my MySQL database, but no records seem to get registered when I process the form.

I inserted control statements, and I get the following messages:
test
Connection successful!
questions
subjects
1 record added

But when I check the database via MyPHPAdmin, it shows the tables to be empty.
I made set the user privileges to ALL.
Any thoghts?

Thank you.
Maria

etully

put a print statement in your code that displays the insert statement. For example:

$query = "insert into customers (name,address) values ('$name','$address')";
$result = mysql_query($query);
print "$query<p>";

Then run the code.
Then copy the insert statement and paste it into the manual SQL form in MyPHPAdmin and see if it gives you an error. That error should tell you what you're doing wrong.

shanba_kay

Thanks.

But how do I find the myPHPadmin MySQL manual?
I'm unafamiliar with the interface.

Maria

etully

Sorry, no, not the instruction manual.

In MyPHPAdmin, there is a red "SQL" button somewhere. (It's been years since I used MyPHPAdmin so I can't tell you exactly where to look for it).

When you click that button, it gives you a text box where you can manually enter a SQL insert command. And then it tells you if there was an error.

So instead of using MyPHPAdmin's fancy GUI which makes life easy... you can run a SQL statement exactly the same way you're trying to program it in PHP. So click the red button, and paste your SQL statement into the box.

shanba_kay

OK, I ran it and the result was:

Inserted rows: 1
Inserted row id: 1 (Query took 0.0002 sec)

But when I click to Browse the table it tells me it's empty.
I try querying it and it tells me there were zero rows found.

This is my dissertation and I'm working on a pretty close deadline.
I am going to harm myself lol :xbones:

etully

Are you sure you're looking in the right table when you use MyPHPAdmin? I remember MyPHPAdmin being a little clumsy the first time I used it. I thought I was looking in one table but I was really looking in another.

Since you're pretty sure there's no SQL errors, you might just try sticking with PHP to do your testing. For example, for testing purposes, add this code after your insert statement:

$query = "select name,address from customers";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
print "Here's what I see in the table<p>";
while (list($name,$address) = mysql_fetch_row($result)) {
print "$name, $address<br>";
}
else {
print "There was no data in the table";
}

(Of course, change name,address, and customers with whatever fields and table names you're using.)

If you put that code after you perform the insert statement, it will show you the new contents of the table. Maybe you are getting the data into the table just fine and MyPHPAdmin is looking at the wrong database or the wrong table or maybe it's misconfigured or something. Troubleshooting MyPHPAdmin is not something I can help with.

shanba_kay

It's really really weird.
I'm trying to insert data into myPHPadmin via the INSERT menu (where you just type in the values into the fields) and still nothing, tables show empty.

I only have one database with two tables, unless myPHP is looking on mars instead of earth it should be able to see it.

Thanks anyway though, thanks for helping me figure out it's myPHPadmin and not my PHP code that does this. I'll see what I can do. I'll try the code too.

Thanks Thanks.
Maria

jinky32

can you put show us all the php in the file that includes the INSERT query?

shanba_kay

		<?php	
				//variables
				$location	= $_POST["location"];
				$gender 	= $_POST["gender"];
				$subject	= $_POST["subject"];
				$age 		= $_POST["age"];
				$education 	= $_POST["education"];
				$SEusage 	= $_POST["SEusage"];

			//connecting to database
			$conn = mysql_connect("localhost", "user", "pass");
			if (!$conn){die('Could not connect: ' . mysql_error());}
			else echo "Connection successful!<br/>";
			mysql_select_db("shanbak_experiment", $conn) or die('Could not connect: ' . mysql_error());

			//print a list of the tables
			$result = mysql_query("SHOW tables", $conn);
			while($row = mysql_fetch_row($result))
			{
  				print("$row[0]<br>");
			}

			//insert data
			$query = "INSERT INTO subjects (gender, location, subject, age, education, SEusage) VALUES ('$gender', '$location', '$subject', '$age', '$education', '$SEusage')";

			$result = mysql_query($query, $conn);
			print "$query<p>";

			if (!mysql_query($query,$conn))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

			//displaying stuff
			echo "<br/><br/><b>Hello</b><br />";
			echo "Location: ".$location."<br/>";
			echo "Gender: ".$gender."<br/>";
			echo "Subject: ".$subject."<br/>";
			echo "Age: ".$age."<br/>";
			echo "Education: ".$education."<br/>";
			echo "SEusage: ".$SEusage;
	?>

OUTPUT when I run the code:

test
Connection successful!
***These are the tables in the database:
questions
subjects

INSERT INTO subjects (gender, location, subject, age, education, SEusage) VALUES ('.0.', '.0.', '.0.', '.18.', '.0.', '.0.')

1 record added

Hello
Location: 0
Gender: 0
Subject: 0
Age: 18
Education: 0
SEusage: 0

I'm talking to my web hosting people to see if their PHP restriction might affect this. But I think the trouble is with myPHPadmin. I tried inserting data directly via the myPHPadmin interface, using their INSERT tab, where you just type in the values. I get a '1 row added' confirmation, but the tables are still empty.

In my databse, I'm unsure of what the 'collate' paramter does (I just set it to hp8_english_ci) for both the database and the tables. Can that be relevant at all? But I mean, when I type in my SQL statement, it should give me some sort of type mismatch error no? myPHPadmin reports no errors.

This is so frustrating

shanba_kay

I GOT IT.
I FIXED IT.
OMG!!!!!!!!!!! You'll never guess.

My web host MySQL engine was set to one called BLACKHOLE which, as the name implies, doesn't store any records, just the db structure. I changed the engine to the default one and it works just fiiiiine.

Thanks for all the help guys.
Hope I won't be back asking any stupid questions any time soon 🙂

jinky32

great! If you look at the top of the thread under 'thread tools' you can mark the thread as resolved.