- Edited
Create user
goto http://localhost/phpmyadmin(http://localhost/phpmyadmin)
under privileges tab create new user with password..
- Edited
Really Cool
wow... Its really cool... thumb up
- Edited
waiting to have client login base ticket system soon..
Thank you,,,..!
- Edited
Add autocomplete with new field
Hi is any one know how to add autocomplete option with newly added field on page newticket.inc.php
i hv done follow steps:
update JS function on newticket.inc.php
callback: function (obj) { document.getElementById('email').value = obj.id; document.getElementById('name').value = obj.info; document.getElementById('client_id').value = obj.client_id; return false;}
client_id is my new field
Step 02
update ajax.ticket.php and modify function searchbyemail($params) {
function searchbyemail($params) {$input = db_input(strtolower($params),false);
$len = strlen($input);
$limit = isset($params) ? (int) $params;
$items=array();
$sql='SELECT DISTINCT email,name,client_id FROM '.TICKET_TABLE.' WHERE email LIKE \''.$input.'%\' ORDER BY created LIMIT '.$limit;
$resp=db_query($sql);
if($resp && db_num_rows($resp)){
while(list($email,$name,$client_id)=db_fetch_row($resp)) {
$name=(strpos($name,'@')===false)?$name:'';
$client_id=(strpos($client_id,'@')===false)?$client_id:'';
$items ='{"id": "'.$email.'", "value": "'.$email.'", "info": "'.$name'", "client": "'.$client_id.'" }';
}
}
$result= '{"results": }';
return $result;
}
But i get Undefined as a result for that particular field...plz help