tufanv Expert Licensed User Longtime User Jun 16, 2014 #1 Hello, I am using an local apache server and mysql to store data. I want to update the tables "lastlogin" col each time a member login to system with the date of server. ( i will update the last login ). How can i get the server date.? any ideas ty
Hello, I am using an local apache server and mysql to store data. I want to update the tables "lastlogin" col each time a member login to system with the date of server. ( i will update the last login ). How can i get the server date.? any ideas ty
udg Expert Licensed User Longtime User Jun 16, 2014 #2 You could use http2 to send query "SELECT NOW();" to your MySql server. In the callback function you should receive a string like "2014-12-28 23:50:26". I'm not sure this is what you asked for and how it is related to B4A. Umberto Upvote 0
You could use http2 to send query "SELECT NOW();" to your MySql server. In the callback function you should receive a string like "2014-12-28 23:50:26". I'm not sure this is what you asked for and how it is related to B4A. Umberto
tufanv Expert Licensed User Longtime User Jun 16, 2014 #3 I am using a mysql server in my app. I need to check the server date within the app. Thats the reason . I am not much familiar war those queries. TY will try it our udg said: You could use http2 to send query "SELECT NOW();" to your MySql server. In the callback function you should receive a string like "2014-12-28 23:50:26". I'm not sure this is what you asked for and how it is related to B4A. Umberto Click to expand... Upvote 0
I am using a mysql server in my app. I need to check the server date within the app. Thats the reason . I am not much familiar war those queries. TY will try it our udg said: You could use http2 to send query "SELECT NOW();" to your MySql server. In the callback function you should receive a string like "2014-12-28 23:50:26". I'm not sure this is what you asked for and how it is related to B4A. Umberto Click to expand...