-
Notifications
You must be signed in to change notification settings - Fork 13
/
saveInfo.php
38 lines (38 loc) · 1.13 KB
/
saveInfo.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
//Credenciales de la base de datos
$db_host = "localhost";
$db_user = "root";
$db_password = "";
$db_name = "example_database";
//Se crea la conexión con la base d datos
$db_connection = mysql_connect($db_host, $db_user, $db_password);
if (!$db_connection) {
die('No se ha podido conectar a la base de datos');
}
//Se empieza a construir el query para insertar los datos
$query = "INSERT INTO " . $db_name . ".";
foreach ($_POST as $key => $value) {
if (($key) == "table_name") {
$query = $query . $value . " (";
} else {
$query = $query . $key . ", ";
}
}
$query = $query . "_";
$query = str_replace(", _", ") VALUES (", $query);
foreach ($_POST as $key => $value) {
if ($key != "table_name") {
$query = $query . "\"" . $value . "\", ";
}
}
//Se corrige el query
$query = $query . "_";
$query = str_replace(", _", ")", $query);
//Se insertan los datos en la base de datos
mysql_select_db($db_name, $db_connection);
$retry_value = mysql_query($query, $db_connection);
if (!$retry_value) {
die('Error: ' . mysql_error());
}
mysql_close($db_connection);
?>