guys can u help me out hir...

aian04

<html>
<head></head>
<body bgcolor="AntiqueWhite">
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="tmc"; // Mysql password
$db_name="mariosdb"; // Database name
$tbl_name="mariobookings"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);
$id='bookingID';
$name='guestName';
$no='guestContact';
$date='bookingDate';
$time='bookingTime';
$row='list($id, $name, $no, $date, $time)=';
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>

<td colspan="6" bgcolor="#FFFFFF" align=center><strong>Delete Reservation</strong> </td>
</tr>
<tr>
<td></td>
<td align="center" bgcolor="#FFFFFF" colspan="">Reservatio ID</td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Contact</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Date</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Time</strong></td>
</tr>
<?php
while($rows=mysql_fetch_row($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['$id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['$id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['$name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['$contact']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['$date']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['$time']; ?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="6" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
$delete='DELETE from mariobookings where bookingID=$id';
// Check if delete button active, start this
if($delete){
for($i=0; $i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE mariobooking='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv="refresh" content="0;URL=ss.php">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

</body>
</html>

it didnt show the datas in table...

sheephat

Unchanged:

<html> 
<head></head> 
<body bgcolor="AntiqueWhite"> 
<?php 
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="tmc"; // Mysql password 
$db_name="mariosdb"; // Database name 
$tbl_name="mariobookings"; // Table name 

// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 

$sql="SELECT * FROM $tbl_name"; 
$result=mysql_query($sql); 

$count=mysql_num_rows($result); 
$id='bookingID'; 
$name='guestName'; 
$no='guestContact'; 
$date='bookingDate'; 
$time='bookingTime'; 
$row='list($id, $name, $no, $date, $time)='; 
?> 
<table width="400" border="0" cellspacing="1" cellpadding="0"> 
<tr> 
<td><form name="form1" method="post" action=""> 
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"> 
<tr> 

<td colspan="6" bgcolor="#FFFFFF" align=center><strong>Delete Reservation</strong> </td> 
</tr> 
<tr> 
<td></td> 
<td align="center" bgcolor="#FFFFFF" colspan="">Reservatio ID</td> 
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td> 
<td align="center" bgcolor="#FFFFFF"><strong>Contact</strong></td> 
<td align="center" bgcolor="#FFFFFF"><strong>Date</strong></td> 
<td align="center" bgcolor="#FFFFFF"><strong>Time</strong></td> 
</tr> 
<?php 
while($rows=mysql_fetch_row($result)){ 
?> 
<tr> 
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['$id']; ?>"></td> 
<td bgcolor="#FFFFFF"><? echo $rows['$id']; ?></td> 
<td bgcolor="#FFFFFF"><? echo $rows['$name']; ?></td> 
<td bgcolor="#FFFFFF"><? echo $rows['$contact']; ?></td> 
<td bgcolor="#FFFFFF"><? echo $rows['$date']; ?></td> 
<td bgcolor="#FFFFFF"><? echo $rows['$time']; ?></td> 
</tr> 
<?php 
} 
?> 
<tr> 
<td colspan="6" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td> 
</tr> 
<? 
$delete='DELETE from mariobookings where bookingID=$id'; 
// Check if delete button active, start this 
if($delete){ 
for($i=0; $i<$count;$i++){ 
$del_id = $checkbox[$i]; 
$sql = "DELETE FROM $tbl_name WHERE mariobooking='$del_id'"; 
$result = mysql_query($sql); 
} 

// if successful redirect to delete_multiple.php 
if($result){ 
echo "<meta http-equiv="refresh" content="0;URL=ss.php">"; 
} 
} 
mysql_close(); 
?> 
</table> 
</form> 
</td> 
</tr> 
</table> 

</body> 
</html>

aian04

<html>
<head><style type="text/css">
b {color:black}
</style>
</head>
<body bgcolor="AntiqueWhite">
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="tmc"; // Mysql password
$db_name="mariosdb"; // Database name
$tbl_name="mariobookings"; // Table name

// Connect to server and select databse.
mysql_pconnect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);
$id='bookingID';
$name='guestName';
$no='guestContact';
$date='bookingDate';
$time='bookingTime';

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>

<td colspan="6" bgcolor="#FFFFFF" align=center><strong>Delete Reservation</strong> </td>
</tr>
<tr>
<td></td>
<td align="center" bgcolor="#FFFFFF"><strong>Reservatio ID</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Contact</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Date</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Time</strong></td>
</tr>
<?php
while(list($id, $name, $no, $date, $time)=mysql_fetch_row($result)){
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['$id']; ?>"></td>
<td bgcolor="#FFFFFF"><b><? echo $rows['$id']; ?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $rows['$name']; ?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $rows['$no']; ?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $rows['$date']; ?></b></td>
<td bgcolor="#FFFFFF"><b><? echo $rows['$time']; ?></b></td>
</tr>
<?php
}
?>
<tr>
<td colspan="6" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE mariobooking='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=ss.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

</body>
</html>

it is really not working...

sheephat

echo "<meta http-equiv=\"refresh\" content=\"0;URL=ss.php\">";

this line is wrong you end it early here: content=\"0;URL, the ; ends the process.

What error do you get if any?

aian04

there is no error msg but it doesnt even change... in my db table ryt... for e.g i have 5 datas in my db table.. den in my web table i hav 5 checkbox in a table but the data is not shown its empty... den when i click delete.. it just refresh d page

sheephat

$rows['$id']; is not defined, the $rows variable is not defined in the while loop.

aian04

<?
require_once('db.php');
session_start(); // start session, duh.
?>

<html>
<head>
<title>Login</title>
<link href="css/index.css" rel="stylesheet" type="text/css">
<head>
<body>
<?
if(!isset($username) | !isset($password)) {
// escape from php mode.
?>
<h1 align="center"><img src="images/chef2.gif" height="130" width="136"></h1>
<h3 class="link">Staff Login</h3>
<form class="form" action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST">

		<input type="hidden" name="_submit_check" value="1"/> 

		<div style="margin-top:12px; margin-bottom:10px">
			<img src="images/username.gif" alt="username" border="0" />
			<input class="input" type="text" name="staffID" id="staffID" size="25" maxlength="40" value="" />
		</div>
		<div style="margin-bottom:6px">
			<img src="images/password.gif" alt="password" border="0" />
			<input class="input" type="password" name="password" id="password" size="25" maxlength="32" />

		</div>
		<input type="image" name="Login" value="Login"  class="submit-btn" src="images/btn.gif" alt="submit" title="submit" />


	</form>

</body>
</html>
<?
exit();
}
// If all is well so far.

session_register("username");
session_register("password"); // register username and password as session variables.

// Here you would check the supplied username and password against your database to see if they exist.
// For example, a MySQL Query, your method may differ, obviously you would make a dataabse connection first.

$sql = mysql_query("SELECT password FROM mariosstaff WHERE username = '$username'");
$fetch_em = mysql_fetch_array('$databases',$sql);
$numrows = mysql_num_rows($sql);

if($numrows != "0" & $password == $fetch_em["password"]) {
$valid_user = 1;
}
else {
$valid_user = 0;
}
// If the username exists and pass is correct, don't pop up the login code again.
// If info can't be found or verified....

if (!($valid_user))
{
session_unset(); // Unset session variables.
session_destroy(); // End Session we created earlier.
// escape from php mode.
?>
<form class="form" action="<?=$PHP_SELF?><?if($QUERY_STRING){ echo"?". $QUERY_STRING;}?>" method="POST">
<p align="center" color="red"><strong>Incorrect login information, please try again.</strong></p>
<div id="container">

		<input type="hidden" name="_submit_check" value="1"/> 

		<div style="margin-top:12px; margin-bottom:10px">
			<img src="images/username.gif" alt="username" border="0" />
			<input class="input" type="text" name="staffID" id="staffID" size="25" maxlength="40" value="" />
		</div>
		<div style="margin-bottom:6px">
			<img src="images/password.gif" alt="password" border="0" />
			<input class="input" type="password" name="password" id="password" size="25" maxlength="32" />

		</div>
		<input type="image" name="Login" value="Login"  class="submit-btn" src="images/btn.gif" alt="submit" title="submit" />


	</form>

</body>
</html>
<?
exit();
}