Like this code?
Show the author your appreciation.
<?php
= "general_suraj" ; // Database name
$connection = mysql_connect ( "hostname" , "username" , "password" ) or die( "I Couldn't connect" );
$db = mysql_select_db ( $db_name , $connection ) or die( "I Couldn't select your database" );
$branch = "emp_branch" ; // Table name
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<?
include( "conn.php" );
$sql = "select sn,branchname,shortname from $branch order by sn" ;
$result = mysql_query ( $sql , $connection ) or die( mysql_error ());
$row = mysql_fetch_array ( $result )) {
?>
<tr>
<? echo $row [ 'sn' ]; ?> " type="checkbox" class="check"></td>
<? echo $row [ 'branchname' ]; ?> </td>
<? echo $row [ 'shortname' ]; ?> </td>
<? echo "form.php?sn=" . $row [ 'sn' ]. "&mode=update" ; ?> ">Update</a></td>
<? } ?>
<tr>
<?php
include( "conn.php" );
$recsno = $_GET [ "recsno" ];
$data = trim ( $recsno );
$ex = explode ( " " , $data );
$size = sizeof ( $ex );
$i = 0 ; $i < $size ; $i ++) {
$id = trim ( $ex [ $i ]);
$sql = "delete from $branch where sn=' $id '" ;
$result = mysql_query ( $sql , $connection ) or die( mysql_error ());
header ( "location: index.php" );
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<?
= $_GET [ "mode" ];
$mode == "add" ) {
?>
<form name="form1" method="post" action="formsubmit.php?mode=add">
<?
} else {
"conn.php" );
$sn = $_GET [ "sn" ];
$sql = "select sn,branchname,shortname from $branch where sn=' $sn '" ;
$result = mysql_query ( $sql , $connection ) or die( mysql_error ());
$row = mysql_fetch_array ( $result )) {
$sn = $row [ 'sn' ];
$branchname = $row [ 'branchname' ];
$shortname = $row [ 'shortname' ];
?>
<form name="form1" method="post" action="formsubmit.php?mode=update">
<? echo $sn ; ?> ">
<? echo $branchname ; ?> "></td>
<? echo $shortname ; ?> "></td>
<?
}
?>
<?php
include( "conn.php" );
$mode = $_GET [ "mode" ];
$mode == "add" ) {
$branchname = $_POST [ "branchname" ];
$shortname = $_POST [ "shortname" ];
$sql = "insert into $branch (branchname,shortname) values(' $branchname ',' $shortname ')" ;
$result = mysql_query ( $sql , $connection ) or die( mysql_error ());
header ( "location: index.php" );
$mode == "update" ) {
$branchname = $_POST [ "branchname" ];
$shortname = $_POST [ "shortname" ];
$sn = $_POST [ "sn" ];
$sql = "update $branch set branchname=' $branchname ',shortname=' $shortname ' where sn=' $sn '" ;
//echo $sql;
$result = mysql_query ( $sql , $connection ) or die( mysql_error ());
header ( "location: index.php" );
?>
// Javascript File Script.js
Pull Down Surfing - Surf on Change Categories : Java Script , MySQL , HTML and PHP , PHP , Databases A Simple sign up script with PHP and JavaScript validations. Categories : PHP , Java Script , MySQL , Databases Linked comboboxes with php-mysql & javascript Categories : PHP , Java Script , Databases , MySQL AJAX Data Grid System using php and mysql. A complete login system with the ability to display data in a grid using ajax. Add , update and delete the records without reloading the page. Categories : PHP , AJAX , Databases , MySQL , Java Script bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL , PHP , MySQL , Complete Programs , Databases Building dynamic menus with PHP & MySQL (ADO), JavaScript and CSS Categories : PHP , Databases , MySQL , Java Script , User Interface This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases , MySQL , Complete Programs , PHP , Databases Identify and log search engine access (spiders, robots, etc.) to a page. Categories : HTTP , Environment Variables , PHP , MySQL , Databases Simple db results paging example Categories : PHP , MySQL , Databases , Form Processing A simple script to count and report hits and the last
modification time of an HTML page. Requires MySQL support
(other DBs should work too, except possibly mSQL). Categories : HTTP , MySQL , PHP , Databases Convert a File database into MySQL Categories : PHP , Filesystem , Databases , MySQL , Beginner Guides for each record, do this to the first record, and do that to any subsequent record Categories : PHP , Databases , MySQL , Beginner Guides DBXML- A Class to backup databases in XML Format using web interface Categories : PHP , PHP Classes , Databases , MySQL , XML Displaying records of database in more than one page (paging) Categories : Databases , MySQL , PHP Multiple Search using PHP and Mysql Categories : PHP , Databases , General SQL , MySQL
carlos avila wrote : 1872
can you provide a sample DB schema for newbies.
ec tech wrote : 1934
something wrong in index.php, it is unable to get data from database
