Support » Fixing WordPress » Insert Query not working

  • mufaddal

    (@mufaddal)


    I am using Jquery Ajax Submit i have a action.php where all my code resides now the Jquery Posts the data but its not inserting it and either its giving an error, this is how the page looks..

    require_once(‘/wp-load.php’);
    require_once(‘/wp-config.php’);

    global $wpdb;
    $wpdb->query(“INSERT INTO $wpdb->ticket (CompanyName, CustomerName) VALUES(‘test1′,’test 2’)”);

    I am new to wordpress, please can anyone help!

Viewing 5 replies - 1 through 5 (of 5 total)
  • MichaelH

    (@michaelh)

    If you are getting an error, you might list that error so someone might be able to help you.

    Also assuming that you have the ‘xxx_ticket’ table in your WordPress database. The ‘xxx_’ would be the $table_prefix in your wp-config.php file.

    If you are using a plugin, please report a link to that plugin as well.

    Thread Starter mufaddal

    (@mufaddal)

    No there is no error displayed, on Database table name is wp_table and prefix on wp-config.php is “wp_”
    I am creating a new plugin so stuk on inserting records can you please tell me what all is needed for simple insert.

    yakuphan

    (@yakuphan)

    Use the following codes
    $table_name = $wpdb->prefix . “ticket”;
    $wpdb->query(“INSERT INTO $table_name (CompanyName, CustomerName) VALUES(‘test1′,’test 2’)”);

    Thread Starter mufaddal

    (@mufaddal)

    still facing the same problem.

    MichaelH

    (@michaelh)

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Insert Query not working’ is closed to new replies.