var php_params = "job=SearchForm&task=PartialForm&tablename=Customer&uniq_field_value="+cust_name ;
var fields_to_BU = ['cust_name', 'cust_desig_2char', 'cust_desig_3char', 'region'] ;
var customer_id ;
$('#debug').html(php_params) ;
$.ajax({
url: '/cmdb/PHP/do_FormSearch_query.php',
method: "GET" ,
cache: false ,
data: encodeURIComponent(php_params) ,
dataType: 'JSON'
}).done(function(data)
{
alert("HERE THREE!");
customer_id = data.customer_id ;
$('input [name=cust_desig_2char]').val(data.cust_desig_2char) ;
$('input [name=cust_desig_3char]').val(data.cust_desig_3char) ;
$('input [name=region]').val(data.region) ;
$('#RtMgn_Customer').val(customer_id) ;
blah blah blah;
}) ; // EO AJAX .done function()
case "PartialForm":
$uniq_field_value = htmlspecialchars($_GET['uniq_field_value']) ;
$tablename = htmlspecialchars($_GET['tablename']) ;
switch($tablename)
{
case 'Customer':
do_mysql_multi("SELECT * FROM Customer WHERE `cust_name`= '".$uniq_field_value."' ;", 1, $result_vector1, $result_vector2) ;
echo json_encode($result_vector1['values'][1]) ;
break ;
What PHP returns (sample):
{"customer_id":"76","cust_name":"QATAR AIRWAYS","cust_desig_2char":"QR","cust_desig_3char":"QTR","region":"Middle East","note_id":"75750"}
.done(function(data)
{
alert("HERE THREE!");
$.ajax({
url: '/cmdb/PHP/do_FormSearch_query.php',
method: "GET" ,
cache: false ,
data: {job : "SearchForm", task : "PartialForm", tablename : "Customer", uniq_field_value : cust_name } ,
dataType: 'JSON'
}).done(function(data)
{
alert("HERE THREE!");
customer_id = data.customer_id ;
$('input [name=cust_desig_2char]').val(data.cust_desig_2char) ;
$('input [name=cust_desig_3char]').val(data.cust_desig_3char) ;
$('input [name=region]').val(data.region) ;
$('#RtMgn_Customer').val(customer_id) ;
blah blah blah;
}) ; // EO AJAX .done function()
// -----------------------------------------------------------------------------------------------
var php_params = "job=SearchForm&task=FullForm&offset="+offset+"&tablename=Customer&where_clause=" ;
var where_clause= "WHERE " ;
if (cust_name != "") { where_clause = where_clause+"cust_name LIKE '%"+cust_name+"%' AND " ; }
if (cust_desig_2char != "") { where_clause = where_clause+"cust_desig_2char LIKE '%"+cust_desig_2char+"%' AND " ; }
if (cust_desig_3char != "") { where_clause = where_clause+"cust_desig_3char LIKE '%"+cust_desig_3char+"%' AND " ; }
// -----------------------------------------------------------------------------------------------
if (where_clause.length < 10)
{
alert("Please enter a searchable value into a field that may uniquely identify a Customer.") ;
throw "No data to search with." ;
}
var plen=where_clause.length ;
where_clause=where_clause.substring(0,plen-1-4) ;
php_params=php_params+encodeURIComponent(where_clause) ;
$('#debug').html(php_params) ;
Certainly I could uriencode the data w/in my where_clause, but will I then run into % and ' problems?
https://www.codecademy.com/en/forum_questions/557f4c80e39efe11060000a2