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

  • The WordPress.com Year in Review (and Resolutions for 2018) January 3, 2018
    It was quite a year for the WordPress.com community, and we've got a lot to look forward to.
  • Managing Your Blog On a Mobile Device December 13, 2017
    A few enhancements we've added to the iOS and Android apps for easier blogging.
  • New Premium Themes: Small Business and Photo Blog December 7, 2017
    Introducing two new premium themes: Small Business, made for your entrepreneurial endeavors, and Photo Blog, designed to make your photography shine.
  • Updated Privacy Policy December 4, 2017
    As part of our commitment to privacy and transparency, we’re updating our Privacy Policy. We want to give you more information about how we collect and use personal information — in a more organized and readable format. “Your privacy is critically important to us.” These are the first words of …
  • Update Your Avatar on WordPress.com October 12, 2017
    Manage, upload, and edit your profile photo at wordpress.com/me.
  • A New Media Picker for the iOS WordPress App October 9, 2017
    Sometimes it’s the extra touches that make all the difference; on your website, that’s the photos and video that give your content life. You asked for streamlined access to your media library and the camera and photos on your device, to make uploading and inserting photos and videos easier. We …