Help
<?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?
This post has been edited by realfun: 2010.03.09 16:53
