Databases
StackOverflow2013
Postsdbo
POForm and PHP function to save form data to mysql in same file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POForm and PHP function to save form data to mysql in same file
    primarykey
    data
    text
    <p>I have been trying to sort this out but so far I haven't been able to get it to work. No errors are thrown, the page refreshes on submit. I am at a loss, but I am not exactly an expert, fairly new to this. </p> <p>Here is the code (simplified for posting):</p> <pre><code>&lt;?php if (!isset($_POST['submit'])) { echo "&lt;!-- Form starts here --&gt; &lt;form id=\"billing\" action=\"\" method=\"post\"&gt; &lt;!-- Name --&gt; &lt;div class=\"control-group\"&gt; &lt;label class=\"control-label\"&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/label&gt; &lt;div class=\"controls\"&gt; &lt;input type=\"text\" id=\"name\" name=\"name\" placeholder=\"your name\" class=\"input-large\"&gt; &lt;/div&gt; &lt;/div&gt; &lt;!-- Zip --&gt; &lt;div class=\"control-group\"&gt; &lt;label class=\"control-label\"&gt;&lt;b&gt;Zip Code&lt;/b&gt;&lt;/label&gt; &lt;div class=\"controls\"&gt; &lt;input type=\"text\" id=\"billingzip\" name=\"billingzip\" placeholder=\"5 digit zip\" class=\"input-large\"&gt; &lt;/div&gt; &lt;/div&gt; &lt;!-- Submit --&gt; &lt;div class=\"control-group\"&gt; &lt;div class=\"controls\"&gt; &lt;button class=\"button save small_green_button\" type=\"submit\"&gt; &amp;nbsp;Save&amp;nbsp; &lt;/button&gt; &lt;/div&gt; &lt;/div&gt; &lt;/form&gt;"; } else { $host="localhost"; $user_name="user"; $pwd="password"; $database_name="database"; $db=mysql_connect($host, $user_name, $pwd) or die(mysql_error()); $dbsel=mysql_select_db($database_name, $db); if (mysql_error() &gt; "") print mysql_error() . "&lt;br&gt;"; if (mysql_error() &gt; "") print mysql_error() . "&lt;br&gt;"; $account_id = users::getAttr('Account', 'account_id'); $zip = mysql_real_escape_string($_POST['billingzip']); $name = mysql_real_escape_string($_POST['name']); $sql = "INSERT INTO `billing` SET `account_id` = '{$account_id}', `zip` = '{$billingzip}', `name` = '{$name}', `updated_at` = NOW()"; $result = mysql_query($sql, $dbsel) or die(mysql_error().$sql); mysql_close($db); } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USArringar1
    1. USArringar1
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POForm and PHP function to save form data to mysql in same file
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CODon't write new code with the `mysql_*` functions, especially when you are learning it. They are in the process of becoming deprecated and will be removed in future versions of PHP. Learn with `mysqli_*` or PDO right away.
      singulars
      1. POForm and PHP function to save form data to mysql in same file
      1. USGerald Schneider
    2. CO`{$billingzip}` should be `{$zip}`, and if `$account_id` is a numerical value you don't need the quotes in the query around it. Not sure though if that would result in an invalid query.
      singulars
      1. POForm and PHP function to save form data to mysql in same file
      1. USGerald Schneider
    3. COI don't see any input named `submit` in your form.
      singulars
      1. POForm and PHP function to save form data to mysql in same file
      1. USGerald Schneider
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload