[tannenba]

Hello, I am trying to teach myself php-sql from "PHP & Mysql for dummies". I am trying to login a new user (from example code in book and getting the error that it couldn't execute the insert query.

 $today = date("Y-m-d");
		$fields_str = implode(",",$fields);
		$values_str = implode('","',$values);
		$fields_str .=",createDate";
		$values_str .='"'.",".'"'.$today;
		$fields_str .=",password";
		$values_str .= '"'.","."md5"."('".$password."')";
		$sql = "INSERT INTO member ";
		$sql .= "(".$fields_str.")";
		$sql .= " VALUES ";
		$sql .= "(".'"'.$values_str.")";
		$result = mysqli_query($cxn,$sql) 
				or die("Couldn't execute final insert query");

The account info is correct, because I get other errors when I try this with the account info wrong.

I believe I might have a problem with the table I made, but it does look ok to me according to the book.

I got to wondering if there is a way to see the code going from php to the mysql server? They are on the same machine (a laptop) that has php (5.2.5), mysql (5) and apache (2.0) on Winxp with sp3. I have error logging turned on, but there is no log file.

Thx,
Joe

[PsychoCoder]

You can do echo $sql; to see what your query is that is being executed.

[akozlik]

PsychoCoder, on 9 Jun, 2008 - 07:36 PM, said:

You can do echo $sql; to see what your query is that is being executed.

Make sure you post the result of your echo here.

[joeyadms]

That can get nasty and hard to debug by adding onto a string that way, it is best just to use multiple lines per variable definition.

I am a little confused with you imploding the fields and values, taking out the commas, if there is more than one field or value, this would cause them to mash together without seperation right?

It is really good practice to not make insert's dynamic.

Doing what Psycho said will help you find the problem fast, but I would suggest rewriting your statements, make them simpler. Assuming your implode works as it should, here is what I would do

<?php
$fields_str = implode(",",$fields);
$values_str = implode('","',$values);
$password = md5($password);
$sql = "INSERT INTO member($fields_str,`createDate`,`password`)
		VALUES('$values_str',CURDATE(),'$password')";
$result = mysqli_query($cxn,$sql)or die("Couldn't execute final insert query");

But it is unsure without the value of $fields, and $values.

[akozlik]

It's looking like PHP and MySql for Dummies was written by a dummy. Ha ha. You can find a lot of great php tutorials here on DIC. Browse through them and you'll pick up a lot of helpful information.

[joeyadms]

akozlik, I was thinking the same thing. I can't understand why anyone trying to teach someone something, would present data in such an unreadable and obfuscated way.

[akozlik]

joeyadms, on 9 Jun, 2008 - 08:04 PM, said:

akozlik, I was thinking the same thing. I can't understand why anyone trying to teach someone something, would present data in such an unreadable and obfuscated way.

I feel like it's that way with a lot of books and tutorials. They try to throw so much information at you at once, that people who are just starting have a hard time following along. That's why when I write my tutorials for DIC I write them to be as simple as possible. Throwing too much at once results in people just not understanding anything.

We should take all the great tutorials in DIC and make our own book. DIC for Dummies.

[silverblaze]

Quote

We should take all the great tutorials in DIC and make our own book. DIC for Dummies.

hehe.. i will order 1 rite nw.. ... its always gud to have a ref materials. ...

you ppl are rite abt most of the tutorials, if we start reading we wont understant evn a bit what they are trying to convey n its real hard to sort out good tutorial whn searching for somethin in web. its nt only the case of php. bt almost all the tutorials are like this. If we read some tuts we will feel tht the author had wrote them to show what all he knes rather than to teach others what they dont knw. Once i went thru a tutorail in CSS. ohh my god its still a nighmare to me..

But even worse is learning videos. they try to teach the entire php in just 6hrs. we wont even understant a bit, if we miss a min of the video thn we will lose the entrie flow. Also it wont stay in memory. After we saw the entire movie we will think what actually we learn. I had seen only one real gud learning video iin php. im nt mentioning its name, bt it was really gud n covers only the basics in a neat n clean way.