我有两个表:
如果名为TINA(id 3)的用户登录并发布问题,则应将其问题以其各自的ID即3保存在表QUESTIONS中。如何实现?
<div id="content">
</br>
<form action="" method="post">
<center> <h3> <font color="green"> Ask a new question:
<select name="type" required>
<option value="" disabled selected> Select the type of question </option>
<option value="technical"> Technical </option>
<option value="entertainment"> Entertainment </option>
<option value="fashion"> Fashion </option>
<option value="food"> Food </option>
<option value="education"> Education </option>
<option value="lifestyle"> Lifestyle </option>
<option value="relationships"> Relationships </option>
<option value="health"> Health </option>
<option value="random"> Random </option>
</select>
</font> </h3>
<textarea rows="3" cols="100" style="resize:none" placeholder="Please type your question here..." name="ques" required></textarea><br>
<input type="submit" value="POST" name="POST" align="middle">
</center>
</form>
<?php
if(isset($_POST['POST']))
{
$type=$_POST['type'];
$ques=$_POST['ques'];
$date = strftime("%B %d, %Y");
$time = strftime("%r");
$sql="INSERT INTO questions (type,question,date,time) VALUES ('$type', '$ques', '$date', '$time')";
$query = mysqli_query($conn, $sql);
if(isset($_SESSION['id']))
{
echo "<div class='boxtype'>";
echo strtoupper($type);
echo "</div>";
echo "<div class='boxtime'>";
echo '['.$date.']'.' '.'['.$time.']';
echo "</div>";
echo "<div class='box'>";
echo "<font color='red'>".'<b>'.'<i>'.'<u>';
echo strtoupper($_SESSION['user']);
echo '</u>'.'</i>'.'</b>'.'</font>';
echo ':'.' '.$ques;
echo "</div>";
}
}
首先修改您的table
QUESTIONS
。创建一个field
user_id
存储id
的user
谁后的问题。
当用户说Tina登录时,session
在登录期间创建一个,并将其存储id
在session
variable
like中SESSION['user_id'] = your_log_in_user_id
。现在,只需将其插入到QUESTION表中即可
$user_id = SESSION['user_id'];
$sql="INSERT INTO questions (type,question,date,time,user_id) VALUES ('$type', '$ques', '$date', '$time','$user_id')";
$query = mysqli_query($conn, $sql);
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句