Guest User

Untitled

a guest
Jul 21st, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. id name dob gen
  2. 1 James 12-03-1977 M
  3. 2 James 12-03-1977 M
  4. 3 James 12-03-1977 M
  5.  
  6. class Detail
  7. {
  8. function savePerson_detail($vars){
  9. foreach($vars as $key => $value){
  10. if(is_numeric($key) && $value >0){
  11. $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')",
  12. mysql_real_escape_string($vars['name']),
  13. mysql_real_escape_string($vars['dob']),
  14. mysql_real_escape_string($vars['gen']));
  15. mysql_query($qry) or die(mysql_error());
  16. if($qry)
  17. {
  18. print 'Successfully Insert your details';
  19. }
  20. }
  21. }
  22.  
  23. <?php
  24. $detail = new Detail();
  25. if(isset($_POST['btnSaveDetail'])){
  26. $detail->savePerson_detail($_POST);
  27. }?>
  28.  
  29. function savePerson_detail($vars)
  30. {
  31. // validate function input
  32. foreach($vars as $key => $value)
  33. {
  34. if(!is_numeric($key) || !$value >0)
  35. return;
  36. }
  37.  
  38. // build sql query
  39. $qry = sprintf(
  40. "INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')",
  41. mysql_real_escape_string($vars['name']),
  42. mysql_real_escape_string($vars['dob']),
  43. mysql_real_escape_string($vars['gen'])
  44. );
  45.  
  46. // run sql query
  47. $result = mysql_query($qry) or die(mysql_error());
  48.  
  49. // check query result
  50. if($result)
  51. {
  52. print 'Successfully Insert your details';
  53. }
  54. }
  55.  
  56. foreach($vars as $key => $value){
  57.  
  58. $_POST['name'] = 'James';
  59. $_POST['dob'] = '12-03-1977';
  60. $_POST['gen'] = 'M';
  61.  
  62. function savePerson_detail($vars){
  63. $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')", mysql_real_escape_string($vars['name']), mysql_real_escape_string($vars['dob']), mysql_real_escape_string($vars['gen']));
  64. mysql_query($qry) or die(mysql_error());
  65. if($qry)
  66. { print 'Successfully Insert your details'; }
  67. }
  68.  
  69. class Detail
  70. {
  71. function savePerson_detail($vars) {
  72. foreach($vars as $key => $value) {
  73. $vars[$key] = mysql_real_escape_string($value);
  74. }
  75.  
  76. if($qry)
  77. {
  78. print 'Successfully Insert your details';
  79. }
  80.  
  81. $qry = sprintf("INSERT INTO cca_student_list(per_name, per_dob, per_gen) VALUES('%s', '%s', '%s')";
  82. mysql_query($qry) or die(mysql_error());
  83. }
Add Comment
Please, Sign In to add comment