-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathModifySoln1.php
34 lines (29 loc) · 1.03 KB
/
ModifySoln1.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?php
header('Content-Type: text/plain; charset=UTF-8');
$err = $_POST['SelError'];
echo $err;
$soln=filter_input(INPUT_POST, 'addsolnhere');
echo $soln;
$ges=filter_input(INPUT_POST, 'gestatement');
echo $ges;
$username = "root";
$password = "";
$hostname = "localhost";
$db="proj";
$dbhandle = mysqli_connect($hostname, $username, $password,$db)
or die("Unable to connect to MySQL");
mysqli_query($dbhandle,"SET NAMES 'utf8'");
mysqli_query($dbhandle, "UPDATE err SET errorname = '$ges' WHERE error = '$err';");
$result1 = mysqli_query($dbhandle,"SELECT ges FROM sol where error='$err'");
while($row1 = mysqli_fetch_array($result1))
{
$ges1=$row1['ges'];
}
mysqli_query($dbhandle, "delete from sol where error='$err'");
//echo $ges;
mysqli_query($dbhandle, "delete from errdb where errname='$ges1'");
mysqli_query($dbhandle, "insert into sol (soln,error,ges) values ('$soln','$err','$ges')");
mysqli_query($dbhandle, "insert into errdb values('$ges')");
mysqli_close($dbhandle);
header('Location: ModifySoln.php');
?>