News Feed
Jobs Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Tutorial:
Getting Started with Google Cloud SQL (Screencast)
November 20, 2013 @ 09:22:05

Jonathan Simon (of Google) send in a note about a video walkthrough of the Google Cloud SQL product and how to get started using it from a basic PHP script.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services. By offering the capabilities of a familiar MySQL database, the service enables you to easily move your data, applications, and services in and out of the cloud. This enables high data portability and helps you achieve faster time-to-market because you can quickly leverage your existing database.

Most of the video is about the setup and creation of a new database in the cloud service, but closer to the end (starting at about 7:20) they walk you through the PHP side. The connection is just a simple mysql_connect (mysqli anyone?) to the remote Google host with the user/pass you set up before. They also show a bit about database management with a phpMyAdmin instance.

0 comments voice your opinion now!
google cloudsql introduction phpmyadmin screencast

Link: https://www.youtube.com/watch?v=_kQXgjIfLgo

Ars Technica:
Questions abound as malicious phpMyAdmin backdoor found on SourceForge site
September 26, 2012 @ 09:45:59

As Ars Technica reports, there was a recent exploit found on the SourceForce website's installation of phpMyAdmin that allowed an attacker to POST anything to the site to be executed.

Developers of phpMyAdmin warned users they may be running a malicious version of the open-source software package after discovering backdoor code was snuck into a package being distributed over the widely used SourceForge repository. The backdoor contains code that allows remote attackers to take control of the underlying server running the modified phpMyAdmin, which is a Web-based tool for managing MySQL databases. The PHP script is found in a file named server_sync.php, and it reads PHP code embedded in standard POST Web requests and then executes it. T

The backdoor was somehow snuck into the code of phpMyAdmin on one of the mirrors and distributed to those downloading version 3.5.2.2. They think that the only downloads that were tainted with this issue were on the "cdnetworks" mirror site. You can find out more about the issue in this advisory - be sure you check your installation for a "server_sync.php" file and remove it if it exists.

0 comments voice your opinion now!
phpmyadmin sourceforge malicious eval serversync backboor


Lorna Mitchell's Blog:
phpMyAdmin Designer View
June 30, 2011 @ 11:29:56

Lorna Mitchell has a new post today spotlighting a handy feature of the phpMyAdmin tool - the visual designer view. It allows you to build (and see) the relationships between your MySQL-based application's elements.

I'm happier at the command line, but needed some graphical representation of information and easy ways to export example queries for the book I'm working on. I noticed that phpMyAdmin now has a Designer tab, which shows relationships between tables and allows you to define them.

She includes two screenshots of the process of setting up a foreign key on two tables. You can find lots more articles related to the designer view here.

0 comments voice your opinion now!
phpmyadmin designer view table mysql foreignkey


PHPBuilder.com:
Top 10 phpMyAdmin Tips and Tricks You May Not Know
February 09, 2011 @ 12:41:54

In this new article on PHPBuilder.com today, they share ten handy tips that you might not have known you could do with the phpMyAdmin tool.

Despite approaching its 12th birthday, phpMyAdmin is still under active development, with at least one significant version released every year since the project's inception. In fact even after almost a decade of use I still marvel over discovering features which I had no idea existed. In this article I thought I'd highlight 10 useful phpMyAdmin features which may have escaped you during your daily interaction with this fantastic utility.

Making the list of their ten tips are things like:

  • Manage User Privileges
  • Change the Theme
  • Monitor Server Status
  • Create PDF Relational Diagrams
  • Use Your Native Language
0 comments voice your opinion now!
phpmyadmin tip trick tutorial


SitePoint PHP Blog:
3 Lightweight Alternatives to phpMyAdmin
October 27, 2010 @ 08:19:46

On the SitePoint PHP blog, there's a new post offering your three more lightweight database management solutions than the typical phpMyAdmin install.

For much of the time, developers just want to check some data, alter a few records, or back up the database. The phpMyAdmin and MonoQL zipped distributions range from 2MB to 7MB, and they're overkill for most day-to-day administration. You're using a sledgehammer to crack a peanut. Here are three lightweight MySQL administration alternatives you should consider. They're all PHP-based, open source, and great for quick database tasks.

The three that made their short list are:

Others suggested in the comments include Chive and DBKiss.

0 comments voice your opinion now!
lightweight alternative phpmyadmin database management


Jay Allen's Blog:
Adminer | The World's Smallest MySQL Admin Script
October 15, 2010 @ 12:17:20

Jay Allen has found what he calls the world's smallest MySQL admin script and has posted about it to his CodingThis.com blog - Adminer.

I've spent years using phpMyAdmin (much to my chagrin). And I've recently warmed up to MySQL Workbench. But it wasn't until this week that I stumbled across Adminer, a single-file PHP application for MySQL administration. It's hard not to be impressed by Adminer, which is both devilishly simple and elegantly designed. The file downloads as adminer-2.3.2.php; save it as index.php in a folder named adminer, then navigate to http://servername.com/adminer/. Supply the name of your MySQL server (adding a colon if it's hosted on a non-standard port), your username, and password, and you're off!

He includes a few screenshots of the interface to create tables and manage them. If you've used the phpMyAdmin interface, you'll find a lot of things that are familiar in Adminer. If you're interesting in grabbing the latest source, you can pull it from SourceForge.

5 comments voice your opinion now!
administration adminer database phpmyadmin


Content with Style:
Viewing BLOB content in phpMyAdmin
November 20, 2009 @ 08:57:08

New from the Content with Style blog today there's a quick tip from Matthias Willerich for phpMyAdmin users who are having issues viewing the content of blob data types.

n my phpMyAdmin installation, version 3.1.1, none of the old style config settings [...] had any effect, and the solution was terribly elusive. "view blob", "show blob", "display blob", all that Google suggested were people asking the same question, at various ages of the internet.

Finally, after wading through negative comments of forums and not getting much help at all, Matthias dug into the source and found a session variable that can be set to true and the content magically appears.

0 comments voice your opinion now!
phpmyadmin blob content quicktip


Web Designer Online:
10 great Alternatives to phpMyAdmin
November 10, 2009 @ 13:04:13

The Web Designer Online blog has posted a list of their top ten alternatives to the popular phpMyAdmin database management package.

Now, I agree that phpMyAdmin is one of the best out there and is is very user friendly. I myself also used phpMyAdmin much until recently… I got introduced to another program which within an hour became my favourite and also this led me to research others out there. Thus, this post!

Other options included in their list are:

Be sure to check out the comments for more thoughts and ideas to add to the list.

1 comment voice your opinion now!
phpmyadmin alternative database manage


Michelangelo van Dam's Blog:
Book review Mastering phpMyAdmin 3.1
August 17, 2009 @ 08:14:10

Michelangelo van Dam has posted a review of the updated version of the Packt Publishing book "Mastering phpMyAdmin", time time covering the 3.1 version.

A couple of weeks ago I received a book from PACKT Publishing titled "Mastering phpMyAdmin 3.1 for Effective MySQL Management" written by Marc Delisle, with the request if I could read it and write a review about it. Why not ? I haven't used phpMyAdmin in whole my career so I might as well read about the tool everyone around me is using. And since phpMyAdmin is also bundled with Zend Server, it can only benefit my day-to-day job.

He talks about the contents of the book (chapters on the phpMyAdmin interface, working with MySQL on the command line) and some of the handy bits of information he learned along the way.

0 comments voice your opinion now!
bookreview mastering phpmyadmin packt


Kae Verens' Blog:
Mastering phpMyAdmin 3.1
July 14, 2009 @ 11:48:44

Kae Verens recently posted a book review to his blog about the Packt publishing book "Mastering phpMyAdmin 3.1" and describes how the book is different from its predecessor (covering phpMyAdmin 2.11).

There are many reviews of this book already, so I will mostly describe how this edition is different from the previous one. In short, though, I would say that this version is much more readable, and is still the best book to buy if you want a book on phpMyAdmin. The reviews I've read here all agree with my own assessment that phpMyAdmin is a surprise '" right when you think you know what it does, a book points out a load of stuff you didn't know it did.

He breaks it into two sections - the things that have gotten better (like the removal of some unneeded items and he inclusion of some of the more minor features) and some things that, unfortunately, have not improved (such as the increased size of the table of contents and the addition of other, too large screenshots).

0 comments voice your opinion now!
review book phpmyadmin mastering



Community Events











Don't see your event here?
Let us know!


composer series install opinion component release security overview hack code package framework facebook introduction podcast hhvm application unittest language symfony2

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework