<?php
// here somehow connect to sql
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
if(isset($_POST['submit']))
{
$query2 = "UPDATE site_home SET home_header = $_POST['header']";
$result2 = mysql_query($query);
}
?>
<form action="" method="POST">
<textarea name="header"><?php $array['home_header']; ?></textarea><?php if($result){ echo "updated"; } ?>
<input type="submit" name="submit">
</form>
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\football\housekeeping\home.php on line 10
<?php
include('../config.php');
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
if(isset($_POST['header']))
{
$query2 = "UPDATE site_home SET home_header = $_POST['header']";
$result2 = mysql_query($query);
}
?>
<form arction="" method="POST">
<textarea name="header"><?php $array['home_header']; ?></textarea><?php if($result){ echo "updated"; } ?>
<input type="submit">
</form>
<?php
include('../config.php');
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
$homeheader = $_POST['header'];
if(isset($_POST['submit']))
{
$query2 = "UPDATE `site_home` SET `home_header` = '$homeheader'";
$result2 = mysql_query($query2);
}
?>
<form action="" method="POST">
<textarea name="header"><?php $array['home_header']; ?></textarea><?php if($result2){ echo "updated"; } ?>
<input type="submit">
</form>
<?php
include('../config.php');
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result);
$homeheader = $_POST['home_header'];
if(isset($_POST['header']))
{
$query2 = "UPDATE site_home SET home_header = $homeheader";
$result2 = mysql_query($query);
}
?>
<form arction="" method="POST">
<textarea name="header"><?php $array['home_header']; ?></textarea><?php if($result){ echo "updated"; } ?>
<input type="submit">
</form>
$homeheader = $_POST['home_header']
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
<?php
include('../config.php');
$query = "SELECT * FROM site_home";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_array($result);
$homeheader = $_POST['header'];
if(isset($_POST['submit']))
{
$query2 = "UPDATE `site_home` SET `home_header` = '$homeheader'";
$result2 = mysql_query($query2) or die(mysql_error());
}
?>
<form action="" method="POST">
<textarea name="header"><?php $array['home_header']; ?></textarea><?php if($result){ echo "updated"; } ?>
<input type="submit">
</form>
<?php
mysql_connect(localhost, ales, ******);
mysql_select_db(homopelo);
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result) or die(mysql_error());
$homeheader = $_POST['header'];
if(isset($_POST['header']))
{
$query2 = "UPDATE `site_home` SET `home_header` = '$homeheader'";
$result2 = mysql_query($query2) or die(mysql_error());
//to refresh
header('refresh: 2, testik.php');
}
?>
<form action="" method="POST">
<textarea name="header">
<?php
echo $array['home_header'];
?>
</textarea>
<?php if($result2){ echo "updated"; } ?>
<br />
<input type="submit">
</form>
<?php
mysql_connect(localhost, root, *******);
mysql_select_db(site_home);
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result) or die(mysql_error());
$homeheader = $_POST['header'];
if(isset($_POST['header']))
{
$query2 = "UPDATE `site_home` SET `home_header` = '$homeheader'";
$result2 = mysql_query($query2) or die(mysql_error());
//to refresh
header('location: testik.php');
}
?>
<form action="" method="POST">
<textarea name="header">
<?php
echo $array['home_header'];
?>
</textarea>
<?php if($result2){ echo "updated"; } ?>
<br />
<input type="submit">
</form>
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\football\housekeeping\home.php on line 6
No database selected
<?php
include('../config.php');
$query = "SELECT * FROM site_home";
$result = mysql_query($query);
$array = mysql_fetch_array($result) or die(mysql_error());
$homecontent = $_POST['content'];
$homeheader = $_POST['header'];
if(isset($_POST['content']))
{
$query2 = "UPDATE `site_home` SET `home_content` = '$homecontent ', `home_header` = '$homeheader'";
$result2 = mysql_query($query2) or die(mysql_error());
//to refresh
header('refresh: 2, home.php');
}
?>
<form action="" method="POST">
<p>header</p>
<input type="text" name ="header" value="<?php echo $array['home_header']; ?>" />
<br />
<p>content</p>
<textarea name="content">
<?php
echo $array['home_content'];
?>
</textarea>
<?php if($result2){ echo "updated"; } ?>
<br />
<input type="submit">
</form>