Guest User

Untitled

a guest
Oct 29th, 2018
570
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.63 KB | None | 0 0
  1. $name="Kumkum";
  2. $email="kumkum@gmail.com";
  3. $phone="3456734567";
  4. $country="India";
  5. $course="Database";
  6. $message="hello i want to read db";
  7. $now = new DateTime();
  8. $datesent=$now->format('Y-m-d H:i:s');
  9. global $wpdb;
  10. $sql = $wpdb->prepare(
  11. "INSERT INTO `wp_submitted_form` (`name`,`email`,`phone`,`country`,`course`,`message`,`datesent`) values ("
  12. $name, $email, $phone, $country, $course, $message, $datesent. ')")';
  13.  
  14. $wpdb->query($sql);
  15.  
  16. $wpdb->insert('wp_submitted_form', array(
  17. 'name' => 'Kumkum',
  18. 'email' => 'kumkum@gmail.com',
  19. 'phone' => '3456734567', // ... and so on
  20. ));
  21.  
  22. <?php
  23. global $wpdb;
  24. $wpdb->insert("wp_submitted_form", array(
  25. "name" => $name,
  26. "email" => $email,
  27. "phone" => $phone,
  28. "country" => $country,
  29. "course" => $course,
  30. "message" => $message,
  31. "datesent" => $now ,
  32. ));
  33. ?>
  34.  
  35. $sql = $wpdb->prepare(
  36. "INSERT INTO `wp_submitted_form`
  37. (`name`,`email`,`phone`,`country`,`course`,`message`,`datesent`)
  38. values ($name, $email, $phone, $country, $course, $message, $datesent)");
  39. $wpdb->query($sql);
  40.  
  41. $sql = "INSERT INTO `wp_submitted_form`
  42. (`name`,`email`,`phone`,`country`,`course`,`message`,`datesent`)
  43. values ($name, $email, $phone, $country, $course, $message, $datesent)";
  44.  
  45. $wpdb->query($sql);
  46.  
  47. global $wpdb;
  48. $tablename = $wpdb->prefix . "submitted_form";
  49.  
  50. $name = "Kumkum"; //string value use: %s
  51. $email = "kumkum@gmail.com"; //string value use: %s
  52. $phone = "3456734567"; //numeric value use: %d
  53. $country = "India"; //string value use: %s
  54. $course = "Database"; //string value use: %s
  55. $message = "hello i want to read db"; //string value use: %s
  56. $now = new DateTime(); //string value use: %s
  57. $datesent = $now->format('Y-m-d H:i:s'); //string value use: %s
  58.  
  59. $sql = $wpdb->prepare("INSERT INTO `$tablename` (`name`, `email`, `phone`, `country`, `course`, `message`, `datesent`) values (%s, %s, %d, %s, %s, %s, %s)", $name, $email, $phone, $country, $course, $message, $datesent);
  60.  
  61. $wpdb->query($sql);
  62.  
  63. $wpdb->prepare(
  64. "INSERT INTO `wp_submitted_form`
  65. (`name`,`email`,`phone`,`country`,`course`,`message`,`datesent`)
  66. values ('$name', '$email', '$phone', '$country',
  67. '$course', '$message', '$datesent')"
  68. );
  69.  
  70. $wpdb->insert('table_name', input_array())
  71.  
  72. global $wpdb;
  73. $insert = $wpdb->query("INSERT INTO `front-post`(`id`, `content`) VALUES ('$id', '$content')");
  74.  
  75. $wpdb->insert( $table_name, array('column_name_1'=>'hello', 'other'=> 123), array( '%s', '%d' ) );
  76.  
  77. $wpdb->query("insert into ".$table_name." (name, email, country, country, course, message, datesent) values ('$name','$email', '$phone', '$country', '$course', '$message', )");
Add Comment
Please, Sign In to add comment