Browsing articles tagged with " php mysql developer"

What is the best way to access a database from PHP?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, PHP Tutorial  //  No Comments

choose the MDB2 database abstraction layer from PEAR – it provides a nice, abstracted method to deal with the database. I recommend it, since it allows you to write portable code which can be ported to a different database server without many changes required (for a basic script, just changing the connect call is likely to be sufficient). It is a merge of the old DB and Metabase abstraction layers (DB is still supported for bugfixes, but has been superceded by MDB2). Read more >>

What XML parser do you use for PHP?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, PHP Tutorial  //  No Comments

SimpleXML and DOM work seamlessly together, so you can use the same XML interacting with it as SimpleXML or DOM.
Read more >>

how to get username on every page in php

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I wanted to update my column url which is the last visited url of the logged in user i want to retrieve my username of the logged in user
Read more >>

Limiting a mysql result

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I am trying to write a SQL statement to return the latest record for each subject for a person

Read more >>

MySQL LEFT JOIN – Values can be NULL

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I’m modifying a MySQL statement but having a few troubles with LEFT JOIN and blank rows.
Read more >>

How to get the sizes of the tables of a mysql database?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

To get the sizes of all tables in a mysql database:
Read more >>

Does the PHP mail() function work if I don’t own the MX record

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, PHP Tutorial  //  No Comments

Yes. It will work just fine. I have a PHP script using the mail() function with the MX records set to Google Apps.
Read more >>

How to download a live MySQL db into a local test db on demand, without SSH?

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, PHP Tutorial  //  No Comments

Since you can access your database remotely, you can use mysqldump from your windows machine to fetch the remote database. From commandline:

Read more >>

Share This Page

RSS Wordpress News