<?php
########### INSTRUCTIONS #############
/*
Run follwing two queries on your sample database or test datatbase then make connection and run this page on your browser
create table test(TestID smallint unsigned not null PRIMARY KEY auto_increment,TestName varchar(20) not null default '',Priority tinyint(3) unsigned not null default 0)
INSERT INTO `gatloding`.`test` (`TestID`, `TestName`, `Priority`) VALUES (NULL, 'Test1', '1'), (NULL, 'Test2', '2'), (NULL, 'Test3', '3'), ('4', 'Test4', '4'), ('5', 'Test5', '5')
*/
#######################################
include("connection.php");
include("priority.php");
$tableName = "test";
$fieldName = "Priority";
$primaryKey = "TestID";
$priorityObj = new priority($tableName,$fieldName,$primaryKey);
/*****To update priority or serial no*/
$id = 4;
$serialNo = 1;
$oldSerialNo = 4;
$priorityObj -> updatePriority($id,$serialNo,$oldSerialNo);
/***************************/
/*****To maintain priority/serialno when we delete a PrimaryID*/
//Please uncomment following two lines for delete
//$id = 3;
//$priorityObj -> deletePriority($id);
/**************************/
echo "Done successfully";
?>
|
Stumble It!
Bookmark in del.icio.us
Download
