Support » Fixing WordPress » Custom Form not inserting data to database

  • I have created two custom template pages(createhome.php & insert.php)

    My createhome.php has a form whose action connects to a file called insert.php

    The insert.php should then insert the input to the database using wpdb->insert()

    However, when I click submit, it takes me to a 404 page not found, and the url is:

    Nothing is inserted into the database. BUT, when I navigate to the insert page( it inserts blank data to the database!

    To see for yourself, submit the form here:(

    So, apparently my form is not connecting to my insert.php file on submission. Does this have something to do with my form’s action? Or is this something with the permalinks? I just want to be able to save my form’s input data into my newly created table in the wp database. If this was regular php/mysql, I wouldn’t have a problem in the world.

    Here is my form:
    <h2><center> Enter your home information: </center></h2>

    <form action="insert.php" method="post">
                            Name: <input type="text" name="owner_name"><br />
                            Address: <input type="text" name="address"><br />
                            City: <input type="text" name="city"><br />
                            State: <input type="text" name="state"><br />
                            Zip Code: <input type="text" name="zipcode"><br />
                            Number of Rooms: <input type="text" name="num_rooms"><br />
                            Number of Bedrooms: <input type="text" name="num_bedrooms"><br />
                            Number of Bathrooms: <input type="text" name="num_bathrooms"><br />
                            Square Feet: <input type="text" name="square_feet"><br />
                            Age of Home: <input type="text" name="home_age"><br />
                            			 <input type="hidden" name="id">
                            			 <input type="hidden" name="owner_id">
                            <input type="submit">

    Here is my insert.php code:

    global $wpdb;
    								'owner_name' => '$_POST[owner_name]',
    								'address' => '$_POST[address]',
    								 'city' => '$_POST[city]',
    								'state' => '$_POST[state]',
    								'zipcode' => '$_POST[zipcode]',
    								'num_rooms' => '$_POST[num_rooms]',
    								'num_bedrooms' => '$_POST[num_bedrooms]',
    								'num_bathrooms' => '$_POST[num_bathrooms]',
    								'square_feet' => '$_POST[square_feet]',
    								'home_age' => '$_POST[home_age]'
                            echo "1 record added";
  • The topic ‘Custom Form not inserting data to database’ is closed to new replies.