I figured out my error in the query, Thank you all guys for responding, I just gave the piece of code
<?php
global $wpdb;
$contactus_table = $wpdb->prefix."contactus";
//error with the query
$sql = "INSERT INTO $contactus_table (firstname, lastname, email, query, reg_date) VALUES ('$firstName', '$lastName', '$email', '$query', CURRENT_TIMESTAMP)";
if($wpdb->query($sql))
{
$BlogName = get_bloginfo();
echo $BlogName;
}
?>
Related Posts:
- Getting value from database table depending on field value
- Help posting values to DB on submit using $wpdb->query
- $wpdb not working
- What is “Advanced” SQL?
- Oracle SQL query for Date format
- WPDB Insert or if exists Update
- Custom form that store input in database
- Insert data in database using form
- Where are image paths to product category images stored in WordPress database
- Sharing database for collaborative development
- Connect forms in WP to external database
- Inserting data into custom tables
- Organizing WP Pages based on old website database
- Inserting Post Meta From SQL
- Moving an entire wordpress site from one domain to a new domain and database
- Change SQL get_results to search for posts with custom term in custom taxonomy
- Storing textbox values in Database
- wpdb query on custom table not working [closed]
- How to execute mulitple statement SQL queries using $wpdb->query?
- Store and Encrypt Contact Form 7 Submissions in Database? [closed]
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Query WordPress database by registered date and role
- Using table lock with wp_insert_post?
- Scheduling posts in database
- Size article thumbnails and retrieve them directly from database
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Uppercase to sentence case for post titles
- SQL Error wp_commentmeta – incorrect table definition
- Retrieving a Value from a wp-database
- Form Data not getting stored in WordPress database
- How do I get the posts within a certain year/date(with sql query)?
- Export / import WordPress database
- WordPress is not creating table in database after activating plugin,
- Bulk-create posts from SQL database
- Difficulty importing my live site to local
- Sending data with multi step form to wp database
- WordPress Database Huge wp_usermeta Table
- Retrieve data from the database to table such as comments in the admin control panel
- Setup private content for specific users with daily updates [closed]
- WordPress running SQL query to update database from form
- Databases – Submitting data from inputs to database [closed]
- Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
- WPDB SQL query with prepare() returning variable, not db value
- Problems with moving my WordPress site to another domain/server
- Why this query is not showing any result on wordpresss home page?
- Is it possible to have more than 1 MySQL database in my WordPress blog?
- pull data from a remote wordpress database
- How to migrate a database from a server to another
- Clear Terms from Taxonomy for Specific Post IDs?
- Is my way to change WordPress server is correct?
- Why does changing Database Table Prefixes result in loss of content?
- Options on how to Display member specific data from a MS SQL database
- Using $wpdb | checking entered email against existing emails in db
- Delete/Replace words from X to Y in post content
- SQL query to set posts in bulk based on the post content
- Delete all posts that do NOT have a specific tag
- Location of WP default mySQL tables creation file?
- $wpdb->get_var – What value is returned when zero records are found?
- How to display data from db in select list [closed]
- WordPress SQL – How to Check for Category?
- DB prefix not updating
- Deleting empty meta key values
- Whats the best practise on how to store json data from a custom settings page?
- Sql query to get all metadata for a post
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- How to edit custom table data in frontend
- Job and Employee Performance Tracking with Product Safety
- User input to database
- SQL database import #1046 error
- Creating a custom form with ability to query and submit to SQL
- Change user_nickname for author page link
- Insert variables into wpdb in custom post template
- How do I loop/iterate through posts to edit all img tags?
- What’s the easiest way to connect external database and display data on wordpress?
- Is there a way for two deferent themes to consume two different DB on a same WP instance?
- How to create index (sql) to a meta_key?
- Delete all users meta that named: user_avatar
- Select data from foreach loop and send it to wordpress database
- insert data from a form:: Warning Empty query mysqli::query()
- Correct and secure way to access a custom SQL database in a custom PHP template file
- How to get specific table by current user login
- Form display in new page
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- How to retrieve user data based on role using SQL?
- Auto populate form fields based on serial input or pull listings from other websites?
- Simple email input store in database
- How to add data from wordpress tables to new database tables you have created
- Getting deleted users in database
- User accounts for saving form data?
- Install WordPress with SQL database
- Insert Extra fields added in the front end registration form to DB
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- Creating Job Tickets
- Saving data to database and exporting to excel
- SQL query : Select a thumbnail for a media
- why you don’t Implement PDO for access every thing to database
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- SQL query to rewrite all media URLs to end with .webp
- wp_usermeta key problem
- Weird WP -Cli Error Connection Refused