automatically insert data in mysql

valen53

hi, now i doing a reservation system. i hope that the MySQL database can be automatically insert data everyday. But i dunno have any function can do that way beside using PHP script. anyone can help me???

sarahk

Webpages are mini programs and nothing happens automatically without someone spending time deciding what needs to be done and writing the code to make it happen. You will need some sort of server side coding to write to the database - that could be php, asp, java, perl and the list goes beyond that. Decide what you want to do, then read lots of tutorials, play with examples.

Once you have a feel for what is possible with your new skills, and you've decided what you want you will know whether you can do the job yourself or if you need to get the professionals in.

And yes, while you can do alot yourself you do sometimes need to bring specialists in.

tasistro

if you have access to command line php like in:

php %myscript%

and that runs your script you can set up a cron job
see
man cron

or if not, but you have lynx or curl installed in your system then set up
a cron job that iwll run lynx with the target page.

your target page would then be the script that automatically inserts info into mysql

Saludos
Gerardo

valen53

after viewing senior comment,it quite useful. But i not very understand about the "cron" . is it function in PHP or mySql?
Actually i got a solution if i write in PHP script, but i wish can do in mysql.

in PHP script, i will..
when log on homepage, auto running mysql statement..
insert data to mysql....