- ctype_digit: documentation ( source)
<?php
$link = mysql_connect('localhost', 'programmer', 'Welcome01$$$');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$selected = mysql_select_db("computergeeksrus_ticket_system",$link) ;
function clean($str){
return mysql_real_escape_string($str);
}
$wo_id=$_GET['id'];
if($wo_id && ctype_digit($wo_id)){
$wo_id=clean($wo_id);
$q1 = mysql_query("SELECT * FROM MYIT_TABLE_WORK_ORDER WHERE WORK_ORDER_ID='$wo_id'");
$data=mysql_fetch_array($q1);
$dateo=$data['WORK_ORDER_OPEN_DATE'];
$t1=$data['WORK_ORDER_TIME_SPENT'];
$s1=$data['WORK_ORDER_STATUS'];
$cid=$data['CUSTOMER_ID'];
$lastupdated=$data['LAST_ACTIVE'];
$p=$data['PRIORITY_ID'];
$s2=$data['WORK_ORDER_CURRENT_STATUS'];
/* myit_table_customer
Full texts CUSTOMER_ID Ascending CUSTOMER_DISPLAY_NAME CUSTOMER_COMPANY CUSTOMER_ADDRESS CUSTOMER_CITY CUSTOMER_STATE CUSTOMER_ZIP CUSTOMER_PHONE CUSTOMER_WORK_PHONE CUSTOMER_MOBILE_PHONE CUSTOMER_EMAIL CUSTOMER_WWW CREDIT_TERMS CUSTOMER_NOTES CUSTOMER_TYPE CUSTOMER_FIRST_NAME CUSTOMER_MIDDLE_NAME CUSTOMER_LAST_NAME CUSTOMER_TITLE CREATE_DATE LAST_ACTIVE DISCOUNT CUSTOMER_REFERRED_BY CUSTOMER_REFERRALS
*/
?>
<table>
<tr>
<td>Name</td>
<td>Date Opened</td>
<td>Time Spent</td>
<td>Last Updated</td>
<td>Status</td>
<td>Priority</td>
</tr>
<tr>
<td></td>
<td><?=$dateo?></td>
<td>WORK_ORDER_TIME_SPENT</td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
<?php
} else { die("invalid parameters"); }
?>