· 8 years ago · Mar 15, 2018, 07:12 PM
1<?php
2if ($_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