CREATE TABLE IF NOT EXISTS `settings` (
`inphpmyadmin` longtext NOT NULL,
`insite` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `settings` (`inphpmyadmin`, `insite`) VALUES
('title', 'Your title Is Here');
<?php
$dbhost = 'host';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'databasename';
function db_connect()
{
$result = new mysqli('host', 'user', 'pass','databasename');
if (!$result)
throw new Exception('Could not connect to database server');
else
return $result;
}
?>
<title>Edit title</title>
<?php
require_once('db.php');
@ $insite=$_POST['title'];
if($insite)
{
$conn = db_connect();
$reee=$conn->query( "update settings
set insite = '$insite'
where inphpmyadmin = 'title'");
}
?>
<form method='post'>
<input type='text' name='title'>
<input type='submit' value='edit'>
</form>
<?php
require_once('db.php');
$conn = db_connect();
$result = $conn->query("select * from settings where inphpmyadmin = 'title' ");
$num_results = $result->num_rows;
for ($i=0; $i <$num_results; $i++)
{
$row = $result->fetch_assoc();
$title=$row['insite'];
}
?>
<title><?php echo $title; ?></title>
باید اطلاعات دیتابیس خودتون رو توی db.php بذاریدفایل sql مشکل داره خطا می ده
CREATE TABLE IF NOT EXISTS `settings` (
`inphpmyadmin` longtext NOT NULL,
`insite` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `settings` (`inphpmyadmin`, `insite`) VALUES
('title', 'Your title Is Here');