<?php
$host="127.0.0.1";
$username="korisnicko_ime";
$password="tvoj_password";
$database="my_db";
$connect=mysql_connect($host,$username,$password) or die;
echo "Connected to MySQL<br>";
echo "Info:<br>Host:[$host]<br>Database:[$database]<br>";
mysql_select_db($database);
echo "Database selected:[$database]";
mysql_query("CREATE DATABASE mojabaza"); //kreira bazu sa imenom 'mojabaza'
$sql="CREATE TABLE korisnik
(
Ime varchar(15),
Prezime varchar(15),
God int)"; //kreira tabelu sa imenom 'korisnik' i u tabelu ubacuje kolone Ime,Prezime i Godiste sa deklarisanim tipovima
mysql_query($sql,$connect);
mysql_query("INSERT INTO korisnik (Ime,Prezime,Godiste)VALUES('Dejan','Lazarevic','95')"); //ubacuje vrednosti u tabelu korisnici
$sal=mysql_query("SELECT * FROM korisnik");
while($row=mysql_fetch_array($sal))
{
echo $row['Ime'];
echo $row['Prezime'];
echo $row['Godiste'];
}
mysql_close($connect);
?>