How can i run sql multiple line code after php if?

Asked Nov 17 '19 at 10:49

Active Nov 17 '19 at 10:58

Viewed 37 times

I need to include the following sql code after the "echo 'You have successfully registered, you can now login!';" how can i do this?

CREATE DATABASE IF NOT EXISTS `$username` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `$username`;

CREATE TABLE IF NOT EXISTS `diario` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `data` varchar(255) NOT NULL,
    `materia` varchar(255) NOT NULL,
    `compiti` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `diario` (`id`, `data`, `materia`, `compiti`) VALUES (1, '00/00/0000', 'Informatica', 'Benvenuto')

if ($stmt = $con->prepare('INSERT INTO accounts (username, password, email) VALUES (?, ?, ?)')) {
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $stmt->bind_param('sss', $_POST['username'], $password, $_POST['email']);
    $stmt->execute();
    echo 'You have successfully registered, you can now login!';
}

edited Nov 17 '19 at 10:58

Nigel Ren

56,122
11
43
55

asked Nov 17 '19 at 10:49

Vincenzo

3

Creating a database or table per user is generally a bad idea - https://stackoverflow.com/questions/7544544/database-efficiency-table-per-user-vs-table-of-users – Nigel Ren Nov 17 '19 at 10:53
Put the sql statement into a stored procedure, and then execute that stored procedure after successfully signing up. – Lamar Nov 17 '19 at 10:53
2

I wonder who upvoted this question :) – Karolis Nov 17 '19 at 11:29
I'd prefer to use goto, die and mysql execute command – Mystogan Nov 17 '19 at 17:34

How can i run sql multiple line code after php if?

0 Answers0