|
 |
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').
|
 |