Es esmu izveidojis shadu scriptu
<?php
//Pieslēgšanās datubāzei
$db_host = 'localhost';
$db_user = 'root';
$db_password = 'real112';
$db_name = 'sistema';
$connection = @mysql_connect($db_host, $db_user, $db_password) or die(mysql_error());
mysql_select_db($db_name, $connection);
mysql_query("SET NAMES utf8");
//Ievietošana datubazē
$sql="INSERT INTO viesene (vards, lapa, zinja)
VALUES
('$_POST[vards]','$_POST[lapa]','$_POST[zinja]')";
if (!mysql_query($sql,$connection))
echo "<span class='ok'>Pievienots</span><br />";
else
{
echo "<span class='error'>Kāds lauks palika tukšs!</span><br />";
}
//Izvilkšana
$result = mysql_query("SELECT * FROM viesene");
while($row = mysql_fetch_array($result))
{
echo "<br>";
echo "<br>" . $row['vards'] . "</td>";
echo "<br>" . $row['lapa'] . "</td>";
echo "<br>" . $row['zinja'] . "</td>";
echo "</br>";
}
mysql_close($connection)
?>
<form method="post" action="">
Vards: <br />
<input type="text" name="vards"><br />
majaslapa: <br />
<input type="text" name="lapa"><br />
Vestule: <br />
<textarea name="zinja" cols="60" rows="10"></textarea><br />
<input type="submit" value="pievienot">
</form>
itka viss ok vinjsh ievada bazee un izvada bet ka lapu refresho vinjsh atkal izvada to pas un ta visu laiku
CREATE TABLE `sistema`.`viesene` (
`id` INT NOT NULL AUTO_INCREMENT ,
`vards` VARCHAR( 255 ) NOT NULL ,
`lapa` VARCHAR( 255 ) NOT NULL ,
`zinja` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB;
reku msql kods ja gadijuma vesapratat ludzu palidzat ja varat izlabojat ja ne ludzu pasakat kapec ta ir!
nevarētu but vaina ar to action?