@ 2014-03-26T17:31:13Z <?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"); }
?>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.33 , 7.1.0 - 7.1.33 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.27 , 8.2.0 - 8.2.17 , 8.3.0 - 8.3.4 Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/UaGjc:2
Stack trace:
#0 {main}
thrown in /in/UaGjc on line 2
Process exited with code 255 . Output for 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.0 - 5.5.38 , 5.6.0 - 5.6.40 Fatal error: Call to undefined function mysql_connect() in /in/UaGjc on line 2
Process exited with code 255 . preferences:dark mode live preview
250.3 ms | 402 KiB | 403 Q