StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow do I get the ID value from the url?
text
Body
copied!<p>I am trying to make my own forums using a tutorial. I have already fixed quite a lot of errors and I have 1 left to do.</p> <p>When you post a reply on a thread it will save your reply in a MySQL database. You reply will have an int that matches with the thread id you replied on, called question_id. </p> <p>I cant get my code to get the thread id from the URL bar.</p> <p>These are the 2 lines of code that should do the work:</p> <pre><code>$id = $_GET['id']; $sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')"; </code></pre> <p>And this is the entire file add_answer.php</p> <pre><code><?php $host="XXXXXX"; // Host name $username="XXXXXX"; // Mysql username $password="XXXXXX"; // Mysql password $db_name="XXXXXX"; // Database name $tbl_name="XXXXXX"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Get value of id that sent from hidden field $id = $_GET['id']; var_dump($id); // Find highest answer number. $sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); // $result=mysql_query($sql) or die(mysql_error()); // add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1 if ($rows) { $Max_id = $rows['Maxa_id']+1; } else { $Max_id = 1; } // get values that sent from form $a_name=$_POST['a_name']; $a_email=$_POST['a_email']; $a_answer=$_POST['a_answer']; $datetime=date("d/m/y H:i:s"); // create date and time // Insert answer $sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')"; $result2=mysql_query($sql2) or die(mysql_error()); if($result2) { echo "Successful<BR>"; echo "<meta http-equiv='refresh' content='4;url=index.php?content=main_forum' />"; // If added new answer, add value +1 in reply column $tbl_name2="forum_question"; $sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'"; $result3=mysql_query($sql3); } else { echo "An error as occured. Please report this to administrator. ID: FAA01."; } mysql_close(); ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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