<?php
if (isset($_POST['submit'])) {
global $wpdb;
$table_name = $wpdb->prefix . "table_booky";
$wpdb->insert($table_name, array(
"Name" => $_POST['name'],
"dep" => $_POST['age'];
"age" => $_POST['dep'];
));
}
?>
<form class="" action="<?php home_url(); ?>" method="POST">
<input type="text" name="name" value="">
<input type="text" name="age" value="">
<input type="text" name="dep" value="">
<input type="submit" name="submit" value="submit">
</form>
<?php
if (isset($_POST['submit'])) {
global $wpdb;
$table_name = $wpdb->prefix . "table_booky";
$wpdb->insert($table_name, array(
"Name" => $_POST['name'],
"dep" => $_POST['age'];
"age" => $_POST['dep'];
));
}
?>
<form class="" action="<?php home_url(); ?>" method="POST">
<input type="text" name="name" value="">
<input type="text" name="age" value="">
<input type="text" name="dep" value="">
<input type="submit" name="submit" value="submit">
</form>
- It's hard to tell from your post - if you could go back please and wrap everything in code, which looks like a curly braces symbol, that should help - but it looks like in your array you have semicolons where you need to use commas instead. – WebElaine Commented Nov 28, 2018 at 20:15
- Welcome to WPSE, Reaz. You may want to consider revising your question for clarity. Make your title a little more concise and be descriptive in the content area. Right now all you really have is a code snippet without a description of what is not working for you. – butlerblog Commented Nov 28, 2018 at 21:53
1 Answer
Reset to default 0While your question isn't entirely clear on the issue you're having, I'm guessing that it's the way that you defined the elements of the array you were trying to insert.
You had a mix of commas and semicolons separating the elements.
I revised your code to correct that - and to aid readability of your code so you can see it, I pulled this out into a variable - $data_array.
<?php
if ( isset( $_POST['submit'] ) ) {
global $wpdb;
$table_name = $wpdb->prefix . "table_booky";
$data_array = array(
"Name" => $_POST['name'],
"dep" => $_POST['age'], // Note the comma, and not semicolon
"age" => $_POST['dep'], // Same here...
);
$wpdb->insert( $table_name, $data_array );
}
?>
<form class="" action="<?php home_url(); ?>" method="POST">
<input type="text" name="name" value="">
<input type="text" name="age" value="">
<input type="text" name="dep" value="">
<input type="submit" name="submit" value="submit">
</form>
Now, this doesn't address other issues such as the fact that you are not sanitizing your input data. So you should look into that after you get your code working.