· 7 years ago · Mar 02, 2019, 04:48 PM
1<?php
2session_start();
3$conn = mysql_connect("localhost", "root", "");
4mysql_select_db("db103",$conn);
5
6$sql = "insert into sinup values (' ', '$_POST[name]' , '$_POST[email]' ,'$_POST[password]' )";
7
8if (mysql_query($sql,$conn))
9{
10 $sql1 = "CREATE TABLE if not exists ".$_SESSION['email']. " (
11 id INT(6) AUTO_INCREMENT PRIMARY KEY,
12 firstname VARCHAR (30) NOT NULL,
13 lastname VARCHAR (30) NOT NULL,
14 telephon VARCHAR (10) NOT NULL,
15 celephon VARCHAR (14) NOT NULL,
16 address VARCHAR (30) NOT NULL
17 )";
18if (mysql_query($sql1,$conn)){
19 echo "Table created successfully";
20} else {
21 echo(mysql_error());
22}
23}
24else
25{
26 echo(mysql_error());
27);
28}
29
30
31?>