query($query); // $numresult=$result->num_rows; //ELSE $result=mysql_query($query); $numresult=mysql_num_rows($result); //ENDIF if ($numresult==1) { //IF MYSQLI //$row=$result->fetch_assoc(); //ELSE $row=mysql_fetch_assoc($result); //ENDIF $count=$row['COUNT']; if ($count==1) { //Set authorization and username $_SESSION['$username']=$username; } $row=null; $count=null; } $numresult=null; $result=null; $query=null; } //Session should be setup now $username=$_SESSION['$username']; if (!isset($username)) die ('Username or Password not recognized.'); $timestampnew=$_SESSION['$timestampnew']; $timestampnewp=null; if (isset($timestampnew)) { $timestampnewp=$timestampnew; } $savemessage=' - Replace an old stamp with the new stamp and save changes.'; //Query //IF MYSQLI //if (!isset($db)) $db=new mysqli('localhost', 'inters_php', 'flask3301', 'inters_Flask'); //ELSE if (!isset($link)) { $link = mysql_connect('localhost', 'inters_php', 'flask3301') or die('Could not connect: ' . mysql_error()); mysql_select_db('inters_Flask') or die('Could not select database'); } //ENDIF $query="select Guid,Slot,Timestamp,Active,Lastlocation,Lasttime from Package where user='".addslashes($username)."'"; //IF MYSQLI //$result=$db->query($query); //ELSE $result=mysql_query($query); //ENDIF if (!$result) die ($query); //IF MYSQLI //$numresult=$result->num_rows; //ELSE $numresult=mysql_num_rows($result); //ENDIF if ($numresult!=5) die ('Unexpected number of slots: '.$numresult); for($i=0; $i<5; $i++) { //IF MYSQLI // $row=$result->fetch_assoc(); //ELSE $row=mysql_fetch_assoc($result); //ENDIF $guid=$row['Guid']; $slot=$row['Slot']; $timestamp=$row['Timestamp']; $active=$row['Active']; $lastlocation=$row['Lastlocation']; $lasttime=$row['Lasttime']; if ($timestamp=='') $timestamp='0000-00-00 00:00:00'; //format NULL if ($timestamp=='0000-00-00 00:00:00') $active=false; if ($timestampnew==$timestamp) $timestampnew=null; //already assigned, and no 0 above //echo 'DBG isset($timestampnew)='.isset($timestampnew); //echo 'DBG $timestamp==\'0000-00-00 00:00:00\'='.$timestamp=='0000-00-00 00:00:00'; //echo 'DBG !$_SESSION[\'$timestampnewassigned\']='.!$_SESSION['$timestampnewassigned']; if (isset($timestampnew) && $timestamp=='0000-00-00 00:00:00' && !$_SESSION['$timestampnewassigned']) { $timestamp=$timestampnew; $timestampnew=null; $active=true; $slotnew=$slot; $savemessage=' - Click Save Changes to save the new stamp.'; //echo 'DBG $slotnew='.$slotnew; } $slotvar='guid'.$slot; $$slotvar=$guid; $slotvar='timestamp'.$slot; $$slotvar=$timestamp; $slotvar='active'.$slot; $$slotvar=$active; $slotvar='lastlocation'.$slot; $$slotvar=$lastlocation; $slotvar='lasttime'.$slot; $$slotvar=$lasttime; } $result=null; //IF MYSQLI //$db->close(); //ELSE mysql_close($link); //ENDIF $_SESSION['$guid']=$guid1; $_SESSION['$timestampnewassigned']=true; //echo 'timestampnewassigned:'; //echo $_SESSION['$timestampnewassigned']; ?>

SQL Offline - Package Receipt

Sender Name:
Sender ID:


 Slot   Stamp   Active   Date Last Opened   Location Opened 
1 >
2 >
3 >
4 >
5 >

Time:, from: .