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
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 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 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 Password reminder Categories : PHP , PHP Classes , Databases , MySQL , Mail Identify and log search engine access (spiders, robots, etc.) to a page. Categories : HTTP , Environment Variables , PHP , MySQL , Databases 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 The Ajax Tree view class fetches data from a db for the requested parent category id. The data is then stored in an array and converted into JSON (Javascript Object Notation) format. This format is then used by JavaScript for populating tree view. Categories : PHP , PHP Classes , Java Script , AJAX , Databases create a grid out of <INPUT TYPE=TEXT> then saving to a database. Uses
a 'multi-dimension array', but not really as the array is just one big array
with the index of "[$i][$j]". Have a look at the code and you'll see what I
mean. Categories : PHP , MySQL , Arrays , Databases php-gtk mysql querying tool Categories : PHP-GTK , MySQL , PHP , Databases Simple function to return the number of days in a time span between 2 given dates. Categories : PHP , Date Time , MySQL , Databases Specify your connection settings and create a link to a MySQL database. Categories : PHP , PHP Classes , Databases , MySQL , Beginner Guides
carlos avila wrote : 1872
can you provide a sample DB schema for newbies.
