Databases
StackOverflow2013
Postsdbo
POget PHP POST from dynamically loaded page
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POget PHP POST from dynamically loaded page
    primarykey
    data
    text
    <p>I have a page that gets updated dynamically using ajax, I have a form loaded dynamically and when the submit button is clicked it dynamically loads another page. How would I access my POST variables when doing this? I've tried the <code>$_POST['variable']</code> with no luck.</p> <p><a href="http://www.tri-peoria.org/js/ajaxloader.js" rel="nofollow">ajaxloader.js</a></p> <p>register-form.php</p> <pre><code>&lt;?php session_start(); if( isset($_SESSION['ERRMSG_ARR']) &amp;&amp; is_array($_SESSION['ERRMSG_ARR']) &amp;&amp; count($_SESSION['ERRMSG_ARR']) &gt;0 ) { echo '&lt;ul class="err"&gt;'; foreach($_SESSION['ERRMSG_ARR'] as $msg) { echo '&lt;li&gt;',$msg,'&lt;/li&gt;'; } echo '&lt;/ul&gt;'; unset($_SESSION['ERRMSG_ARR']); } ?&gt; &lt;form id="loginForm" name="loginForm" method="post" action="javascript:ajaxpage('account/register-exec.php', 'content');"&gt; &lt;table width="300" border="0" align="center" cellpadding="2" cellspacing="0"&gt; &lt;tr&gt; &lt;th&gt;First Name &lt;/th&gt; &lt;td&gt;&lt;input name="firstName" type="text" class="textfield" id="firstName" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th&gt;Last Name &lt;/th&gt; &lt;td&gt;&lt;input name="lastName" type="text" class="textfield" id="lastName" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th&gt;Username&lt;/th&gt; &lt;td&gt;&lt;input name="username" type="text" class="textfield" id="username" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th&gt;Password&lt;/th&gt; &lt;td&gt;&lt;input name="password" type="password" class="textfield" id="password" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;th&gt;Confirm Password &lt;/th&gt; &lt;td&gt;&lt;input name="cpassword" type="password" class="textfield" id="cpassword" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt;&lt;input type="submit" name="Submit" value="Register" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; </code></pre> <p>register-exec.php</p> <pre><code>&lt;?php //Start session session_start(); //Include database connection details require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $firstName = clean($_POST['firstName']); $lastName = clean($_POST['lastName']); $username = clean($_POST['username']); $password = clean($_POST['password']); $cpassword = clean($_POST['cpassword']); //Input Validations if($firstName == '') { $errmsg_arr[] = 'First name missing'; $errflag = true; } if($lastName == '') { $errmsg_arr[] = 'Last name missing'; $errflag = true; } if($username == '') { $errmsg_arr[] = 'Username missing'; $errflag = true; } if($password == '') { $errmsg_arr[] = 'Password missing'; $errflag = true; } if($cpassword == '') { $errmsg_arr[] = 'Confirm password missing'; $errflag = true; } if( strcmp($password, $cpassword) != 0 ) { $errmsg_arr[] = 'Passwords do not match'; $errflag = true; } //Check for duplicate username if($username != '') { $qry = "SELECT * FROM member WHERE username='$username'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) &gt; 0) { $errmsg_arr[] = 'Username already in use'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } //If there are input validations, redirect back to the registration form if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: register-form.php"); exit(); } //Create INSERT query $qry = "INSERT INTO member(firstName, lastName, username, password) VALUES('$firstName','$lastName','$username','".md5($_POST['password'])."')"; $result = @mysql_query($qry); //Check whether the query was successful or not if($result) { header("location: register-success.php"); exit(); }else { die("Query failed"); } ?&gt; </code></pre> <p>You can see my full form by clicking the "Join" button at tri-peoria.org and clicking on the 2nd link.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTyler Siegrist
    1. USTyler Siegrist
    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. This table or related slice is empty.
    1. COFirst fix the Parse error: syntax error on your code
      singulars
      1. POget PHP POST from dynamically loaded page
      1. USHanky Panky
    2. COYour request to register-exec.php is not POSTing any data.
      singulars
      1. POget PHP POST from dynamically loaded page
      1. USPassKit
 

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