Guest User

Untitled

a guest
Dec 1st, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Makhnitskiy Danil
  5. * Date: 30.11.2017
  6. * Time: 20:50
  7. */
  8. $HOST = 'localhost';
  9. $USER = 'root';
  10. $PASSWORD = '';
  11. try {
  12. $dbconnect = @mysqli_connect($HOST, $USER, $PASSWORD, 'sitesupport');
  13.  
  14. if (!$dbconnect) {
  15. throw new Exception(mysqli_connect_error());
  16. }; //проверка на наличие таблицы
  17. $findtable = 'select * from INFORMATION SCHEMA.COLUMNS where column_name LIKE frmail';
  18. @$searchtable = mysqli_query($dbconnect, $findtable);
  19. //создание таковой
  20. if (!$searchtable) {
  21. $createtable = 'CREATE TABLE emailsss (
  22. frmail VARCHAR(100),
  23. scmail VARCHAR(100)
  24. )';
  25. @$createtablereq = mysqli_query($dbconnect, $createtable);
  26. if (!$createtablereq) {
  27. throw new Exception(mysqli_error($dbconnect));
  28. } else {
  29. throw new Exception('таблица создана, все прошло удачно');
  30. }
  31. } else {
  32. throw new Exception('таблица найдена');
  33. }
  34.  
  35. } catch (Exception $errmes) {
  36. echo $errmes;
  37. };
  38. ?>
Add Comment
Please, Sign In to add comment