MYSQL slow queries with PHP

Question

I'm using mysql and php for registration on my web-site. Registration is ok. Mysql do queries immediately. But in login there strange things begin to happen. I insert a test in my php code to insert test row to database. First test code inserted immediately, but 2nd was inserted after series of refresh and relog actions only after 10 minutes. The 3rd test query is the same-after approximately 10 minutes after 2nd query.

Here is login code:

<?php
session_start();
if(isset($_SESSION['id'])){
        echo 'You have logged in.';
        echo $_SESSION['id'];
    } 
  else {    
        $email=$_POST['email'];
        $password=$_POST['password'];
        $db=new mysqli('','','','');  
        if (mysqli_connect_errno()) {
            echo 'Unable to connect to database: '.mysqli_connect_error().'. Please e-  mail our system administrator. We will fix this error as soon as possible. Thanks for patience and understanding. ';
            exit();
        }
//TEST QUERY
            $query="insert into test values(3, 'test')";
            $result=$db->query($query);
//LOGIN QUERY
        $query="select id from users where email='$email' and password='$password'";   
        $result=$db->query($query);   
        if ($result->num_rows==0) {
            echo 'Incorrect email or password.';               
        }  
        else {
            $row=$result->fetch_assoc();
            $_SESSION['id']=$row['id'];
            echo 'You have logged in.';
            echo $_SESSION['id'];
//THIS TEST QUERY IS NOT IMPLEMENTED
            $query="insert into test values(1, test)";
            $result=$db->query($query);
        }  
        }   
?>

Where is mistake?

Test table consists of 2 columns: id (medium int, primary key, unsigned) and test(text)

Thanks in advance.

Matt Williamson · Accepted Answer · 2010-08-13 14:11:31Z

1

Sounds like the cookie could be expiring after 10 minutes. Run echo session_cache_expire(); to see what your expiration time is set to. More details at http://php.net/manual/en/ref.session.php

answered Aug 13, 2010 at 14:11

Matt Williamson

40.3k10 gold badges67 silver badges73 bronze badges

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

3 Comments

dsplatonov Over a year ago

so? Registration page use the same configuration and queries is done immediately. May be it's because of sessions?

dsplatonov Over a year ago

echo return 180. It means that session will expire after 180 minutes?

Hans Over a year ago

probably seconds, or 3 minutes, but the documentation isn't clear. Usually those settings are in seconds, though.

Hans · Accepted Answer · 2010-08-13 14:26:27Z

1

insert into test values(1, test)

-- test -- needs quotes or you are going to get an error that the column test doesn't exist (unless it does). If it does exist, it's probably going to be empty, as mysql probably doesn't know what you mean by test -- maybe your version thinks it's a constant or something.

If you posted what the table structure of your test table is, that would help solve it probably.

answered Aug 13, 2010 at 14:26

Hans

3,5233 gold badges30 silver badges34 bronze badges

1 Comment

dsplatonov Over a year ago

yeah - in my IDE there was quotes. Test table consists of 2 columns: id (medium int, primary key, unsigned) and test(text).

DLH · Accepted Answer · 2010-08-13 14:29:01Z

1

This looks suspicious to me.

$query="insert into test values(3, 'test')";

Is it trying to set the ID of every row inserted to 3? ID's have gotta be unique.

EDIT:

This probably won't fix your problem, but it will make your life easier by not forcing you to manually change ID's each time.

INSERT INTO test SET <colname>='test'

where <colname> is the name of the column that "test" is going into.

edited Aug 13, 2010 at 14:29

answered Aug 13, 2010 at 14:16

DLH

2,8313 gold badges25 silver badges30 bronze badges

4 Comments

dsplatonov Over a year ago

yeah, right. I changed code every try. When was 1st try there was "1", then i change id to 2 and refresh the page. Query was not implemented :( only after approximately 10 minutes

DLH Over a year ago

Changing ID's manually is kind of a hassle isn't it? See my edits.

DLH Over a year ago

No problem. Oh, also make sure that id is set to auto-increment.

DLH Over a year ago

And make sure both of your INSERT queries are the same. I think your second INSERT query may have been causing problems, as Hans suggested.

Marius Schulz · Accepted Answer · 2010-08-13 14:34:01Z

1

Just a little security hint: your SQL queries are very dangerous as they are prone to SQL injection attacks. See the Wikipedia article for alternatives ...

answered Aug 13, 2010 at 14:34

Marius Schulz

16.5k12 gold badges65 silver badges100 bronze badges

Collectives™ on Stack Overflow

MYSQL slow queries with PHP

4 Answers 4

3 Comments

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related