Click here to Skip to main content
15,883,901 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
Questionhow to open .zip file in php Pin
udch3-Feb-10 7:24
udch3-Feb-10 7:24 
AnswerRe: how to open .zip file in php Pin
Luc Pattyn3-Feb-10 7:29
sitebuilderLuc Pattyn3-Feb-10 7:29 
GeneralRe: how to open .zip file in php Pin
Smithers-Jones5-Feb-10 2:55
Smithers-Jones5-Feb-10 2:55 
QuestionJavascript Menu inside <table> tag</table> Pin
chandni patel2-Feb-10 23:35
chandni patel2-Feb-10 23:35 
AnswerRe: Javascript Menu inside tag Pin
Sujan Dhakal3-Feb-10 2:13
Sujan Dhakal3-Feb-10 2:13 
AnswerRe: Javascript Menu inside tag Pin
cjoki4-Feb-10 7:44
cjoki4-Feb-10 7:44 
Questiongive me some advise for my linxu road! [modified] Pin
wbgxx31-Jan-10 6:36
wbgxx31-Jan-10 6:36 
AnswerRe: give me some advise for my linxu road! Pin
HimanshuJoshi16-Feb-10 2:03
HimanshuJoshi16-Feb-10 2:03 
JokeRe: give me some advise for my linxu road! Pin
Richard MacCutchan16-Feb-10 2:45
mveRichard MacCutchan16-Feb-10 2:45 
GeneralRe: give me some advise for my linxu road! Pin
LloydA1116-Mar-10 12:03
LloydA1116-Mar-10 12:03 
GeneralRe: give me some advise for my linxu road! Pin
wbgxx10-Apr-10 20:27
wbgxx10-Apr-10 20:27 
AnswerRe: give me some advise for my linxu road! Pin
ChinaLoong20-Mar-10 1:54
ChinaLoong20-Mar-10 1:54 
QuestionSEO and php site Pin
sharkbc28-Jan-10 16:55
sharkbc28-Jan-10 16:55 
AnswerRe: SEO and php site Pin
vorotnik8-Feb-10 4:07
vorotnik8-Feb-10 4:07 
AnswerRe: SEO and php site Pin
abushahin8-Feb-10 9:14
abushahin8-Feb-10 9:14 
QuestionTimestamps... Can't Seem to get it to work..... Pin
thebiostyle27-Jan-10 14:23
thebiostyle27-Jan-10 14:23 
Okay, I tried using W3Schools to "UPDATE" a timestamp, upon logging in, here is my code:

$sql = mysql_query('UPDATE `DBNAME`.`TABLENAME` SET `lastactive` = NOW() WHERE `TABLENAME`.`username` = $username ;');


Here is the login code:

if(isset($_POST['login'])){
$username= trim($_POST['username']);
$password = trim(md5($_POST['password']));
if($username == NULL OR $password == NULL){
$final_report.="Please complete all the fields below..";
}else{
$check_user_data = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'") or die(mysql_error());
if(mysql_num_rows($check_user_data) == 0){
$final_report.="The username that you submitted does not exist..";
}else{
$get_user_data = mysql_fetch_array($check_user_data);
if($get_user_data['password'] == $password){
$start_idsess = $_SESSION['username'] = "".$get_user_data['username']."";
$start_passsess = $_SESSION['password'] = "".$get_user_data['password']."";


That is the code above the timestamp issue. The page loads and everything, it just doesn't update it into the database... Please Help. Thanks!
AnswerRe: Timestamps... Can't Seem to get it to work..... Pin
Graham Breach27-Jan-10 23:02
Graham Breach27-Jan-10 23:02 
AnswerRe: Timestamps... Can't Seem to get it to work..... Pin
fly90428-Jan-10 1:07
fly90428-Jan-10 1:07 
QuestionPerl "days in the future" Pin
m. holliday20-Jan-10 9:32
m. holliday20-Jan-10 9:32 
AnswerRe: Perl "days in the future" Pin
Graham Breach20-Jan-10 10:11
Graham Breach20-Jan-10 10:11 
QuestionReiserFS disc accessing Pin
Aljaz11115-Jan-10 12:31
Aljaz11115-Jan-10 12:31 
AnswerRe: ReiserFS disc accessing Pin
Jimmanuel18-Jan-10 3:13
Jimmanuel18-Jan-10 3:13 
Questiondate difference script Pin
Jay Tee13-Jan-10 18:46
Jay Tee13-Jan-10 18:46 
AnswerRe: date difference script Pin
Rob15-Jan-10 4:16
Rob15-Jan-10 4:16 
AnswerRe: date difference script Pin
Sethsdad15-Jan-10 7:51
Sethsdad15-Jan-10 7:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.