Create a small php script to create database from current existing code

Completed Posted Sep 18, 2014 Paid on delivery
Completed Paid on delivery

I want to have a database created... I currently have a small script that save all the users IP & HOSTNAME & other information into a .txt document but when my site has 100k+ visitor it is very inconvenient...

I want to have a database instead of using text document.

The database should be split into different category each one being a country. for exemple visitor from US will appear in the database table US .. all the hostname and other information my php script currently save to texts will be saved to the database

here is the php code i use:

if (stristr($hostname, $us) !== FALSE) {

$myFiley = "[url removed, login to view]";

$fh = fopen($myFiley, 'a');

fwrite($fh, $hostname);

fwrite($fh, $virgule);

fwrite($fh, $browser);

fwrite($fh, $virgule);

fwrite($fh, $referer);

fwrite($fh, $stringData);

fclose($fh);

}

It is currently working but as u can see it only save the text to a document, this should be made into database... $myfiley = [url removed, login to view] should mean table = us , so that text goes into the table us..

I also want another script , in php, that will tell me how many row there is in each table

I beleive this job is very easy as its almost like converting a small php code into another... i wont pay much.

MySQL PHP

Project ID: #6473929

About the project

13 proposals Remote project Active Sep 18, 2014

Awarded to:

khongminhphong

A proposal has not yet been provided

$15 USD in 1 day
(3 Reviews)
1.0

13 freelancers are bidding on average $24 for this job

xerobug

hi: i can develop a small db to store the information that you are currently saving in the text file, please contact me to get started

$50 USD in 1 day
(35 Reviews)
4.7
jvsundarrajan

Hi There, Can be done now. Please check my profile reviews and share this project rightnow. Thanks for the help.

$25 USD in 0 days
(22 Reviews)
3.7
cguerrac

I will do this proyect in the next 24 hours if i get assigned, For the database you prefer a datatype of INTEGER 4 bytes or simple VARCHAR. Both of them have advantages for your convenience, and i will be happy to r More

$22 USD in 1 day
(2 Reviews)
3.6
jprkhatri

Hello sir, I am professional web developer and can convert this PHP code into your requirement. Please consider my bid so we can discuss on this project. Thanks

$30 USD in 2 days
(6 Reviews)
3.2
gehadelrobey

I am a web developer with 6 years of experience, I can delver you this in 24 hours with documentation. please contact me for more information.

$20 USD in 1 day
(1 Review)
2.8
miralpatel04

Hi i'm an expert of 2 year in php and mysql. I can do this job in 2 days. Lets have a chat. thank you.

$25 USD in 2 days
(2 Reviews)
2.5
mihas

Hello. I can do this script easily. I can also add a page where you will be able to view data submitted in the database(sort,search ,etc) You are right its a pretty simple job i need just a few hours for this task. More

$30 USD in 1 day
(4 Reviews)
2.3
Infydo

Dear Client, Thank you for the opportunity. As per your requirement, I would like to tell you that we have a very strong experience of more than a year in the field if web design and development(wordpress develop More

$12 USD in 1 day
(1 Review)
0.4
shreeramsharma19

I have more than 3 years of experience in same field (Php- mysql). let me know if I can help you.............

$30 USD in 2 days
(1 Review)
0.0
shouryasohaney

A proposal has not yet been provided

$10 USD in 3 days
(0 Reviews)
0.0