Codezwiz >> Forums >> General PHP Nuke Help >> Php Question ( Insert Sql Thingy)

Im'a Trying To Insert Data Into A Databse Using Html Input Boxes And When Ever I Hit My Homemade Submit Button It Sends Blank Info Into The Databse Could Anyone Help Me With This Thanx

<?php
$sql = "SELECT id, name, msn, aol, yahoo , icq
FROM lod_im";

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
<table BORDER="2"><tr><td >Id</td><td width="20%">Member Name</td><td width="20%">Msn Addy</td><td width="20%">Aol Addy</td><td width="20%">Yahoo Addy</td><td width=20%">E-Mail Addy</td></tr>';
while ($row = mysql_fetch_assoc($result)) {
echo '<tr><td>';
echo $row["id"];
echo '</td><td>';
echo $row["name"];
echo '</td><td>';
echo $row["msn"];
echo '</td><td>';
echo $row["aol"];
echo '</td><td>';
echo $row["yahoo"];
echo '</td><td>';
echo $row["icq"];
echo '<br>';
}
echo '</tr></table>';
mysql_free_result($result);

if (isset($_POST["tekst1"])){

$sql = mysql_query("INSERT INTO lod_im (name,msn,yahoo) VALUES('".$_POST["text1"]."','".$_POST["text2"]."','".$_POST["text3"]."')")or die(mysql_error());

if ($sql){
print "Data Inserted";
}
}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>Untitled</title>
</head>

<body>
<form name="f1">
Lod User Name<input type="text" name="text1" value="">
<br>
Msn Messenger <input type="text" name="text2" value="">
<br>
Yahoo Instant Messenger <input type="text" name="text3" value="">
<br>
<input type="submit" value="Submit">
</form>

</body>
</html>

With the code that you have, no data is even being pulled from your form. Let's look at this bit by bit:

}
<table BORDER="2"><tr><td >Id</td><td width="20%">Member Name</td><td width="20%">Msn Addy</td><td width="20%">Aol Addy</td><td width="20%">Yahoo Addy</td><td width="20%">E-Mail Addy</td></tr>';
while ($row = mysql_fetch_assoc($result)) {

Ahh That Help Heaps Thankx One Last Question tho when i click sumbit it sends the data but is there a way to redirect after ive hit submit to stop double and tripe posting from accidentel refresh or something ..Oh and a way to stop when somone just refreshs the page it sends the data not very sure about that well heres the code edited

<html>
<head>
<title>Untitled</title>
</head>

<body>
<form name="f1" method="post">
<table border="2">
<tr><td>Lod User Name</td><td><input type="text" name="name" value=""></tr></td>
<br>
<tr><td>Msn Messenger</td><td><input type="text" name="msn" value=""></tr></td>
<br>
<tr><td>Yahoo Instant Messenger</td><td><input type="text" name="yahoo" value=""></tr></td>

<tr><td>Aol Instant Messenger</td><td><input type="text" name="aol" value=""></tr></td>

<tr><td>Email</td><td><input type="text" name="text5" value=""></tr></td>

</table>
<input type="submit" value="Submit" > <input type="button" name="Exit" value=" Exit "
onClick="javascript:location.href='http://microsoft.com';">
</form>

</body>
</html>

<?php
$hostname = "xxxxxxxxxx";
$usernamedb = "xxxxxx";
$passworddb = "xxxxxxx";
$dbName = "xxxxxx";

//Edited KH -- Do not post username/passwords in your code!

MYSQL_CONNECT($hostname, $usernamedb, $passworddb);
@mysql_select_db("$dbName");

$sql = "SELECT id, name, msn, aol, yahoo , icq
FROM lod_im";

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
echo "<table BORDER=\"2\"><tr><td >Id</td><td width=\"20%\">Member Name</td><td width=\"20%\">Msn Addy</td><td width=\"20%\">Aol Addy</td><td width=\"20%\">Yahoo Addy</td><td width=\"20%\">E-Mail Addy</td></tr>";
while ($row = mysql_fetch_assoc($result)) {
echo '<tr><td>';
echo $row["name"];
echo '</td><td>';
echo $row["msn"];
echo '</td><td>';
echo $row["aol"];
echo '</td><td>';
echo $row["yahoo"];
echo '</td><td>';
echo $row["icq"];
echo '<br>';
}
echo '</tr></table>';
mysql_free_result($result);

$sql = mysql_query("INSERT INTO lod_im (name,msn,yahoo,aol,icq) VALUES('".$_POST["name"]."','".$_POST["msn"]."','".$_POST["yahoo"]."','".$_POST["aol"]."','".$_POST["icq"]."')")or die(mysql_error());
if ($sql){

}
?>

If you look at your code above, you will see I have edited out your database information. You should never ever post that information as you have just compromised the security of your database. You need to change your username and password ASAP.

The following is an example of how to redirect after your form is submitted:

$insertGoTo = "whatever.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}