File: example.php

Recommend this page to a friend!
  Classes of Gautam Lohar  >  Automatic Priority Setting in any table Modified  >  example.php  >  Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Example
Class: Automatic Priority Setting in any table Modified
Update or delete MySQL records with given priority
Author: By
Last change:
Date: 6 years ago
Size: 1,327 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 = "product_parts";
   
$fieldName = "unique_ids";
   
$primaryKey = "part_id";
   
   
   
$priorityObj = new priority($tableName,$fieldName,$primaryKey);
   
$a_condiotionIDs = array('product_sku'=>'DVP8922');

   
   
/*****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 = 604;
   
$priorityObj -> deletePriority($id,$a_condiotionIDs);
   
/**************************/

   
echo "Done successfully";

?>

For more information send a message to info at phpclasses dot org.