- Impact
- 0
Hi guys,
I can't describe how frustrated this has made me.. and it's the littlest thing but I can't go any further without it working..
I have a simple form with a textfield and a submit button
The main goal is to send the value of the textfield to the database when you click Submit..
Problem is that when I click submit it updates the database but it inserts a blank instead of the value I typed in the textfield..
When I do my INSERT command where I use the textfield variable I'm also using a CURDATE() to insert a date into the database which actually works and the dates shows up in the database.
Given that I can now narrow it down to the fact that php just won't recognize the value of my textfield... BUT.. when I use a post method for my form to see the URL values passed the value for my textfield (which PHP doesn't recognize) is in fact displayed in the URL..
here is the full code
<html>
<head><title>WORK!!!!</title>
</head>
<body>
<form action="<?=$PHP_SELF?>" method="get">
<p>Type your name here:<br />
<input type = "text" name = "initial"><br />
<input type="submit" name="submitjoke" value="SUBMIT" /></p>
</form>
<?php // Default page display
// Connect to the database server
$dbcnx = @mysql_connect("localhost", "root", "");
if (!$dbcnx) { echo( "<p>Unable to connect to the " . "database server at this time.</p>" ); exit();
}else {
echo("Connected to Dabase Server");
}
// Select the employee database
if (! @mysql_select_db("employee") ) {
echo( "<p>Unable to locate the employee " . "database at this time.</p>" );
exit();
}
else {
echo("Connected to database employee");
}
this part right now does not execute since I'm once again trying to use a variable from my form. If I remove the first condition where I check for SUBMIT it processes the sql INSERT statement and inserts the date but of course not the Name
if ($submitjoke == "SUBMIT") {
$sql = "INSERT INTO hrdata SET Name = '$initial', Hired = CURDATE()";
if (@mysql_query($sql)) {
echo("<p>Your name has been added.</p>"); }
else {
echo("<p>Error adding name: " . mysql_error() . "</p>");
}
}
echo("<p> Here are all the names in our database: </p>");
$result = @mysql_query("SELECT Name, Hired FROM hrdata");
if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit();
} // Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) { echo("<p>" . $row["Name"] . " " . $row["Hired"] ."</p>"); }
?>
</body>
</html>
does anybody know what's going on here?
Thank you kindly in advance
I can't describe how frustrated this has made me.. and it's the littlest thing but I can't go any further without it working..
I have a simple form with a textfield and a submit button
The main goal is to send the value of the textfield to the database when you click Submit..
Problem is that when I click submit it updates the database but it inserts a blank instead of the value I typed in the textfield..
When I do my INSERT command where I use the textfield variable I'm also using a CURDATE() to insert a date into the database which actually works and the dates shows up in the database.
Given that I can now narrow it down to the fact that php just won't recognize the value of my textfield... BUT.. when I use a post method for my form to see the URL values passed the value for my textfield (which PHP doesn't recognize) is in fact displayed in the URL..
here is the full code
<html>
<head><title>WORK!!!!</title>
</head>
<body>
<form action="<?=$PHP_SELF?>" method="get">
<p>Type your name here:<br />
<input type = "text" name = "initial"><br />
<input type="submit" name="submitjoke" value="SUBMIT" /></p>
</form>
<?php // Default page display
// Connect to the database server
$dbcnx = @mysql_connect("localhost", "root", "");
if (!$dbcnx) { echo( "<p>Unable to connect to the " . "database server at this time.</p>" ); exit();
}else {
echo("Connected to Dabase Server");
}
// Select the employee database
if (! @mysql_select_db("employee") ) {
echo( "<p>Unable to locate the employee " . "database at this time.</p>" );
exit();
}
else {
echo("Connected to database employee");
}
this part right now does not execute since I'm once again trying to use a variable from my form. If I remove the first condition where I check for SUBMIT it processes the sql INSERT statement and inserts the date but of course not the Name
if ($submitjoke == "SUBMIT") {
$sql = "INSERT INTO hrdata SET Name = '$initial', Hired = CURDATE()";
if (@mysql_query($sql)) {
echo("<p>Your name has been added.</p>"); }
else {
echo("<p>Error adding name: " . mysql_error() . "</p>");
}
}
echo("<p> Here are all the names in our database: </p>");
$result = @mysql_query("SELECT Name, Hired FROM hrdata");
if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit();
} // Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) { echo("<p>" . $row["Name"] . " " . $row["Hired"] ."</p>"); }
?>
</body>
</html>
does anybody know what's going on here?
Thank you kindly in advance
I'm know mysql or php guru, but I think your problem may be with the first line in this section of your code:
