///////////////////////////////////////////////////ftiaxnw ton pinaka
$sql="CREATE TABLE `katalogos`.`stoixeia` (
`onoma` VARCHAR( 10 ) NOT NULL ,
`eponimo` VARCHAR( 10 ) NOT NULL ,
`tilefono` INT( 10 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `tilefono` )
)";
$res=mysqli_query($mysqli,$sql);
if($res===TRUE)
{
echo "table created"."<br/>";
}
else
{
echo "table not created".mysqli_error($mysqli)."<br/>";
}
$sql1="INSERT INTO `katalogos`.`stoixeia` (
`onoma` ,
`eponimo` ,
`tilefono`
)
VALUES (
'eleni', 'georgiou', '2109988777'
)";
$res1=mysqli_query($mysqli,$sql1);
if($res1==TRUE)
{
echo "res ok";
}
else
{
echo "res not ok".mysqli_error($mysqli)."<br/>";
}
}