Databases
StackOverflow2013
Postsdbo
POWarning: missing argument error on putting stores in database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWarning: missing argument error on putting stores in database
    primarykey
    data
    text
    <p>On my website , i want to register a user.</p> <p>My HTML is:</p> <pre><code>&lt;form method="post" action="register.php"&gt; &lt;h1&gt;Register&lt;/h1&gt; &lt;p&gt;If you already have an account, please login&lt;/p&gt; &lt;div class="styled_select"&gt; &lt;select name="title"&gt; &lt;option value="mr"&gt;Mr&lt;/option&gt; &lt;option value="mrs"&gt;Mrs&lt;/option&gt; &lt;option value="miss"&gt;Miss&lt;/option&gt; &lt;/select&gt; &lt;/div&gt; &lt;input type="text" name="first_name" placeholder="First Name" required&gt;&lt;br&gt; &lt;input type="text" name="last_name" placeholder="Last Name" required&gt;&lt;br&gt; &lt;div class="styled_select"&gt; &lt;select name="sex" required&gt; &lt;option value="male"&gt;Male&lt;/option&gt; &lt;option value="female"&gt;Female&lt;/option&gt; &lt;/select&gt; &lt;/div&gt; &lt;input type="text" name="age" placeholder="Age" required&gt;&lt;br&gt; &lt;input type="text" name="email" placeholder="Email" required&gt;&lt;br&gt; &lt;input type="text" name="zipcode" placeholder="Zipcode" required&gt;&lt;br&gt; &lt;input type="text" name="telephone" placeholder="Telephone" required&gt;&lt;br&gt; &lt;input type="checkbox" class="checkbox" required&gt; Agree to terms and conditions. &lt;br&gt; &lt;input type="checkbox" class="checkbox" name="keep_informed"&gt; Keep me informed on future promotions. &lt;br&gt; &lt;input type="submit" name="" value="Register" class="submit_button"&gt;&lt;br&gt; &lt;/form&gt; </code></pre> <p>My php function is:</p> <pre><code>class Register { public function register($title, $first_name, $last_name, $sex, $age, $email, $zipcode, $telephone, $keep_informed) { $title = mysql_real_escape_string($title); $first_name = mysql_real_escape_string($first_name); $last_name = mysql_real_escape_string($sex); $sex = mysql_real_escape_string($age); $email = mysql_real_escape_string($email); $zipcode = mysql_real_escape_string($zipcode); $telephone = mysql_real_escape_string($telephone); $keep_informed = mysql_real_escape_string($keep_informed); $dbh = new PDO('mysql:host=localhost;dbname=testbox_new', 'root', ''); $sql = 'insert into users (title, first_name, last_name, sex, age, email, zipcode, telephone, keep_informed) values ("'.$title.'", "'.$first_name.'", "'.$last_name.'", "'.$sex.'", "'.$age.'", "'.$email.'", "'.$zipcode.'", "'.$telephone.'", "'.$keep_informed.'")'; if ($dbh-&gt;exec($sql)) { return true; } else { return false; } } } </code></pre> <p>and i call the function with:</p> <pre><code>if (isset($_POST['title']) &amp;&amp; isset($_POST['first_name']) &amp;&amp; isset($_POST['last_name']) &amp;&amp; isset($_POST['sex']) &amp;&amp; isset($_POST['age']) &amp;&amp; isset($_POST['email']) &amp;&amp; isset($_POST['zipcode']) &amp;&amp; isset($_POST['telephone'])) { if (isset($_POST['keep_informed'])) { $keep_informed = $_POST['keep_informed']; } else { $keep_informed = 0; } $register = new Register; $insert = $register-&gt;register($_POST['title'], $_POST['first_name'], $_POST['last_name'], $_POST['sex'], $_POST['age'], $_POST['email'], $_POST['zipcode'], $_POST['telephone'], $keep_informed); if ($insert == true) { header ('location: index1.php'); } else { echo 'somethings gone wrong'; } } </code></pre> <p>The errors i get are the following:</p> <pre><code>Warning: Missing argument 1 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 2 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 3 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 4 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 5 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 6 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 7 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 8 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Warning: Missing argument 9 for Register::register(), called in C:\xampp\htdocs\testbox\register.php on line 53 and defined in C:\xampp\htdocs\testbox\register.php on line 14 Notice: Undefined variable: title in C:\xampp\htdocs\testbox\register.php on line 16 Notice: Undefined variable: first_name in C:\xampp\htdocs\testbox\register.php on line 17 Notice: Undefined variable: sex in C:\xampp\htdocs\testbox\register.php on line 18 Notice: Undefined variable: age in C:\xampp\htdocs\testbox\register.php on line 19 Notice: Undefined variable: email in C:\xampp\htdocs\testbox\register.php on line 20 Notice: Undefined variable: zipcode in C:\xampp\htdocs\testbox\register.php on line 21 Notice: Undefined variable: keep_informed in C:\xampp\htdocs\testbox\register.php on line 22 Notice: Undefined variable: age in C:\xampp\htdocs\testbox\register.php on line 29 Notice: Undefined variable: keep_informed in C:\xampp\htdocs\testbox\register.php on line 31 </code></pre> <p>Is there anyone who knows what the problem is ? I really can't figure it out!</p> <p>Any help would be appreciated ;)</p> <p>Thx!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrecht Schepens
    1. USBrecht Schepens
    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
    1. This table or related slice is empty.
    1. COSQL injection warning.
      singulars
      1. POWarning: missing argument error on putting stores in database
      1. UScwallenpoole
    2. COprint out your variables, check if they are correctly set. Something has went wrong before posting your data to your function
      singulars
      1. POWarning: missing argument error on putting stores in database
      1. USDaryl Gill
    3. COCan you post the whole contents of the file `C:\xampp\htdocs\testbox\register.php` or at least everything from the top to the end of the function register?
      singulars
      1. POWarning: missing argument error on putting stores in database
      1. USTechnoh
 

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