DaniWeb Forum Index > Web Development > PHP

Variable Validation & MYSQL

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2004

Posts: 4

Reputation: vexer007 is an unknown quantity at this point

Solved Threads: 0

vexer007

Offline

Newbie Poster

Variable Validation & MYSQL

Nov 19th, 2004

Hi,

I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users who are registered on the user_table can leave comments which will be passed into the user_comment table. HERE IS THE CODE FOR THE SECOND PART, CHECKING IF A USER'S EMAIL EXIST IN the user_table IF SO, PUX THESE DATA INTO user_comment TABLE. PLEASE CAN ANYONE SPOT WHAT IS WRONG WITH THE CODE???

<?php require 'db.private'; ?>
<html>
<head>
<title> Gizmo® Electronics - Login</title>

</head>
<body>

<table width="100%">
<tr><td>

<?php

$connection = mysql_connect($hostname,$username,$password);
mysql_select_db($databaseName, $connection);

$submit = $_POST['submit'];
$comment = $_POST['comment'];
$email = $_POST['email'];

if(isset($submit)) {

//if(isset($submit)) {
// check if user exists in the database
$query = mysql_query("SELECT email FROM user_table WHERE email = '".$email."'");
//$num_rows = mysql_num_rows($query_email);
//if(!$num_rows) die('Gizmerror!! Either you have typed your USERNAME and or Your PASSWORD incorrectly or you have not registered to access this pages. <p><font color="red" size="+1"><center> Please Try Again</center> </font></p>');

//mysql_query ( "INSERT INTO user_comment (email, comment) VALUES ('$email', '$comment');

$insert = "INSERT INTO user_comment SET
email = '$email',
comment = '$comment'";

//mysql_query($insert);
//$row_comment = mysql_fetch_Array($query);
die("<META http-equiv=\"Refresh\" content=\"0;url=commentdisplay.php\">");

//die("Thank you for registering. Your Registration was Successful! You can now login");

//$insert = "INSERT INTO user_comment SET
//comment = '$comment'";

//mysql_query($insert);

die("Thank you for registering. Your Registration was Successful! You can now login");

//}

//echo mysql_error();
//mysql_close();
}
?>

<center>

<form action="comment.php" method="post">
<table summary="comment page">

<tr>
<td><label for="comment">Your Comment:</label></td>
<td><textarea name="comment" cols="70" rows="5" wrap="VIRTUAL" id="comment" value="comment"></textarea><br /></td>
</tr>

<tr>
<td><label for="email">Email Address:</label></td>
<td><input type="text" id="email" name="email" value="type ur email here"></td>
</tr>

<tr>
<td><input type="submit" name="submit" /></td>
</tr>

</table>
</form>

<p><a href="home.htm">...or return to our Homepage</a></p>

</td>
</tr>
</table>
</body>
</html>

THANK YOU, I REALLY APPRECIATE YOUR TIME AND EFFORT.