DevShed: Working with phpMyAdmin (Part 2)
Grok Headline matches for DevShed: Working with phpMyAdmin (Part 2)
DevShed: Doing More With phpMyAdmin
(Part 1)
DevShed: Doing More With phpMyAdmin
(Part 1)
10/28/2003 11:07 PMIf you've ever had a shared hosting environment and had to deal with
the frustration of not being able to access the command line, then you
know the joy that
phpMyAdmin
can bring. Now,
DevShed is
looking to share the love with thier latest posting.
Doing More With phpMyAdmin (Part 1)
Doing More With phpMyAdmin (Part 1)
10/28/2003 11:06 PM
You might not know this, but you can do a lot more with
phpMyAdmin than just create tables and insert records. This first in a
two-part series takes a look at some of the other features hidden
under the hood of this popular PHP application, explaining how it can
be used to secure access to the MySQL server, manage multiple servers,
manipulate user privileges, view reports on server activity, and
export MySQL data into different formats.
Doing More with phpMyAdmin (Part 2)
Doing More with phpMyAdmin (Part 2)
12/08/2003 11:46 AM
In the first segment of this two-part tutorial, I gave you a
quick overview of some of the interesting new features available in
phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin
to define relationships between tables, maintain a log of
commonly-used queries and create entity-relationship diagrams.
DevShed on Development: Part 4
DevShed on Development: Part 4
09/26/2002 08:39 AMDevShed: Getting Started with Apache 2.0
(Part 3)
DevShed: Getting Started with Apache 2.0
(Part 3)
03/29/2005 08:51 AMDevShed.com has a new article
posted today that's the third part of their
Getting Started with Apache 2.0 series.
DevShed: Building a Template Parser
(Part 2)
DevShed: Building a Template Parser
(Part 2)
03/30/2005 09:12 AMWith a follow-up to their
previous templating article, DevShed has posted
Part 2 of the "Building a Template Parser Class
with PHP" series of articles.
DevShed: Building a Template Parser
(Part 1)
DevShed: Building a Template Parser
(Part 1)
03/23/2005 10:33 AMWith all of the template systems out there for PHP these days, it may
seem like none of them are exactly what you're looking for. If that's
the case, you might want to consider working up a custom set of
classes to parse your own templates, and
this new article from DevShed can help you get
started.
Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 2
Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 2
09/16/2002 01:36 AMThis two-part tutorial covers nearly every detail of one writer's
quest to install and configure a Web server, server-side scripting
language, database, and data administration application on Windows
2000. Part 2 examines ways to install and configure MySQL and
phpMyAdmin on the operating system.
Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 1
Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 1
09/16/2002 01:36 AMThis two-part tutorial covers nearly every detail of one writer's
quest to install and configure a Web server, server-side scripting
language, database, and data administration application on Windows
2000. Part 1 focuses on how to get Apache 1.3.26 with Mod_SSL 2.8.10
and PHP 4.2.2 up and running.
phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net
phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net
02/06/2005 03:07 AMphpMyAdmin - Mysql DB administration tool - www.phpmyadmin.net ..
released a new version .. phpMyAdmin 2.3.2 .. phpMyAdmin ..
2.4.0-rc2
phpmyadmin.net
track this
site | 3 links
Working with Permissions in PHP, Part 1
Working with Permissions in PHP, Part 1
02/07/2003 12:42 PM
The last series of PHP Foundations explained the basics of files
and directories. If you're making your files public, though, you need
some security. PHP follows the Unix model of user, group, and world
permissions. John Coggeshall explains the Unix permission model.
Working with Files in PHP, Part 3
Working with Files in PHP, Part 3
01/09/2003 08:37 PM
You've got files down. You can create, delete, rewind, and append
with abandon. But where do you put them? In Part 3 of "Working with
Files in PHP," John Coggeshall explains how to work with directories.
Working with Files in PHP, Part Two
Working with Files in PHP, Part Two
12/12/2002 07:01 PM
The Web was once a purely-text medium, but no longer. Now it's
spiced with images, movies, and sounds. What's a PHP programmer to do?
With the return of John Coggeshall and in the second part of his
series on working with files in PHP, he covers binary files.
Working with Permissions in PHP, Part 2
Working with Permissions in PHP, Part 2
02/21/2003 02:40 PM
Having explained the Unix security model in his last column, John
Coggeshall explains the permissions functions in PHP and how to use
them.
Working with Forms in PHP, Part 1
Working with Forms in PHP, Part 1
03/13/2003 08:38 PM
PHP is handy for templating and displaying dynamic data, but
you're missing its full power until you handle user data. John
Coggeshall explains how PHP 4.3 handles form submissions securely and
sanely.
ONLamp.com: Working with Permissions in
PHP, Part 2
ONLamp.com: Working with Permissions in
PHP, Part 2
02/25/2003 11:41 PM"In today's column we return to PHP to show you how to apply what you
learned last time; again, this column applies only to those who work
with PHP in an environment that supports Unix-like permission..."
Mac 911 Webl0g: Working Vacation Part 1
Mac 911 Webl0g: Working Vacation Part 1
04/21/2004 11:38 AMChristopher Breen: "Once I had the addresses in Entourage, I launched
Apple's Address Book and selected Import Addresses from Address Book's
AppleScript menu. In the resulting window, I selected Entourage and
clicked OK. In next to no time, the addresses were in Address Book,
ready for use by Mail."
Working with CSS Background Images –
Part 1: An Overview
Working with CSS Background Images –
Part 1: An Overview
03/14/2005 06:17 PMSpice up your page designs with CSS-based background images.
Working With Contractors Part 5 - Legal
Agreements
Working With Contractors Part 5 - Legal
Agreements
12/08/2003 09:45 PMWebmasterBase Dec 8 2003 7:45PM ET
Working With Contractors Part 2 -
Qualification and Trial
Working With Contractors Part 2 -
Qualification and Trial
11/11/2003 07:59 PMWebmasterBase Nov 11 2003 5:38PM ET
Working With Contractors Part 1 - Find
Candidates
Working With Contractors Part 1 - Find
Candidates
11/10/2003 11:19 PMWebmasterBase Nov 10 2003 2:48AM ET
Working With Contractors Part 6 - Work
with Offshore Contractors
Working With Contractors Part 6 - Work
with Offshore Contractors
12/21/2003 10:40 PMWebmasterBase Dec 21 2003 9:32PM ET
Working with CSS Background Images -
Part 2: Positioning Images
Working with CSS Background Images -
Part 2: Positioning Images
04/04/2005 06:43 PMUse keyword pairs or measurement values to precisely position
background images on your pages.
Working With Contractors Part 3 -
Managing Contractors
Working With Contractors Part 3 -
Managing Contractors
11/17/2003 12:59 AMWebmasterBase Nov 16 2003 11:32PM ET
Working with CSS Background Images-Part
3: Creating Background Images with a
Drop Shadow
Working with CSS Background Images-Part
3: Creating Background Images with a
Drop Shadow
04/18/2005 07:15 PMCreate cool background images in Fireworks and put them in your pages
with Dreamweaver.
The W3C RDF Data Access Working Group
has published the first public working
draft of SPARQL Variable Binding
The W3C RDF Data Access Working Group
has published the first public working
draft of SPARQL Variable Binding
01/02/2005 11:31 AMxmlhack Jan 2 2005 1:45PM GMT
Quality Assurance Working Group Updates
Three Working Drafts
Quality Assurance Working Group Updates
Three Working Drafts
11/08/2002 08:17 PM8 November 2002: The Quality Assurance (QA) Working Group has updated
three Working Drafts in its seven-part QA Framework: the Introduction,
Process and Operational Guidelines; and Specification Guidelines.
Learn more about the QA Activity and the roadmap for ensuring that W3C
technologies are well implemented. (News archive)
phpMyAdmin 2.5.5
phpMyAdmin 2.5.5
12/28/2003 04:20 PMHandles the basic adminstration of MySQL over the WWW
phpMyAdmin 2.5.7
phpMyAdmin 2.5.7
06/09/2004 09:16 AMHandles the basic adminstration of MySQL over the WWW
phpMyAdmin
phpMyAdmin
12/07/2003 04:08 PMphpMyAdmin 2.5.5-rc1 is released!
phpMyAdmin 2.3.2
phpMyAdmin 2.3.2
10/31/2002 01:15 AMAfter over a year of development, the new version of phpMyAdmin (which
allows you to manage your mysql databases from a web server)was
released this month.
I just downloaded it today. After 10 minutes of testing, my opinion is
that it is a step backward. In previous versions, i could enter SQL
from nearly every important screen in phpMyAdmin. Now I have to click
on a database, then select the SQL tab. Secondly, they have now
highlighted the DROP command in red.
After selecting a couple of test tables that I had just created, I
clicked on DROP to remove the test tables, only to find to my horror
that it was DROP DATABASE!
This just reinforces my opinion that good user interface designers are
too well paid to contribute to Open Source projects :-)
"zeldman.lod"
phpMyAdmin 2.5.5-rc1 (Development)
phpMyAdmin 2.5.5-rc1 (Development)
12/08/2003 04:42 PMHandles the basic adminstration of MySQL over the WWW
phpMyAdmin 2.6.0-rc2 (Development)
phpMyAdmin 2.6.0-rc2 (Development)
09/06/2004 11:14 AMHandles the basic adminstration of MySQL over the WWW
Web Services (XML-RPC) and phpMyAdmin
Web Services (XML-RPC) and phpMyAdmin
07/17/2002 09:05 AMphpMyAdmin 2.4.0-rc2 released
phpMyAdmin 2.4.0-rc2 released
02/17/2003 12:15 PMphpMyAdmin is a tool written in PHP intended to handle the
administration of MySQL over the WWW. Currently it can create and drop
databases, create/drop/alter tables, delete/edit/add fields, execute
any SQL statement, manage keys on fields. The test cycle is going
well, rc2 contains other fixes, and more polishing of the new
privileges and database management pages.
phpMyAdmin 2.3.0 is released
phpMyAdmin 2.3.0 is released
08/12/2002 01:39 AMYou are welcome to use this new stable version, with lots of new
features. Details available at http://phpmyadmin.net.
PHPMyAdmin Book
PHPMyAdmin Book
05/20/2004 02:26 PMPackt Book
Store :: Mastering phpMyAdmin for Effective MySQL Management:
We've talked about Packt Publishing befor
e, but now it looks like they're really hitting high gear. Here's
a book about PHPMyAdmin, which I
never thought we'd see but which is badly needed. You may think you
know PHPMyAdmin, but if you look under the hood, there's functionality
there that I bet you never knew existed.
They also have a book
about eZ Publish, which I've worked with
and enjoyed very much.
Click here to comment on this entry
Mastering phpMyAdmin
Mastering phpMyAdmin
06/03/2004 07:01 AM
phpMyAdmin
is usually installed quickly, out of acute necessity. You need to do
something with your database, and you can't do it via telnet or SSH or
anything else, so you download the latest version, FTP it up, and away
you go. More often than not, the install is forgotten about as soon
as your need is over.
The downside of this is that you're not getting nearly the value
you should out of a phpMyAdmin install. Most people work with
phpMyAdmin superficially and in very narrow usage corridors —
like kids walking barefoot on a painted line through a very large
parking lot. There's so much about the app that you don't know.
Enter this book: "Mastering
phpMyAdmin for Effective MySQL Management." This is the first
book I know of solely on phpMyAdmin (though a lot of MySQL books cover
it briefly in an appendix or something). It was released by Packt Publishing a few weeks
ago.
It's a departure from a lot of tech books in that (1) it's short
and sweet (just under 200 pages — not nearly the 600-page
monolith some of these things become), and (2) it seems
more...conversational. Concepts are explained in plain English. I
normally hate that cliche, but it fits here. I got a sense of simply
having a casual conversation with a fellow geek.
I read it over the course of a week, putting in a chapter or two
each night. I learned something new in every chapter, and I'd
implement them in my phpMyAdmin install right after reading the
chapter. By the end of the book, I'm left with a superb phpMyAdmin
install that does a thousand times more than I've ever accomplished
with the app before.
There's a lot of phpMyAdmin functionality under the hood that
you've likely never seen. For instance, you can set it up to enforce
relational integrity in your database. This is just good database
design, but it also enriches the interface considerably. Foreign key
fields now become drop-down lists to the foreign table with a
selection of entries. You can print a PDF summary document with
descriptions of all tables and columns and an entity relationship
diagram showing field relationships. Bet you haven't seen that trick
before.
I suddenly have a sense of liberation with phpMyAdmin. We all hate
writing admin interfaces, especially for one-off apps we do in a
hurry. Thankfully, phpMyAdmin can support an enormous amount of
administration chores in an interface not nearly as utilitarian as the
default one you get on install. It won't work for administering the
data of every app you right, but I bet it will handle a lot of
them.
I can now see writing apps and doing things that I stayed away from
before just because I didn't want to write all the data entry and
database admin scripts that easily dominate the work required to put
these things together. Instead, I can concentrate on the fun of the
front-end pages, while phpMyAdmin sucks up all the back-end work.
The book also includes some good information about PHP and MySQL in
general. On page 86, in the chapter on importing data, there's a
solid little discussion about PHP file upload and execution limits
that trumps anything I've read before. I'm a better developer for
having read these four paragraphs about the "upload_max_filesize,"
"memory_limit," and "post_max_filesize" parameters.
As for MySQL, did you know about InnoDB tables? This is a table
format that builds referential integrity into MySQL — something
the database has been missing for so long. I'll admit to being
utterly ignorant about this feature until this point.
There's a chapter at the end of the book about MIME-based
transformations that summarizes the general level of apathy about this
app. I can't believe I haven't run across a discussion about this
feature before —
You may have known on the periphery that you could store files
directly into a MySQL database using a BLOB column. But did you know
that phpMyAdmin will support this with a file upload field in the
interface, so your users can upload files directly? Or that you can
sent a MIME Transformation on that field to display a thumbnailed view
of stored images in the row when browsing the database? And that you
can link that thumbnail to the full-size version or the image, pulled
directly from the field? I'll bet the percentage of phpMyAdmin users
who know that trick is in the single digits.
So, good book. If you find yourself writing a lot of throwaway
admin interfaces and hating every minute of it, the $30 cover price
for this text is probably looking mighty attractive right
now.
Click here to comment on this entry
phpMyAdmin 2.5.4 is released!
phpMyAdmin 2.5.4 is released!
10/29/2003 12:10 AMThe development team is proud to announce the availability of this
version, with over 12 improvements and 20 bug fixes. phpMyAdmin is a
tool written in PHP intended to handle the administration of MySQL
over the WWW. Currently it can create and drop databases,
create/drop/alter tables, delete/edit/add fields, execute any SQL
statement, manage keys on fields.
Grok Description matches for DevShed: Working with phpMyAdmin (Part 2)
GrokA matches for DevShed: Working with phpMyAdmin (Part 2)
DevShed: Working with phpMyAdmin (Part 2)
