How to connect to someone out of your network on Linkedin

Reading Time: < 1 minute

These days I am looking for a web developer in Lithuania. It is not very easy because it’s a small country… but on Linkedin you can find quite many profiles.

The problem is, sometimes you can’t connect to these people because they are too far out of your network.

Usually you would get the first name of the person and some skills in his profile.

How to get the value of the latest auto-incremented value on a mysql table with concurrent connections

Reading Time: < 1 minute

When building a web application it can seem a bit tricky to get the value of the id (primary key) of the latest row inserted in a mysql table.

It is not that complicated.

The function LAST_INSERT_ID() can help you finding that. This function will return the latest auto-incremented value. No need to specify the table, it just takes the latest one.

SELECT LAST_INSERT_ID() ;

The next question is: what happens when I have many concurrent sessions on the same server? Will I get the latest inserted id from another user?

install a lamp server on ubuntu

Reading Time: < 1 minute

Easy!

sudo apt-get install lamp-server^

Be careful not to delete the ^ character.

This will install: 

Modify the session timeout in phpmyadmin

Reading Time: < 1 minute

Login and re-login and re-re-login in phpmyadmin is a huge pain.

Here is the way to extend sessions duration.

Open the file config.inc.php in /usr/share/phpmyadmin or in /etc/phpmyadmin

Add the following line:

$cfg['LoginCookieValidity']=86400;

And in php.ini, modify the following line:

session.gc_maxlifetime = 86400

Restart apache.

apache2ctl restart

You now have 24h sessions.