Live data feed

[Briant142]

I have created a webpage to accept live feed of data by vendor "posting" the data to my url using the following code

[code]$input = array();
$input['email'] = $_POST['email'];
$input['source'] = $_POST['source'];
$input['ts'] = $_POST['ts'];
$input['ip'] = $_POST['ip'];[/code]

I have created a database and a table.  How do I reference the database and table in my website to store the data posted to the database I have created?

[trq]

You connect to your database using [url=http://php.net/mysql_connect]mysql_connect[/url](). You then reference the table using sql (structured query language), nothing to do with php really.

[Briant142]

the  mysql_connect() should be in the index.php before $input = array();
$input['email'] = $_POST['email'];
$input['source'] = $_POST['source'];
$input['ts'] = $_POST['ts'];
$input['ip'] = $_POST['ip'];

[Briant142]

where do I insert mysql_connect() to attach to my dbase?  Do I insert it in the index.php?

[ryanlwh]

you insert the mysql code whenever you need it. if you're doing this processing in process.php, insert the connection there. you may find it helpful to have this connection code saved in a separated file, then include this file when needed.