Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #(add_answer.php)
- <?php
- $host="mysql.webcindario.com"; // Host name
- $username="myforum"; // Mysql username
- $password="ebsaraiva"; // Mysql password
- $db_name="myforum"; // Database name
- $tbl_name="forum_answer"; // Table name
- // Connect to server and select databse.
- 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=$_POST['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);
- // 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);
- if($result2){
- echo "Resposta efectuada com sucesso<BR>";
- echo "<a href='view_topic.php?id=".$id."'>Ver a resposta</a>";
- // 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 "ERROR";
- }
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement