[Resolved] MySQL Query Function

Daisatske

Hello Everyone,

First off thank you very much for reading this post and I hope you might have some resolve to my question. I am fairly new to PHP and learn pretty quickly, but I am somewhat stumped. Next, let me post my script and then describe my problem.

<?PHP
require("includes/db_config.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die('Error Connecting to Checkout Database');
mysql_select_db($db_name, $connection);
$blank = ' ';
$last_name = $_POST["last_name"];
$len = strlen($last_name);
//Only write to database is there is a name
if ($len > 0)
{
	$first_name = $_POST["first_name"];
	$equipment = $_POST["equipment"];
	$block = $_POST["block"];
	$days_have = $_POST["days_have"];
	$date = time();

	$query = "INSERT INTO sign_out (autoID, first_name, last_name, equipment, block, days_have, date_auto) VALUES (NULL, '$first_name', '$last_name', '$equipment', '$block', '$days_have', '$date')";
	mysql_query($query, $connection) or die(mysql_error());
}
?>
<html>
<head>
<title>Sign Out</title></head>

<body>
<form action="<? echo $_SERVER[PHP_SELF]; ?>" method="post">
<p>First Name:
<input type="text" name="first_name">
Last Name:
<input type="text" name="last_name">
Equipment:
<input type="text" name="equipment">
Block:
<input type="text" name="block">
Days to have equipment:
<input type="text" name="days_have">
</p>
<p><input type="submit" value="Sign Out Equipment"></p>
</form>
<br><br>
<table bgcolor="#AAAAAA" border="0" width="75%" cellspacing="1" cellpadding="2">
<?PHP
$query = "SELECT * FROM sign_out ORDER BY date_auto";
$result = mysql_query($query, $connection);
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
    $id = mysql_result($result, $i, "autoID");
	$first_name = mysql_result($result, $i, "first_name");
	$last_name = mysql_result($result, $i, "last_name");
	$equipment = mysql_result($result, $i, "equipment");
	$block = mysql_result($result, $i, "block");
	$days_have = mysql_result($result, $i, "days_have");
	$date = mysql_result($result, $i, "date_auto");
	$show_date = date("H:i:s m/d/Y", $date);

	echo '
	  <tr>
	    <td width="50%" bgcolor="#EEEEEE">
		  <font face="Tahoma" size="2">';
		  echo '<b>Name: </b>'.$first_name.$blank.$last_name;
		  echo '
		  <br>
		  <b>Equipment: </b> '.$equipment.'
		  <br>
		  <b>Block: </b> '.$block.'
		  <br>
		  <b>Days to have: </b> '.$days_have.'
		  </font>
		<td>
		<td valign="top" nowrap bgcolor="#EEEEEE">
		   <font face="Tahoma">
		     <b>Date: </b> '.$show_date.'
		   </font>
		 </td>
		<td valign="top" nowrap bgcolor="#EEEEEE">
		   <font face="Tahoma">
		     <b>Remove? </b> <a href="#" onclick="<? mysql_query(DELETE FROM `sign_out` WHERE `autoID` = $id LIMIT 1) or die(mysql_error()); ?>" target="_self">Click Here</a>
		   </font>
		 </td>
		</tr>
	  ';
}
?>

What I am working on if you can't tell is just a basic script where I am pulling data from a database called 'checkout' and from a table called 'sign_out'. I have everything happily running except for this part.

<td valign="top" nowrap bgcolor="#EEEEEE">
<font face="Tahoma">
<b>Remove? </b> <a href="#" onclick="<? mysql_query(DELETE FROM sign_out WHERE autoID = $id LIMIT 1) or die mysql_error()); ?>" target="_self">Click Here</a>
</font>
</td>

I am trying to tell it to drop the field depending on its autoID through a mysql_query in an <a href"#"></a>. I tell it to go nowhere which it doesnt but it doesn't seem to drop the field. If anyone could help me with this please post soon. I appreciate any help I can get with this problem. Thank you very much.

Daisatske

thorpe

the onclick event is client side, while php is server side. you will need to make your link point to a file that holds your script to delete the record.

just pass the $id through the querystring.

<a href="deletescript.php?id=<?php $id ?>">clickc here</a>

Daisatske

Ok I see. So once I do that. Inside the deletescript.php I would do this:

<?PHP

require("includes/db_config.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die('Error Connecting to Checkout Database');
mysql_select_db($db_name, $connection);

$id = $HTTP_GET_VARS['id'];

mysql_query(DELETE FROM sign_out WHERE autoID = $id LIMIT 1) or die(mysql_error());

First, is that right?

Second, how can I make it redirect back to the script I was originally at after it deletes it?

Daisatske

bodzan

...and use header() function to redirect page where you want it to go...

Basically:

header("Location: page_you_want_to_go.php?info=Message you want to post there&&var=Some other variables");

Daisatske

Oh, I see. Thank you all very much. I would request this topic be left open until I finish the script. Thank you all.

Daisatske

bodzan

There is a link bellow that says "Mark Thread Resolved" and it can be pressed only by you as a thread starter. So feel free to leave it open but once you've done with it click this link to mark thread resolved...

So other users can see that issue is solved so they might find an answer in it...

Daisatske

Umm, I seem to be having an issue with my delete script. Could anyone tell me what is wrong? I get the error that there is an unexpected T_STRING error on line 9 which is the MYSQL query line.

<?PHP

require("includes/db_config.php");
$connection = mysql_connect($db_host, $db_user, $db_pass) or die('Error Connecting to Checkout Database');
mysql_select_db($db_name, $connection);

$id = $HTTP_GET_VARS['id'];

mysql_query(DELETE FROM sign_out WHERE autoID = $id LIMIT 1) or die(mysql_error());

header("Location:ad_sign_out.php");

?>

Kudose

mysql_query("DELETE FROM `sign_out` WHERE `autoID` = '$id' LIMIT 1") or die(mysql_error());

Your query needs to be enclosed by quotes.

Also, $HTTP_GET_VARS is depreciated.

Use $_GET

Daisatske

Ahh, thank you very much. All done here.