Board index   FAQ   Search  
Register  Login
Board index PHP PHP Scripts

Please Help! With this code

Links for php scripts

Moderators: macek, egami, gesf

Please Help! With this code

Postby sharmel4u » Mon May 13, 2013 11:22 am

Please what is wrong with this code, the Javascript alert is not running. When user tried to make booking twice there was no alert message and the data went into the database

Please Help!

HERE IS THE CODE (Not all)



/**********************************************************************************************
Check the DB for records...
**********************************************************************************************/

// check for the Id already in the database...USE COUNT TO COUNT ARROUND THE EMAIL FIELD IN THE TABLE.
$query = "SELECT COUNT(national_id) FROM bookings WHERE national_id = 'thisNational_idField'";
if ($debug) echo "<br>SQL STATEMENTbr>".$query."<br><br>";

// result from the select query assign it to result variable
$result = mysql_query($query) or die("Invalid query (login): " . mysql_error());

// fetch the row in the database i.e the row that is affected

$row = mysql_fetch_row($result);

// it should not be greater than zero else the email is already in the databse
if ($row[0] > 0)
{
// an email aleady exists in the database, because the row count > 0...
?>
<script type="text/javascript">
alert("The ID <?php echo $_POST['thisNational_idField']; ?> is already registered.");
history.back();
</script>
<?php
}
else

// this query insert those fields gotten from the form with the REQUEST method into the database (bookings table)
$sqlQuery = "INSERT INTO bookings (national_id , fname , mname , lname , company , title , address1 , address2 , city , country , postal_code , phone , serviceReq , date )
VALUES ('$thisNational_id' , '$thisFname' , '$thisMname' , '$thisLname' , '$thisCompany' , '$thisTitle' , '$thisAddress1' , '$thisAddress2' , '$thisCity' , '$thisCountry' , '$thisPostal_code' , '$thisPhone' , '$thisService_Req' , '$thisDate' )";

// then give the output of the query to the variable result. then use mysql-query() funtion to execute it
$result = mysql_query($sqlQuery) or die("Invalid query: " . mysql_error() . "<br><br>". $sqlQuery);

?>
sharmel4u
New php-forum User
New php-forum User
 
Posts: 3
Joined: Mon May 13, 2013 8:58 am

Re: Please Help! With this code

Postby sharmel4u » Tue May 14, 2013 2:07 am

Thanks alot, I have been able to correct it :) cheers

WHERE national_id = '". $_POST['thisNational_idField']."'";
sharmel4u
New php-forum User
New php-forum User
 
Posts: 3
Joined: Mon May 13, 2013 8:58 am


Return to PHP Scripts

Who is online

Users browsing this forum: Google [Bot] and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.