Code: Select all
$query = "SELECT * FROM table_name WHERE name='$where'";Code: Select all
$query = "SELECT * FROM table_name WHERE name='".$where."'";Code: Select all
$query = 'SELECT * FROM table_name WHERE name=\''.$where.'\'';Moderator: General Moderators
Code: Select all
$query = "SELECT * FROM table_name WHERE name='$where'";Code: Select all
$query = "SELECT * FROM table_name WHERE name='".$where."'";Code: Select all
$query = 'SELECT * FROM table_name WHERE name=\''.$where.'\'';definitely yeswhen the outcome is posted, is it posibble that beside every record I could have a button or a link to delete that specific record?
Code: Select all
<?php
$link = mysql_connect('host_name', 'user', 'pass')
or die(mysql_error());
mysql_select_db('db_name');
$where = mysql_real_escape_string ($_POST['name']);
$query = 'SELECT * FROM table_name WHERE name=\''.$where.'\'';
$sql = mysql_query($query);
if (!$sql) {
die('Invalid query: ' . mysql_error());
}
while ($row = mysql_fetch_object($sql)) {
//print your data as you like
echo $row->field_name1." <a href=delete.php?del=$row->fieldname2>Delete</a> <br/>";
}
?>Code: Select all
<?php
$link = mysql_connect('host', 'user', 'pass')
or die(mysql_error());
mysql_select_db('db_name');
$where = mysql_real_escape_string ($_POST['del']);
$query = 'DELETE FROM table_name WHERE fieldname2=\''.$where.'\'';
$sql = mysql_query($query);
if (!$sql) {
die('Invalid query: ' . mysql_error());
}
else
echo mysql_affected_rows()." row delete succesfully";
?>Code: Select all
$where = mysql_real_escape_string ($_REQUEST['del']);
$query = 'DELETE FROM table_name WHERE fieldname=\''.$where.'\'';Code: Select all
echo "<a href=edit.php?id=".$row->field_primarykey."&name=".$row->fieldname.">Edit</a>";Code: Select all
<?php
$link = mysql_connect('hostname', 'user', 'password')
or die(mysql_error());
mysql_select_db('databasename');
$where = mysql_real_escape_string ($_REQUEST['id']);
$what = mysql_real_escape_string ($_REQUEST['name']);
?>
<form name="form" action="update.php" method="post">
<input type="text" name="name" value="<?php echo $what; ?>"/>
<input type="hidden" name="id" value="<?php echo $_REQUEST['id']; ?>" />
<input type="submit" name="Submit" value="Edit" />
</form>
<?php
mysql_close($link);
?>Code: Select all
<?php
$link = mysql_connect('hostname', 'user', 'password')
or die(mysql_error());
mysql_select_db('databasename');
$where = mysql_real_escape_string ($_REQUEST['id']);
$what = mysql_real_escape_string ($_REQUEST['name']);
$query = 'UPDATE tb_address_book
SET fieldname=\''.$what.'\' WHERE id=\''.$where.'\'';
$sql = mysql_query($query);
if (!$sql) {
die('Invalid query: ' . mysql_error());
}
else
echo mysql_affected_rows()." update succesfully";
mysql_close($link);
?>