· 10 years ago · Mar 16, 2016, 06:45 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 16, 2016 at 05:03 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `test`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `testmysql`
27--
28
29CREATE TABLE IF NOT EXISTS `testmysql` (
30 `ID` int(4) NOT NULL AUTO_INCREMENT,
31 `name` varchar(65) NOT NULL,
32 `lastname` varchar(65) NOT NULL,
33 `email` varchar(65) NOT NULL,
34 PRIMARY KEY (`ID`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
36
37--
38-- Dumping data for table `testmysql`
39--
40
41INSERT INTO `testmysql` (`ID`, `name`, `lastname`, `email`) VALUES
42(1, 'Ivan', 'Meler', 'i_ivan@widowslive.com');
43
44/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
45/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
46/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
47
48
49
50<!DOCTYPE html>
51<html>
52<head>
53<title>MySQL and PHP</title>
54</head>
55<body>
56<center>
57<form action="main.php" method="POST">
58 Ime <input type=text name=name size=65 autocomplete="off" value="">
59<br>
60 Prezime <input type=text name=lastname size=65 autocomplete="off" value="">
61<br>
62 email <input type=email name=email size=65 autocomplete="off" value="">
63<br>
64<input Type="submit">
65</form>
66</center>
67<?php
68error_reporting(0);
69/*
70TRUNCATE TABLE testmysql;
71*/
72@mysql_connect("localhost", "root", "");
73mysql_select_db("test");
74$name=$_POST["name"];
75$lastname=$_POST["lastname"];
76$email=$_POST["email"];
77
78$servername = "localhost";
79$username = "root";
80$password = "";
81$dbname = "test";
82
83
84$conn = new mysqli($servername, $username, $password, $dbname);
85
86if ($conn->connect_error) {
87 die("Connection failed: " . $conn->connect_error);
88}
89if(!empty($name) || !empty($lastname) || !empty($email)){
90 $sql = "INSERT INTO testmysql(name, lastname, email)VALUES('$name','$lastname','$email')";
91}
92
93if ($conn->query($sql) === TRUE) {
94 echo "New record created successfully";
95} {
96 if(!empty($name) || !empty($lastname) || !empty($email)){
97 echo "Error: " . $sql . "<br>" . $conn->error;
98 }
99}
100
101$result=mysql_query("SELECT * FROM testmysql") or die(mysql_error());
102echo "<table border=´1´ style=´width:100%´>";
103echo "<td>ID</td><td>ime</td><td>prezime</td><td>email</td>";
104while($row=mysql_fetch_array($result))
105{
106 echo "<tr><td>";
107 print $row["ID"];
108 print"</td><td>";
109 print $row["name"];
110 print"</td><td>";
111 print $row["lastname"];
112 print"</td><td>";
113 print $row["email"];
114 print"</td></tr>";
115}
116
117$conn->close();
118?>
119</body>
120</html>