Online PHP editor | rfc for UaGjc

<?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"); } ?>

3v4l.org

Active branches

Archived branches