p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

beginning_php thread: Database - MySQL


Message #1 by Jerry Rocteur <macosx@r...> on Fri, 22 Feb 2002 23:46:35 +0100
Hi,



Does anyone have a suite of PHP/HTML programs that create a MySql dabatase,

tables and then manipulates the data ???



I'd like to get something that is already written and play with it ...



Thanks in advance,



Jerry 



Message #2 by Jacob Cohen <cohen@r...> on Fri, 22 Feb 2002 14:50:52 -0800
Hello Jerry,



> Does anyone have a suite of PHP/HTML programs that create a MySql dabatase,

> tables and then manipulates the data ???



Take a look at phpMyAdmin



-- 

Regards,

Jake                            mailto:cohen@r...



Message #3 by Jerry Rocteur <macosx@r...> on Sat, 23 Feb 2002 00:24:23 +0100
Thanks Jacob, I've got that already.



I want an application, any application that opens a DB, allows search and

manipulating data and saves it to the DB, I want to play with a ready made

application.



I'm searching the web now but so far I only see bits and pieces of

examples.. I don't want to re-invent the wheel...



> From: Jacob Cohen <cohen@r...>

> Reply-To: "beginning php" <beginning_php@p...>

> Date: Fri, 22 Feb 2002 14:50:52 -0800

> To: "beginning php" <beginning_php@p...>

> Subject: [beginning_php] Re: Database - MySQL

> 

> Hello Jerry,

> 

>> Does anyone have a suite of PHP/HTML programs that create a MySql dabatase,

>> tables and then manipulates the data ???

> 

> Take a look at phpMyAdmin

> 

> -- 

> Regards,

> Jake                            mailto:cohen@r...

> 

> 




> 



Message #4 by "Nikolai Devereaux" <yomama@u...> on Fri, 22 Feb 2002 14:59:53 -0800

look at phpMyAdmin.



It's by far the easiest tool I've ever used to interface with mysql.



http://www.phpwizard.net/projects/phpMyAdmin/index.html





> -----Original Message-----

> From: Jerry Rocteur [mailto:macosx@r...]

> Sent: Friday, February 22, 2002 2:47 PM

> To: beginning php

> Subject: [beginning_php] Database - MySQL

> 

> 

> Hi,

> 

> Does anyone have a suite of PHP/HTML programs that create a MySql 

> dabatase,

> tables and then manipulates the data ???

> 

> I'd like to get something that is already written and play with it ...

> 

> Thanks in advance,

> 

> Jerry 

> 

> 




> $subst('Email.Unsub').

Message #5 by John Lamb <J.D.Lamb@b...> on Sat, 23 Feb 2002 12:45:43 +0000
Jerry Rocteur wrote:

> 

> Hi,

> 

> Does anyone have a suite of PHP/HTML programs that create a MySql dabatase,

> tables and then manipulates the data ???

> 

> I'd like to get something that is already written and play with it ...

> 

> Thanks in advance,

> 

> Jerry



I have a small mySQL database and four or five php pages that implements

a simple address book. I can give you a copy, though it might be easier

for you to set up your own mySQL database.

JDL

Message #6 by "Nikolai Devereaux" <yomama@u...> on Sat, 23 Feb 2002 13:52:19 -0800

> Thanks Jacob, I've got that already.



Are you serious???  You have phpMyAdmin already but what?  But it doesn't

make your coffee and waffles in the morning?



phpMyAdmin is by far the easiest php based mysql database management and

interface utility I've ever seen.



You can specify any number of servers to connect to (given the correct

username/passwords, of course), and gives you one of the easiest interface

to querying, modifying, inserting, deleting, reloading, etc... of ANY mysql

database.



What exactly do you want to do that this baby can't handle?



=)



nik



> -----Original Message-----

> From: Jerry Rocteur [mailto:macosx@r...]

> Sent: Friday, February 22, 2002 3:24 PM

> To: beginning php

> Subject: [beginning_php] Re: Database - MySQL

>

>

> Thanks Jacob, I've got that already.

>

> I want an application, any application that opens a DB, allows search and

> manipulating data and saves it to the DB, I want to play with a ready made

> application.

>

> I'm searching the web now but so far I only see bits and pieces of

> examples.. I don't want to re-invent the wheel...

>

> > From: Jacob Cohen <cohen@r...>

> > Reply-To: "beginning php" <beginning_php@p...>

> > Date: Fri, 22 Feb 2002 14:50:52 -0800

> > To: "beginning php" <beginning_php@p...>

> > Subject: [beginning_php] Re: Database - MySQL

> >

> > Hello Jerry,

> >

> >> Does anyone have a suite of PHP/HTML programs that create a

> MySql dabatase,

> >> tables and then manipulates the data ???

> >

> > Take a look at phpMyAdmin

> >

> > --

> > Regards,

> > Jake                            mailto:cohen@r...

> >

> >




> $subst('Email.Unsub').

> >

>

>




> $subst('Email.Unsub').



Message #7 by "Lawrence" <lkrubner@g...> on Sat, 23 Feb 2002 17:47:46 -0500
From: "John Lamb" <J.D.Lamb@b...>

> Jerry Rocteur wrote:

> > Does anyone have a suite of PHP/HTML programs that create a MySql dabatase,

> > tables and then manipulates the data ???



I wrote a simple weblog that creates its own database tables, then lets you input entries and output

them to a public weblog. Pretty straightforward. I have ambitions for this weblog, but for now it is

quite simple. I would love some feedback on it, especially if you find any bugs. You can download it

from this page:



http://www.krubner.com/lk_frontPage/logRhythmInfo.htm









Message #8 by "Lawrence" <lkrubner@g...> on Sat, 23 Feb 2002 17:55:13 -0500
From: "Nikolai Devereaux" <yomama@u...>

> Are you serious???  You have phpMyAdmin already but what?  But it doesn't

> make your coffee and waffles in the morning?>

> phpMyAdmin is by far the easiest php based mysql database management and

> interface utility I've ever seen



Calm down, Nik. I had the impression he wanted to play around with an application that just happened

to use a database. He didn't want to play around with a database. Maybe he wants to see someone

else's code for interacting with a database. That's different from wanting to create a database from

scratch.



I just pointed him at an application I wrote, which is very simple. If he'd like to see some really

serious database intensive software, I'd like to suggest that he look at www.phorum.org . Download

and look at the source code for Phorum. It gives you a real sense of how much you can do with PHP

and MySQL.



--lawrence krubner

















Message #9 by Jacob Cohen <cohen@r...> on Sat, 23 Feb 2002 15:45:42 -0800
Hello Lawrence,



lkrubner@g... wrote:

  L> From: "Nikolai Devereaux" <yomama@u...>

>> Are you serious???  You have phpMyAdmin already but what?  But it doesn't

>> make your coffee and waffles in the morning?>

>> phpMyAdmin is by far the easiest php based mysql database management and

>> interface utility I've ever seen



L> Calm down, Nik. I had the impression he wanted to play around with an application that just happened

L> to use a database. He didn't want to play around with a database. Maybe he wants to see someone

L> else's code for interacting with a database. That's different from wanting to create a database from

L> scratch.



There seems to be a good deal of confusion on this list as to what

phpMyAdmin actually is.



It is an application, written in PHP, that interacts with a MySQL

database. It is not itself a database. Just about every possible way

to interact with a database using PHP is exhibited by the code.



It provides forms for adding, modifying, and deleting data from a

MySQL database. The fact that you can create, modify, add tables, drop

tables, alter them, create indexes, and other features does not

disqualify phpMyAdmin from being a PHP application. I think it

reinforces the fact that phpMyAdmin is one of the most complete

examples of using PHP to interact with a MySQL database that you will

find. Yes, more complete than phorum.org, imho.



If, however, the OP wants to find home-brew code exhibiting a subset

of what is possible, there are plenty of examples on PHP.net or

freshmeat's PHP section (http://freshmeat.net/browse/183/).



-- 

Regards,

Jake                          mailto:cohen@r...



Message #10 by "Nikolai Devereaux" <yomama@u...> on Sun, 24 Feb 2002 18:50:20 -0800

> Calm down, Nik. I had the impression he wanted to play around 

> with an application that just happened

> to use a database. He didn't want to play around with a database. 

> Maybe he wants to see someone

> else's code for interacting with a database. That's different 

> from wanting to create a database from

> scratch.

> 

> I just pointed him at an application I wrote, which is very 

> simple. If he'd like to see some really

> serious database intensive software, I'd like to suggest that he 

> look at www.phorum.org . Download

> and look at the source code for Phorum. It gives you a real sense 

> of how much you can do with PHP

> and MySQL.





Nevermind, sorry.  I feel completely misunderstood.



Nik

Message #11 by "Nikolai Devereaux" <yomama@u...> on Sun, 24 Feb 2002 19:00:35 -0800

Thanks, Jake.



My hero!



Anyway, if you want other script examples, you can find a ton of them at 



http://www.hotscripts.com/PHP/

http://www.phpbuilder.com/

http://phpclasses.uppderdesign.com/

http://www.php-scripts.com/



nik





> -----Original Message-----

> From: Jacob Cohen [mailto:cohen@r...]

> Sent: Saturday, February 23, 2002 3:46 PM

> To: beginning php

> Subject: [beginning_php] Re: Database - MySQL

> 

> 

> Hello Lawrence,

> 

> lkrubner@g... wrote:

>   L> From: "Nikolai Devereaux" <yomama@u...>

> >> Are you serious???  You have phpMyAdmin already but what?  But 

> it doesn't

> >> make your coffee and waffles in the morning?>

> >> phpMyAdmin is by far the easiest php based mysql database 

> management and

> >> interface utility I've ever seen

> 

> L> Calm down, Nik. I had the impression he wanted to play around 

> with an application that just happened

> L> to use a database. He didn't want to play around with a 

> database. Maybe he wants to see someone

> L> else's code for interacting with a database. That's different 

> from wanting to create a database from

> L> scratch.

> 

> There seems to be a good deal of confusion on this list as to what

> phpMyAdmin actually is.

> 

> It is an application, written in PHP, that interacts with a MySQL

> database. It is not itself a database. Just about every possible way

> to interact with a database using PHP is exhibited by the code.

> 

> It provides forms for adding, modifying, and deleting data from a

> MySQL database. The fact that you can create, modify, add tables, drop

> tables, alter them, create indexes, and other features does not

> disqualify phpMyAdmin from being a PHP application. I think it

> reinforces the fact that phpMyAdmin is one of the most complete

> examples of using PHP to interact with a MySQL database that you will

> find. Yes, more complete than phorum.org, imho.

> 

> If, however, the OP wants to find home-brew code exhibiting a subset

> of what is possible, there are plenty of examples on PHP.net or

> freshmeat's PHP section (http://freshmeat.net/browse/183/).

> 

> -- 

> Regards,

> Jake                          mailto:cohen@r...

> 

> 




> $subst('Email.Unsub').


  Return to Index