Advanced Search

Escaping Multiple Post Values for MySQL with PHP

/ Published in: PHP
Save to your folder(s)
This is useful for escaping multiple values in a POST array.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. foreach($_POST['your_array_here'] as &$val) {
  2.      $val = mysql_real_escape_string($val);
  3. }
  4.  
  5. // FORM FIELDS EXAMPLE
  6. <input type="text" name="field[p_name]" id="field[p_name]" />
  7. <input type="text" name="field[p_email]" id="field[p_email]" />
  8.  
  9. // PHP PROCESSING EXAMPLE
  10. function process_form() {
  11.      foreach($_POST['field'] as &$val) {
  12.           $val = mysql_real_escape_string($val);
  13.      }
  14.  
  15.      extract($_POST['field']);
  16.  
  17.      $sql = "INSERT INTO my_table (name, email) VALUES ('$p_name', '$p_email')";
  18.  
  19.      mysql_query($sql) or die ('An error has occurred');
  20. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.