· 6 years ago · Jun 30, 2019, 01:08 PM
1<?php
2/*
3CREATE TABLE IF NOT EXISTS `html` (
4 `id` INT NOT NULL AUTO_INCREMENT,
5 `url` VARCHAR(1024),
6 `parenturl` VARCHAR(1024),
7 `html` MEDIUMTEXT,
8 `runid` INT,
9 `createddate` TIMESTAMP DEFAULT NOW(), PRIMARY KEY (`id`)
10) ENGINE=MYISAM CHARSET=utf8 COLLATE=utf8_general_ci;
11*/
12 $_DB_CONFIG = array(
13
14 'host' => 'localhost',
15 'username' => 'xx',
16 'password' =>'xx',
17 'db' => 'rfpsite'
18 );
19
20
21 $_TABLE_NAME = 'rfpsites_mainlist';
22
23
24
25
26 $_STATES = array(
27
28 'Alabama'=>'AL',
29 'Alaska'=>'AK',
30 'Arizona'=>'AZ',
31 'Arkansas'=>'AR',
32 'California'=>'CA',
33 'Colorado'=>'CO',
34 'Connecticut'=>'CT',
35 'Delaware'=>'DE',
36 'District of Columbia'=>'DC',
37 'Florida'=>'FL',
38 'Georgia'=>'GA',
39 'Hawaii'=>'HI',
40 'Idaho'=>'ID',
41 'Illinois'=>'IL',
42 'Indiana'=>'IN',
43 'Iowa'=>'IA',
44 'Kansas'=>'KS',
45 'Kentucky'=>'KY',
46 'Louisiana'=>'LA',
47 'Maine'=>'ME',
48 'Maryland'=>'MD',
49 'Massachusetts'=>'MA',
50 'Michigan'=>'MI',
51 'Minnesota'=>'MN',
52 'Mississippi'=>'MS',
53 'Missouri'=>'MO',
54 'Montana'=>'MT',
55 'Nebraska'=>'NE',
56 'Nevada'=>'NV',
57 'New Hampshire'=>'NH',
58 'New Jersey'=>'NJ',
59 'New Mexico'=>'NM',
60 'New York'=>'NY',
61 'North Carolina'=>'NC',
62 'North Dakota'=>'ND',
63 'Ohio'=>'OH',
64 'Oklahoma'=>'OK',
65 'Oregon'=>'OR',
66 'Pennsylvania'=>'PA',
67 'Rhode Island'=>'RI',
68 'South Carolina'=>'SC',
69 'South Dakota'=>'SD',
70 'Tennessee'=>'TN',
71 'Texas'=>'TX',
72 'Utah'=>'UT',
73 'Vermont'=>'VT',
74 'Virginia'=>'VA',
75 'Washington'=>'WA',
76 'West Virginia'=>'WV',
77 'Wisconsin'=>'WI',
78 'Wyoming'=>'WY'
79 );
80
81
82require_once('./config.php');
83
84// Connecting to and selecting MySQL database
85$mysqli = new mysqli($_DB_CONFIG['host'], $_DB_CONFIG['username'], $_DB_CONFIG['password'], $_DB_CONFIG['db']);
86
87// Oh no! A connect_errno exists so the connection attempt failed!
88if ($mysqli->connect_errno) {
89 echo "Sorry, this website is experiencing problems.";
90
91 echo "Error: Failed to make a MySQL connection, here is why: \n";
92 echo "Errno: " . $mysqli->connect_errno . "\n";
93 echo "Error: " . $mysqli->connect_error . "\n";
94 exit;
95}
96
97function sql_error($sql) {
98 global $mysqli;
99 echo "Error: Our query failed to execute and here is why: \n";
100 echo "Query: " . $sql . "\n";
101 echo "Errno: " . $mysqli->errno . "\n";
102 echo "Error: " . $mysqli->error . "\n";
103 exit;
104}
105
106?>