Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
<?
//connect to database
$dbhost = 'mysql01.myhostcp.com';
$dbuser = 'deans_user1';
$dbpass = 'qwerty123';
$dbname = 'deansghot5722com5233_deansdatabase';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
//NOTE: MAKE SURE YOU DO YOUR OWN APPROPRIATE SERVERSIDE ERROR CHECKING HERE!!!
if(!empty($_POST) && isset($_POST))
{
$emptyvariables = false;
if(!empty($_POST)){
foreach($_POST as $key => $val){
if(empty($_POST[$key])){
echo"Please insert $key<br />";
$emptyvariables = true;
}
}
}
if($emptyvariables == false){
//make variables safe to insert
$id = mysql_real_escape_string($_POST['id']);
$Forename = mysql_real_escape_string($_POST['Forename']);
$Surname = mysql_real_escape_string($_POST['Surname']);
$Arrival_Date = mysql_real_escape_string($_POST['Arrival_Date']);
$Departure_Date = mysql_real_escape_string($_POST['Departure_Date']);
$RoomNo = mysql_real_escape_string($_POST['RoomNo']);
$Tel = mysql_real_escape_string($_POST['Tel']);
//query to insert data into table
$sql = "
INSERT INTO bookings
SET
id = '$id',
Forename = '$Forename',
Surname = '$Surname',
Arrival_Date = '$Arrival_Date',
Departure_Date = '$Departure_Date',
RoomNo = '$RoomNo',
Tel = '$Tel'";
echo"$query";
$result = mysql_query($sql);
if(!$result)
{
echo "Failed to insert record<br>Please Ensure booking does not currently exist";
}
else
{
echo "Record inserted successfully";
}
}
}
?>
<table width="300" border="1">
<tr>
<td><b>ID</b></td>
<td><b>Forename</b></td>
<td><b>Surname</b></td>
<td><b>Arrival_Date</b></td>
<td><b>Departure_Date</b></td>
<td><b>RoomNo</b></td>
<td><b>Tel</b></td>
</tr>
<?
//show data from tables
$sql = "
SELECT *
FROM bookings
ORDER BY ID ASC
LIMIT 20";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
//print data
?>
<tr>
<td><? echo $row['id']; ?></td>
<td><? echo $row['Forename']; ?></td>
<td><? echo $row['Surname']; ?></td>
<td><? echo $row['Arrival_Date']; ?></td>
<td><? echo $row['Departure_Date']; ?></td>
<td><? echo $row['RoomNo']; ?></td>
<td><? echo $row['Tel']; ?></td>
</tr>
<?
}
?>
</table>
<?
//connect to database
$dbhost = 'mysql01.myhostcp.com';
$dbuser = 'deans_user1';
$dbpass = 'qwerty123';
$dbname = 'deansghot5722com5233_deansdatabase';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
//NOTE: MAKE SURE YOU DO YOUR OWN APPROPRIATE SERVERSIDE ERROR CHECKING HERE!!!
if(!empty($_POST) && isset($_POST))
{
$emptyvariables = false;
if(!empty($_POST)){
foreach($_POST as $key => $val){
if(empty($_POST[$key])){
echo"Please insert $key<br />";
$emptyvariables = true;
}
}
}
if($emptyvariables == false){
//make variables safe to insert
$id = mysql_real_escape_string($_POST['id']);
$Forename = mysql_real_escape_string($_POST['Forename']);
$Surname = mysql_real_escape_string($_POST['Surname']);
$Arrival_Date = mysql_real_escape_string($_POST['Arrival_Date']);
$Departure_Date = mysql_real_escape_string($_POST['Departure_Date']);
$RoomNo = mysql_real_escape_string($_POST['RoomNo']);
$Tel = mysql_real_escape_string($_POST['Tel']);
//query to insert data into table
$sql = "
INSERT INTO bookings
SET
id = '$id',
Forename = '$Forename',
Surname = '$Surname',
Arrival_Date = '$Arrival_Date',
Departure_Date = '$Departure_Date',
RoomNo = '$RoomNo',
Tel = '$Tel'";
echo"$query";
/*$result = mysql_query($sql);
if(!$result)
{
echo "Failed to insert record<br>Please Ensure booking does not currently exist";
}
else
{*/
echo "<td>$id</td><td>$Forename</td>$Surname<td>$Arrival_Date</td><td>$Departure_Date</td><td>$RoomNo</td><td>$Tel</td>";
//}
}
}
?>
$(document).ready(function() {
$('#myForm').ajaxForm({
success: function(responseText) {
$('#showdata tr:last').after('<tr>' + responseText + '</tr>');
}
});
});
or something like that.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join the community of 500,000 technology professionals and ask your questions.