PHP MySQL Application Running Local Network and Update Data Online Server

Question

I've created a php, MySql application about daily staff attendance report which is running on local linux server. I would like to keep my database online so that anyone can access the report remotely outside the office. but the data feeding must be in the local server.Can anybody give me an idea to implement this ? I'm not looking for database replication solution. I need to keep the Data feeding application Local and Database Online.

write your server details in db config file on local. isn't it working? — xkeshav
– xkeshav, Commented Dec 3, 2011 at 6:46

Throoze · Accepted Answer · 2011-12-03 07:17:32Z

1

Add this at the beginning of your data feeding scripts:

if (!in_array(@$_SERVER['REMOTE_ADDR'], array('127.0.0.1', '::1')))
{
  die('Remote access for this section is forbidden...');
}

This code was extracted from the development controller file provided by the Symfony framework

You can play with the array in the if condition to allow access only from certain IP addresses.

Hope to be helpful! Good luck! =)

answered Dec 3, 2011 at 7:17

Throoze

4,0588 gold badges48 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP MySQL Application Running Local Network and Update Data Online Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related