Guest User

Untitled

a guest
Mar 15th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. <?php
  2. if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['formid']) && $_POST['formid'] == 'My-Form-Name')
  3. {
  4. $success_url = './success-page.html';
  5. $error_url = './error-page.html';
  6. $error = '';
  7. $mysql_server = null;
  8. $mysql_database = 'My-DB';
  9. $mysql_table = 'My-Table';
  10. $mysql_username = 'My-Username';
  11. $mysql_password = 'My-Password';
  12. $mysql_port = null;
  13. $mysql_socket = '/cloudsql/CloudSql-Instance-Connection-Name';
  14. $eol = "n";
  15. $db = mysqli_connect($mysql_server, $mysql_username, $mysql_password, $mysql_database, $mysql_port, $mysql_socket) or die('Failed to connect to database server!<br>'.mysqli_error($db));
  16. mysqli_set_charset($db, 'utf8');
  17. mysqli_query($db, "CREATE DATABASE IF NOT EXISTS $mysql_database");
  18. mysqli_select_db($db, $mysql_database) or die('Failed to select database<br>'.mysqli_error($db));
  19. mysqli_query($db, "CREATE TABLE IF NOT EXISTS $mysql_table (ID int(9) NOT NULL auto_increment, `DATESTAMP` DATE, `TIME` VARCHAR(8), `IP` VARCHAR(15), `BROWSER` TINYTEXT, PRIMARY KEY (id))");
  20. foreach($form_data as $name=>$value)
  21. {
  22. mysqli_query($db ,"ALTER TABLE $mysql_table ADD $name VARCHAR(255)");
  23. }
  24. mysqli_query($db, "INSERT INTO $mysql_table (`DATESTAMP`, `TIME`, `IP`, `BROWSER`, `REFERER`)
  25. VALUES ('".date("Y-m-d")."',
  26. '".date("G:i:s")."',
  27. '".$_SERVER['REMOTE_ADDR']."',
  28. '".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']."',
  29. '".$_SERVER['HTTP_USER_AGENT']."')")or die('Failed to insert data into table!<br>'.mysqli_error($db));
  30. $id = mysqli_insert_id($db);
  31. foreach($form_data as $name=>$value)
  32. {
  33. mysqli_query($db, "UPDATE $mysql_table SET $name='".mysqli_real_escape_string($db, $value)."' WHERE ID=$id") or die('Failed to update table!<br>'.mysqli_error($db));
  34. }
  35. mysqli_close($db);
  36. header('Location: './$success_url);
  37. exit;
  38. }
  39.  
  40. # to serve all php scripts
  41. - url: /(.+.php)$
  42. script: 1
Add Comment
Please, Sign In to add comment