What is the best way to access a database from PHP?
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?
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
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
I am trying to write a SQL statement to return the latest record for each subject for a person
MySQL LEFT JOIN – Values can be NULL
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?
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
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?
Since you can access your database remotely, you can use mysqldump from your windows machine to fetch the remote database. From commandline:
Blog Categories
Share This Page
Tag Cloud
Wordpress News
- Stats Wrangling I: Digging into Your Data June 18, 2013Chances are that if you’re running a public facing blog, you’re probably happiest when someone actually reads it. Preferably lots of someones. Your blog’s stats can give you some great ways to get to know a little bit more about your readers, and what it is about your work that most attracts them. While the […] […]
- The WordPress.com Dashboard Gets a Beautiful Makeover June 17, 2013Each day, you blog, you create, and you make things with your WordPress.com site. Meanwhile, behind the scenes, the code that runs WordPress.com gets updated dozens of times a day, as we deploy improvements. While you can’t see the vast majority of those changes, there is one improvement we can’t wait for you to see: […] […]
- DaddyBloggers in the Spotlight: A Father’s Day Roundup June 16, 2013Writing about family life and parenthood is not simply the province of mothers: dads are carving out their own blogular niche. Single dads, stay-at-home dads, working dads, two-dad families — you can find every perspective on WordPress.com. As the US celebrates Father’s Day, here are some dad blogs we love: DorkDaddy.com What’s the point of […] […]
- Freshly Pressed: Friday Faves June 14, 2013Every post that glides into our Reader offers us a fresh perspective and an opportunity to peer into another blogger’s mind. We’re invited to enter new worlds, and examine the shapes, angles, and textures of the blogging craft itself. This week, once again, the diversity of the WorldPress.com community thrilled us. The three posts we […] […]
- New on WordPress for Android: Notifications June 12, 2013Need to get your WordPress.com Notifications on the go? With version 2.4 of WordPress for Android you’ll see all your Notifications right on your Android device. Step away yet stay connected With the new streamlined Notifications view, you can step away from your computer but still stay connected to your readers. With just a few […] […]
- New Theme: Forefront June 11, 2013Today, I’m excited to announce our newest theme. Don’t worry, your calendar is not broken. It’s not Theme Thursday but we just couldn’t hold this theme back any longer! Forefront is a business and corporate theme designed by one of our own, Takashi Irie. The theme is packed with nifty features such as custom page […] […]