PHP & mysql

**navaldesign** · 07-24-2006, 10:12 PM

Re: PHP & mysql

Try:

<html>
<body>
<?php
$con = mysql_connect("localhost","colescom_colen","****** *");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("colescom_names", $con);
$result = mysql_query("SELECT * FROM person
WHERE name='Colen'");
while($row = mysql_fetch_array($result))
$name=$row['name'];
$email=$row['email'];
if ($name=="Colen")
{
header("Location: ThankYou.html");
}
else
{
header("Location: NoRecord.html");
}
echo "<br />";
?>
</body>
<html>

But why is it all included in the html tags ?

**greyhame** · 07-25-2006, 02:43 AM

Re: PHP & mysql

I have been going thru the tutorials at: http://www.w3schools.com/php/php_variables.asp

Some of the examples include the html tags and some do not. Apparently it makes no difference whether they are there or not as far as the php code is concerned as long as the necessary php start and stop tags are in place

**greyhame** · 07-25-2006, 02:53 AM

Re: PHP & mysql

Here is a script I have as login.php:

<?php
$name=$_POST["name"];
$email=$_POST["email"];
$con = mysql_connect("localhost","colescom_colen","****** **");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("colescom_colen", $con);
$result = mysql_query("SELECT * FROM person)
WHERE email=$email);
if $result==$email;
{
echo 'Login okay';
else
echo 'Not in system';
}
mysql_close($con);
?>

I also have a login.html which transmits a login email address. When I submit the address I get the following error:

Parse error: syntax error, unexpected $end in /home/colescom/public_html/login.php on line 20

There is no line 20 in my script. I did a search on this type of error but could not find an answer.

**navaldesign** · 07-25-2006, 07:44 AM

Re: PHP & mysql

1. Did you get any results by inserting the {
and } ?
2. The html tags are used if in the same page you have to combine php with some html code. If the script is stand alone, as it seems to be in your case (the presense of two " headr: .... " lines makes me think so) there is no need for html tags.
3. I think that you have a small error in here, and this caused your script to go directly to the end, which causes the error message.

Try it like this: (please note that i have not tested it)

<?php
$name=$_POST["name"];
$email=$_POST["email"];
$con = mysql_connect("localhost","colescom_colen","****** **");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("colescom_colen", $con);
$result = mysql_query("SELECT * FROM person WHERE email=$email");
while ( $row = mysql_fetch_array($result))
{
if ($row['email'] = $email)
{
$registered = "True";
}
}
mysql_close($con);
if ($registered !="")
{
echo 'Login okay';
header("Location: page_to_send_him_to.html"); // Use this line if you wish to send him to a specific page
}
else
{
echo 'You are not registered yet.';
header("Location: registrationpage.html"); // Use this line if you wish to send him to the registration form page
}
?>

**greyhame** · 07-25-2006, 02:56 PM

Re: PHP & mysql

Here is the script as I tried it:

<?php
$name=$_POST["name"];
$email=$_POST["email"];
$con = mysql_connect("localhost","colescom_colen","****** ");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("colescom_colen", $con);
$result = mysql_query("SELECT * FROM person WHERE email=$email");
while ( $row = mysql_fetch_array($result))
{
if ($row['email'] = $email)
$registered = "True"
mysql_close($con);
}
if ($registered !="")
{
echo 'Login okay';
header("Location: ThankYou.html"); // Use this line if you wish to send him to a specific page
}
else
{
echo 'You are not registered yet.';
header("Location: NoRecord.html"); // Use this line if you wish to send him to the registration
form page
}
?>

I get this error:

Parse error: syntax error, unexpected T_STRING in /home/colescom/public_html/login.php on line 15

Line 15: mysql_close($con);

I checked it with ***ad (a php editor). All parentheses and brackets are in place.

I noticed you closed the connection to the database before using the header statement. Is this necessary to get the header statement to work?

**navaldesign** · 07-25-2006, 03:09 PM

Re: PHP & mysql

You have moved one of the curly brackets - the one before the mysql_close($con);

I also made a couple of changes. Please copy / paste and try again.

The connection is only needed till the check is done. As a good rule, the connection should be closed after every querry, unless you use loop in loop techniques which are rather complicated.

**greyhame** · 07-25-2006, 03:28 PM

Re: PHP & mysql

What were the other changes you made?

**navaldesign** · 07-25-2006, 08:42 PM

Re: PHP & mysql

Put two curly bracket where missing.

PHP & mysql

PHP & mysql

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment