PHP Classes

File: example

Recommend this page to a friend!
  Classes of Gautam Lohar   Automatic Priority Setting   example   Download  
File: example
Role: Example script
Content type: text/plain
Description: example to use the class
Class: Automatic Priority Setting
Update priority records in a MySQL database table
Author: By
Last change:
Date: 14 years ago
Size: 1,236 bytes
 

Contents

Class file image Download
<?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";

?>