11 if(!$_SESSION[
'loggedin']) {
12 header(
"location: index.php");
14 $a = $_GET[
'posts_id'];
16 if(isset($_POST[
'update'])) {
17 $name = mysqli_real_escape_string($db, $_POST[
'name']);
18 $roll = mysqli_real_escape_string($db, $_POST[
'roll']);
19 $email = mysqli_real_escape_string($db, $_POST[
'email']);
20 $coursetaken = mysqli_real_escape_string($db, $_POST[
'coursetaken']);
21 $company = mysqli_real_escape_string($db, $_POST[
'companyname']);
22 $story = mysqli_real_escape_string($db, $_POST[
'story']);
23 $student_id = mysqli_real_escape_string($db, $_POST[
'student_id']);
24 $roundprovided = implode(
",", $_POST[
'roundprovided']);
25 $roundcleared = implode(
",", $_POST[
'roundcleared']);
26 $story = str_replace(array(
"\n",
"\n",
"\\n",
"\\n"),
"<br/>",$story);
28 $created = date(
'Y-m-d H:i:s');
32 $sql =
"UPDATE posts SET name = '$name',roll = '$roll' , email = '$email', coursetaken = '$coursetaken',companyname='$company',story='$story',roundprovided='$roundprovided',roundcleared='$roundcleared',created_at='$created' WHERE id=$a";
33 $result = mysqli_query($db, $sql);
34 header(
"location: profile.php");