Untitled

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 16, 2016 at 05:03 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `testmysql`
--

CREATE TABLE IF NOT EXISTS `testmysql` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(65) NOT NULL,
  `lastname` varchar(65) NOT NULL,
  `email` varchar(65) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `testmysql`
--

INSERT INTO `testmysql` (`ID`, `name`, `lastname`, `email`) VALUES
(1, 'Ivan', 'Meler', 'i_ivan@widowslive.com');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


<!DOCTYPE html>
<html>
<head>
<title>MySQL and PHP</title>
</head>
<body>
<center>
<form action="main.php" method="POST">
	Ime <input type=text name=name size=65 autocomplete="off" value="">
<br>
    Prezime <input type=text name=lastname size=65 autocomplete="off" value="">
<br>
	email <input type=email name=email size=65 autocomplete="off" value="">
<br>
<input Type="submit">
</form>
</center>
<?php
error_reporting(0);
/*
TRUNCATE TABLE testmysql;
*/
@mysql_connect("localhost", "root", "");
mysql_select_db("test");
$name=$_POST["name"];
$lastname=$_POST["lastname"];
$email=$_POST["email"];

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if(!empty($name) || !empty($lastname) || !empty($email)){
	$sql = "INSERT INTO testmysql(name, lastname, email)VALUES('$name','$lastname','$email')";
}

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
}  {
	if(!empty($name) || !empty($lastname) || !empty($email)){
    echo "Error: " . $sql . "<br>" . $conn->error;
	}
}

$result=mysql_query("SELECT * FROM testmysql") or die(mysql_error());
echo "<table border=´1´ style=´width:100%´>";
echo "<td>ID</td><td>ime</td><td>prezime</td><td>email</td>";
while($row=mysql_fetch_array($result))
{
	echo "<tr><td>";
	print $row["ID"];
	print"</td><td>";
	print $row["name"];
	print"</td><td>";
	print $row["lastname"];
	print"</td><td>";
	print $row["email"];
	print"</td></tr>";
}

$conn->close();
?>
</body>
</html>