::: T4VN Statistics :::
PHP Scripts : 65
PHP Example : 67
PHP Tutorials : 21
PHP News : 93
Total Coupon : 36
Other Tutorials :
Member : 266
Delete Data From Mysql with check boxs from Form
Author : llntrvr How to delete data from mysql with check boxs from a form
PHP Example : <?php
= "localhost" ; // Host name
$username = "" ; // Mysql username
$password = "" ; // Mysql password
$db_name = "test" ; // Database name
$tbl_name = "test_mysql" ; // Table name
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 );
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<?php
while( $rows = mysql_fetch_array ( $result )){
?>
<tr>
<? echo $rows [ 'id' ]; ?> "></td>
<? echo $rows [ 'id' ]; ?> </td>
<? echo $rows [ 'name' ]; ?> </td>
<? echo $rows [ 'lastname' ]; ?> </td>
<? echo $rows [ 'email' ]; ?> </td>
<?php
}
?>
<tr>
<?
// Check if delete button active, start this
if( $delete ){
$i = 0 ; $i < $count ; $i ++){
$del_id = $checkbox [ $i ];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'" ;
$result = mysql_query ( $sql );
// if successful redirect to delete_multiple.php
if( $result ){
"<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">" ;
mysql_close ();
?>
</table>
Other Example Emoticon Making
Dynamic CSS PHP Script
Include layout
PHP File Security for Includes
Retrieving ID from Query String Non Register Globals
Custom colors
::: Resources :::
::: New Templates :::
::: Other Tutorials :::
Home
