empty data sent to mysql

pappszaby · Joined: 21 Nov 2005 Posts: 30

I have a small simple html form wich should sent data to a mysql database. The connection is fine but only empty data si going through. INSERT INTO `details` VALUES (31, '', '', '');
here is the scripts:
<?
$DBhost = "host";
$DBuser = "user";
$DBpass = "pass";
$DBName = "example";
$table = "details";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$sqlquery = "INSERT INTO $table VALUES('$id','$name','$telephone','$birthday')";

$results = mysql_query($sqlquery);

mysql_close();

print "<html><body><center>";
print "<p>You have just entered this record<p>";
print "Name : $name<br>";
print "Telephone : $telephone<br>";
print "Birthday :$birthday";
print "</body></html>";
?>

Any idea why? Sad

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

try printing the values before running the query, so you'll see if the variables actually contain the values

pappszaby · Joined: 21 Nov 2005 Posts: 30

It looks like the variables does not contain the values.

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

so the problem is before this part of the script, check where you assign the values to the variables

I haven't see you on the forum for some time, welcome back pappszaby Wink

pappszaby · Joined: 21 Nov 2005 Posts: 30

Hi Fed

Nice to see you again too.

Do you think the html would be the problem. Sad

pappszaby · Joined: 21 Nov 2005 Posts: 30

<html>
<head>
</head>
<body>
<center>
<form method="post" action="script.php">
<input type="hidden" name="id" value="null">
<table>
<tr><td align="left">Name</td>
<td><input type="text" name="name"></td>
</tr>
<tr><td align="left">Telephone</td>
<td><input type="text" name="telephone" size="20"></td>
</tr>
<tr><td align="left">Birthday</td>
<td><input type="text" name="birthday" size="20"></td>
</tr>
<tr><td colspan="2">
<p align="center">
<input type="submit" value="Enter record">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

you should post the section where you put the values in the variables to see what it could be

pappszaby · Joined: 21 Nov 2005 Posts: 30

I tried it without the print part only the script where I assign the values to the variables and still nothing happenes.

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

but do you actually put the values in the $_GET array into the variables? you should have something like

pappszaby · Joined: 21 Nov 2005 Posts: 30

Thanks Fed. I have work it out Very Happy

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

you're welcome

pappszaby · Joined: 21 Nov 2005 Posts: 30

Fed,

Do you have any idea how I could have the results of the mysql database displayed by reversing the rows with the colums. I don't know if I was clear enough.
As it for now when the mysql_query runs it displays me the database the same way.
id name telephone birthday.

What I would like is

id
name
telephone
birthday

Thanks

Fed · Site Admin Joined: 12 Aug 2005 Posts: 176

I'm not sure I get you..
do you want the column titles vertically in the first column and a record of data per column?

since you lay out the HTML sequentially, hence all the cells of a row before all the cells of the following row it might be a problem...

you should retrieve all the data from the database and store all those of the same field in a separate array, then print this stuff looping through the arrays

it can be done for sure....no need to say that it wouldn't probably be so easy, specially if you're not so familiar with displaying query results, working with arrays etc