Code: Select all
<?php
$user = $_GET['user'];
// Make a MySQL Connection
mysql_connect("mysql_server", "username", "password") or die(mysql_error());
mysql_select_db("users") or die(mysql_error());
// Create a MySQL table in the selected database
mysql_query("CREATE TABLE $user(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
email VARCHAR(80),
file VARCHAR(80)")
or die(mysql_error());
echo "Table "$user" created!";
?>
Code: Select all
<?php
$user = $_GET['user'];
$email = $_GET['email'];
$file = $_GET['file'];
// Make a MySQL Connection
mysql_connect("mysql_server", "username", "password") or die(mysql_error());
mysql_select_db("users") or die(mysql_error());
// Insert a row of information into the table $user
mysql_query("INSERT INTO $user
(email, file) VALUES($email, $file ) ")
or die(mysql_error());
echo "Data inserted!";
?>Thanks,
Alex