I've got a WordPress theme, and I am attempting to save data from an HTML form right into a database.
saveData() that can take the information in the form and transmits it to
addrow.php, that ought to save the information right into a database table named
I believe the issue is in
addrow.php because in WordPress, one should make use of the global
$wpdb as well as other factor.
What will be a simple example be based on how in order to save data from an HTML form right into a database table inside a WordPress-powered application?
<?php require("phpsqlinfo_dbinfo.php") // Will get data from URL parameters $nombre = $_GET['nombre'] $direccion = $_GET['direccion'] $lat = $_GET['lat'] $lng = $_GET['lng'] $tipo = $_GET['tipo'] // Opens an association to some MySQL server $connection = mysql_connect ("localhost", $username, $password) if (!$connection) // Set the active MySQL database $db_selected = mysql_choose_db($database, $connection) if (!$db_selected) // Place new row with user data $query = sprintf("Place INTO vel " . " (id, nombre, direccion, lat, lng, tipo ) " . " VALUES (NULL, '%s', '%s', '%s', '%s', '%s')", mysql_real_escape_string($nombre), mysql_real_escape_string($direccion), mysql_real_escape_string($lat), mysql_real_escape_string($lng), mysql_real_escape_string($tipo)) $result = mysql_query($query) if (!$result) ?>
You're correct to be able to place data right into a database table, it's a best practice to make use of
$wpdb. The WordPress Codex can present you with good examples and much more information that will help you proceed.
For instance, to place a brand new record right into a database table, this can be done (in the above linked page):
$wpdb->insert( 'table', array( 'column1' => 'value1', 'column2' => 123 ), array( '%s', '%d' ) )
Should you publish additional code (e.g., so how exactly does
addrow.php presently attempt to save the information?), we may have the ability to provide more specific information.