kenad

<?php
$servername="localhost";
$username="root";
$password="";

//Pravljenje konekcije
$conn=new mysqli($servername,$username,$password);
//Provjera konekcije
if($conn->connect_error){
	die("Nema konekcije:".$conn->connect_error);
}
//Pravljenje baze podataka skola
$sql="CREATE DATABASE skola";
if($conn->query($sql)===TRUE){
	echo "Baza podataka <b>skola</b> je uspjesno kreirana!";
}else{
	echo "Greska pri kreiranju baze podataka:".$conn->error;
}
$conn->close();
?>

<?php
$servername="localhost";
$username="root";
$password="";
$dbname="skola";
?>


<?php
include "konekcija.php";

$conn=new mysqli($servername,$username,$password,$dbname);
//Check connection
if ($conn->connect_error){
	die("Nema konekcije:".$conn->connect_error);
}
$sql = "CREATE TABLE ucenici(
sifra VARCHAR(30)PRIMARY KEY,
prezime VARCHAR(30)CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
ime VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
razred INT(1),
odjeljenje CHAR(1)
)";
if ($conn->query($sql)===TRUE){
	echo "Tabela <b>ucenici</b> je uspjesno kreirana!";
}else{
	echo "Greska pri kreiranju tabele:".$conn->error;
}
$conn->close();
?>