Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /**
- * Created by PhpStorm.
- * User: Makhnitskiy Danil
- * Date: 30.11.2017
- * Time: 20:50
- */
- $HOST = 'localhost';
- $USER = 'root';
- $PASSWORD = '';
- try {
- $dbconnect = @mysqli_connect($HOST, $USER, $PASSWORD, 'sitesupport');
- if (!$dbconnect) {
- throw new Exception(mysqli_connect_error());
- }; //проверка на наличие таблицы
- $findtable = 'select * from INFORMATION SCHEMA.COLUMNS where column_name LIKE frmail';
- @$searchtable = mysqli_query($dbconnect, $findtable);
- //создание таковой
- if (!$searchtable) {
- $createtable = 'CREATE TABLE emailsss (
- frmail VARCHAR(100),
- scmail VARCHAR(100)
- )';
- @$createtablereq = mysqli_query($dbconnect, $createtable);
- if (!$createtablereq) {
- throw new Exception(mysqli_error($dbconnect));
- } else {
- throw new Exception('таблица создана, все прошло удачно');
- }
- } else {
- throw new Exception('таблица найдена');
- }
- } catch (Exception $errmes) {
- echo $errmes;
- };
- ?>
Add Comment
Please, Sign In to add comment