Advertisement
Guest User

Untitled

a guest
Jul 9th, 2017
491
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. Array
  2. (
  3. [nome] => Nome
  4. [sobrenome] => Sobrenome
  5. [genero] => 1
  6. [email] => email@mail.com
  7. )
  8.  
  9. INSER INTO tabela (nome, sobrenome, genero, email) VALUES ('$nome', ...)
  10.  
  11. foreach ($data as $key => $value){
  12. $keys = $keys.$key.",";
  13. $values = $values.$values.",";
  14. }
  15. $keys = substr($keys, 0,-1);
  16. $values = substr($values, 0,-1);
  17.  
  18. INSER INTO tabela ('$keys') VALUES ('$values');
  19.  
  20. $data = array(
  21. 'nome' => 'Nome',
  22. 'sobrenome' => 'Sobrenome',
  23. 'genero' => 1,
  24. 'email' => 'email@mail.com'
  25. );
  26.  
  27. $sql = sprintf(
  28. "INSERT INTO tabela (%s) VALUES ('%s');",
  29. implode(',', array_keys($data)),
  30. implode("','", array_values($data))
  31. );
  32.  
  33. // função principal
  34. function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {
  35. reset($data);
  36. if ($action == 'insert') {
  37. $query = 'insert into ' . $table . ' (';
  38. while (list($columns, ) = each($data)) {
  39. $query .= $columns . ', ';
  40. }
  41. $query = substr($query, 0, -2) . ') values (';
  42. reset($data);
  43. while (list(, $value) = each($data)) {
  44. switch ((string)$value) {
  45. case 'now()':
  46. $query .= 'now(), ';
  47. break;
  48. case 'null':
  49. $query .= 'null, ';
  50. break;
  51. default:
  52. $query .= ''' . tep_db_input($value) . '', ';
  53. break;
  54. }
  55. }
  56. $query = substr($query, 0, -2) . ')';
  57. } elseif ($action == 'update') {
  58. $query = 'update ' . $table . ' set ';
  59. while (list($columns, $value) = each($data)) {
  60. switch ((string)$value) {
  61. case 'now()':
  62. $query .= $columns . ' = now(), ';
  63. break;
  64. case 'null':
  65. $query .= $columns .= ' = null, ';
  66. break;
  67. default:
  68. $query .= $columns . ' = '' . tep_db_input($value) . '', ';
  69. break;
  70. }
  71. }
  72. $query = substr($query, 0, -2) . ' where ' . $parameters;
  73. }
  74. return tep_db_query($query, $link);
  75. }
  76.  
  77. // Funções chamadas
  78. function tep_db_query($query, $link = 'db_link') {
  79. global $$link;
  80. $result = mysqli_query($$link, $query) or tep_db_error($query, mysqli_errno($$link), mysqli_error($$link));
  81. return $result;
  82. }
  83.  
  84. function tep_db_input($string, $link = 'db_link') {
  85. global $$link;
  86. return mysqli_real_escape_string($$link, $string);
  87. }
  88.  
  89. function tep_db_error($query, $errno, $error) {
  90. die('<font color="#000000"><strong>' . $errno . ' - ' . $error . '<br /><br />' . $query . '<br /><br /><small><font color="#ff0000">[TEP STOP]</font></small><br /><br /></strong></font>');
  91. }
  92.  
  93. $data_array = array(
  94. 'nome' => 'Nome',
  95. 'sobrenome' => 'Sobrenome',
  96. 'genero' => 1,
  97. 'email' => 'email@mail.com',
  98. 'fone' => 'null',
  99. 'data' => 'now()');
  100.  
  101. // insert
  102. tep_db_perform('clientes', $data_array);
  103.  
  104. // update
  105. tep_db_perform('clientes', $data_array, 'update', "cliente_id = '1'");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement