[ bobajakuda @ 11.08.2015. 16:22 ] @
Napravio sam bazu podataka i u nju pomocu php ubacujem zapise.
E sad me muci kako da ubacim da dugme reset brise sve iz nje?
Ovako izgleda kod..


forma.html

<form action="process.php" method="post">
<input type="text" name="fname" placeholder="First Name"/>
<input type="text" name="lname" placeholder="Last Name"/>
<input type="submit" name="sbmt" value="Save"/>
<input type="reset" name="delete" value="Delete"/>
</form>



index.php

<?php
$mysqli = @mysqli_connect("localhost","root","","assignment");

if(mysqli_connect_error($mysqli)){
echo "Konekcija nije uspostavljena";
}
else{

$res = mysqli_query($mysqli,"select * from korisnik");

while($user = mysqli_fetch_row($res)){
echo "Id korisnika je : " . $user[0] . "<br />";
echo "Ime korisnika je : " . $user[1] . "<br />";
echo "Prezime korisnika je : " . $user[2] . "<br />";
}
}



process.php

<?php

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$delete = $_POST['delete'];

$mysqli = mysqli_connect("localhost","root","","assignment");

mysqli_query($mysqli,"insert into korisnik values(null,'$fname','$lname')");

if(isset $_POST['delete']) {
mysqli_query ( $mysqli,'TRUNCATE TABLE korisnik' );
}
[ djordjevic_i @ 16.09.2015. 09:09 ] @
Code:
query = 'DELETE FROM myTable';