Need help for migration of php code from 7.4 to 8.2
Expecting new code for php 8.2
Hi friends,
I have a simple feedback form.
When the Send button is pressed, it will post the form data and update the feedback table.
Its working in PHP 7.4
When i have uploaded the code to cpanel, Its not updating the table.
Cpanel is having version PHP 8.1, 8.2 and 8.3
Can some body help me with the new coding for 8.2
<script>
function feedback()
{
alert("Thank you for your feedback");
}
</script>
<?php
$booknoworsave =0;
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$mysql_server = 'localhost';
$mysql_database = 'db1';
$mysql_table = 'feedback';
$mysql_username = 'admin';
$mysql_password = 'password';
$eol = "n";
if(isset($_POST['Send']))
{
$booknoworsave = $_POST['Send'];
}
global $booknoworsave;
if($booknoworsave == "Send")
{
$search = array("ä", "Ä", "ö", "Ö", "ü", "Ü", "ß", "!", "§", "$", "%", "&", "/", "x00", "^", "°", "x1a", "-", """, " ", "\", "", "x0B", "t", "n", "r", "(", ")", "=", "?", "`", "*", "'", ":", ";", ">", "<", "{", "}", "[", "]", "~", "²", "³", "~", "µ", "@", "|", "<", "+", "#", ".", "´", "+", ",");
$replace = array("ae", "Ae", "oe", "Oe", "ue", "Ue", "ss");
foreach($_POST as $name=>$value)
{
$name = str_replace($search, $replace, $name);
$name = strtoupper($name);
$form_data[$name] = $value;
}
$conforbooknow = mysqli_connect($mysql_server, $mysql_username, $mysql_password) or die('Failed to connect to database server!<br>'.mysqli_error($conforbooknow));
mysqli_query($conforbooknow, "CREATE DATABASE IF NOT EXISTS $mysql_database");
$conforbooknow =mysqli_connect($mysql_server, $mysql_username, $mysql_password, $mysql_database);
mysqli_query($conforbooknow, "CREATE TABLE IF NOT EXISTS $mysql_table (ID int(9) NOT NULL auto_increment, `DATESTAMP` DATE, `TIME` VARCHAR(8) NOT NULL DEFAULT '00', `IP` VARCHAR(30) NOT NULL DEFAULT '00', `BROWSER` TINYTEXT, PRIMARY KEY (id))");
foreach($form_data as $name=>$value)
{
mysqli_query($conforbooknow, "ALTER TABLE $mysql_table ADD $name VARCHAR(50) NOT NULL DEFAULT '00'");
}
mysqli_query($conforbooknow, "INSERT INTO $mysql_table (`DATESTAMP`, `TIME`, `IP`, `BROWSER`)
VALUES ('".date("Y-m-d")."',
'".date("G:i:s")."',
'".$_SERVER['REMOTE_ADDR']."',
'".$_SERVER['HTTP_USER_AGENT']."')")or die('Failed to insert data into table!<br>'.mysqli_error($conforbooknow));
$id = mysqli_insert_id($conforbooknow);
foreach($form_data as $name=>$value)
{
mysqli_query($conforbooknow,"UPDATE $mysql_table SET $name = '$value' WHERE id = '$id'");
}
mysqli_close($conforbooknow);
}//Add new item
}
?>
New contributor
Murugan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1