help

[djbuddhi]

When typing “+65 6225 0428” as the far fax number filed when submit data to my sql in the php page it gives an eeror in the php code .

 

 

How to prevent the above error

 

[mmarif4u]

Show us your code...

[conker87]

Code? Error messages?

 

Need more info please.

[djbuddhi]

i just used $_POST['telno'];

 

it gives an error of mysql insert error

[trq]

Post your code for the query as well, we need the relevant code!

[djbuddhi]

in the insert quey i have put addslashes($_POST['telno'])

 

i want o insert telephone numbers like this

 

+44 (0) 20 8300 7744 (24hrs)

[ILYAS415]

hehe lol post your full code

[djbuddhi]

  $sever_name=ucwords(strtolower($_POST['agent_name']));

  $server_address=addslashes(trim(($_POST['set_address']));

  $se_telno=addslashes(($_POST['set_ag_telno']);

  $set_faxno=addslashes(($_POST['set_ag_fax_no']);

  $set_email=($_POST['set_ag_email_no'];

  $setl_id=($_POST['settle_agent'];

  $set_townid=($_POST['mytown'];

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  $blank_check=checkblank($sever_name,$server_address,$se_telno,$set_faxno,$set_email,$setl_id,$set_townid);

 

  if($blank_check==true){

$er_msges="<br/><br/> <font size=2 color=#FF0000><b> Error In Data Submitting ...! Please Try Again ..! </b> </font><br/><br/><br/>";

  }

  else{

                  if (!preg_match("/\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/",$set_email)){

  $er_msges="<b><font size=2 color=#FF0000>E-mail Address :".' '.' '.$set_email." Not a valid Email Address Format...! </font></b>";

}

  else{

 

          //$check_exixts=check_server_argent_exits($sever_name);

        //if($check_exixts ==true ){

      $er_msges= "<b><font size=2 color=#FF0000>Server agent ".' '.' '.$sever_name." Exists in the system ...! </font></b>";

 

      //}

//else{

 

        $query_101 = "INSERT INTO ual_admin_server_agent (ad_server_agent_name,ad_server_agent_address,ad_server_agent_telno,ad_server_agent_fax_no,ad_server_agent_email,ad_server_agent_settle_agent_id,ad_server_agent_town_id,ad_server_agent_modify_status,ad_server_agent_del_status,ad_server_agent_ustate,ad_server_agent_add_date) VALUES('$sever_name','$server_address',$se_telno,$set_faxno,'$set_email',$setl_id,$set_townid,'N','N','N','$today')";

                                    $result_101 = mysql_query($query_101) ; 

 

if($result_101){

                $er_msges= "<b><font size=2s color=#000000>Server Agent".' '.' '.$sever_name." Suceessfully Saved In The System ...! </font></b>";

                  }

else{

                  $er_msges= "<b><font size=2s color=#FF0000>Server Agent".' '.' '.$sever_name." Added to the system Fails...! </font></b>";

 

}

 

 

 

// }  

 

 

 

 

 

    //} //perg web address  

 

 

    } ///preg else

   

 

 

    } //if fist else

 

     

[djbuddhi]

  $sever_name=ucwords(strtolower($_POST['agent_name']));

  $server_address=addslashes(trim(($_POST['set_address']));

  $se_telno=addslashes(($_POST['set_ag_telno']);

  $set_faxno=addslashes(($_POST['set_ag_fax_no']);

  $set_email=($_POST['set_ag_email_no'];

  $setl_id=($_POST['settle_agent'];

  $set_townid=($_POST['mytown'];

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  $blank_check=checkblank($sever_name,$server_address,$se_telno,$set_faxno,$set_email,$setl_id,$set_townid);

 

  if($blank_check==true){

$er_msges="<br/><br/> <font size=2 color=#FF0000><b> Error In Data Submitting ...! Please Try Again ..! </b> </font><br/><br/><br/>";

  }

  else{

                  if (!preg_match("/\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*/",$set_email)){

  $er_msges="<b><font size=2 color=#FF0000>E-mail Address :".' '.' '.$set_email." Not a valid Email Address Format...! </font></b>";

}

  else{

 

          //$check_exixts=check_server_argent_exits($sever_name);

        //if($check_exixts ==true ){

      $er_msges= "<b><font size=2 color=#FF0000>Server agent ".' '.' '.$sever_name." Exists in the system ...! </font></b>";

 

      //}

//else{

 

        $query_101 = "INSERT INTO ual_admin_server_agent (ad_server_agent_name,ad_server_agent_address,ad_server_agent_telno,ad_server_agent_fax_no,ad_server_agent_email,ad_server_agent_settle_agent_id,ad_server_agent_town_id,ad_server_agent_modify_status,ad_server_agent_del_status,ad_server_agent_ustate,ad_server_agent_add_date) VALUES('$sever_name','$server_address',$se_telno,$set_faxno,'$set_email',$setl_id,$set_townid,'N','N','N','$today')";

                                    $result_101 = mysql_query($query_101) ; 

 

if($result_101){

                $er_msges= "<b><font size=2s color=#000000>Server Agent".' '.' '.$sever_name." Suceessfully Saved In The System ...! </font></b>";

                  }

else{

                  $er_msges= "<b><font size=2s color=#FF0000>Server Agent".' '.' '.$sever_name." Added to the system Fails...! </font></b>";

 

}

 

 

 

// }  

 

 

 

 

 

    //} //perg web address  

 

 

    } ///preg else

   

 

 

    } //if fist else

 

     

[ILYAS415]

tsssk tssk cant read ur code.

put  [ code ] tags around it (leave the spaces i made out) basically lyk...

[code]text here[/ code]

 

make sure to remove that space i made in [/code]

[AndyB]

$result_101 = mysql_query($query_101) ;

 

Add proper error trapping to that to see what's wrong. Thus

 

$result_101 = mysql_query($query_101) or die("Error: ". mysql_error(). " with query ". $query_101);

 

What's wrong with your presently constructed query is that some of the values are wrapped with single quotes and others are not.  Wrap EACH value with single quotes and try again.

[djbuddhi]

I WANT TO INSERT TELEPHONE NUMBERS LIKE 11212111, 21112 12121 AND ITS GIVES AND ERROR .HOW TO OVER COME IT

 

[ILYAS415]

What exactly is the error?