473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

CRUD tool to manage a single table?

Hello

A friend of mine asked me to whip a way for him to manage a
single table, so I figured PHP + MySQL will do the job.

I need the usual:
- create/modify/delete a record through a form. Some items are
multiple-choice like Country, etc.
- list/delete records from a list. The list must be sortable through
some of the columns (ASC, DESC)

This is so common that I'm sure there some ready-to-use solutions.
What would your recommended that is very light and easy to use (ie. no
portal, etc.)

Thank you.
Jan 28 '08 #1
9 2811
On Mon, 28 Jan 2008 16:56:55 -0800 (PST), Kailash Nadh
<ka**********@gmail.comwrote:
(snip)

Thanks guys, but

1. considering that CRUD is the bread-and-butter of computer
programming, isn't there a couple of major tools to do this for PHP?
It seems like no tool really gained traction. How come?

2. this is to write an application, so a database manager like
PhpMySQL or MySQL Admin won't do. I really need some tool to handle
this within the application

For instance, I've seen those:

http://p4a.crealabsfoundation.org/
http://codeigniter.com
http://www.fusebox.org
http://www.phpobjectgenerator.com/plog/
http://www.crudphp.com/
http://www.phpulse.com/
http://propel.phpdb.org/
http://www.qcodo.com
http://cakephp.org/

Thanks.
Jan 29 '08 #2
Gilles Ganault wrote:
On Mon, 28 Jan 2008 16:56:55 -0800 (PST), Kailash Nadh
<ka**********@gmail.comwrote:
(snip)

Thanks guys, but

1. considering that CRUD is the bread-and-butter of computer
programming, isn't there a couple of major tools to do this for PHP?
It seems like no tool really gained traction. How come?
It is useful for accessing databases, but I wouldn't call it the
"bread-and-butter" of computer programming.
2. this is to write an application, so a database manager like
PhpMySQL or MySQL Admin won't do. I really need some tool to handle
this within the application

For instance, I've seen those:

http://p4a.crealabsfoundation.org/
http://codeigniter.com
http://www.fusebox.org
http://www.phpobjectgenerator.com/plog/
http://www.crudphp.com/
http://www.phpulse.com/
http://propel.phpdb.org/
http://www.qcodo.com
http://cakephp.org/

Thanks.
So write the code to do it. It would take less time to do that than
you've spent doing all of your searches. It's really a small job.

And since a general purpose application won't work, you need something
specific, anyway.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 29 '08 #3
On Mon, 28 Jan 2008 21:19:03 -0500, Jerry Stuckle
<js*******@attglobal.netwrote:
>It is useful for accessing databases, but I wouldn't call it the
"bread-and-butter" of computer programming.
I mean that probably a good 80% of programming jobs, especially LAMP
apps, revolve around creating, reading, updating records, so I
expected a couple of tools to have become standard.

Do PHP developpers all rewrite their eg. MySQL routines when they need
to handle DB tasks?
>And since a general purpose application won't work, you need something
specific, anyway.
But precisely, this need comes up often, so it was the opportunity to
see what's available instead of copy/pasting the same type of code
again and again.
Jan 29 '08 #4
On Tue, 29 Jan 2008 01:23:45 -0200, Manuel Lemos <ml****@acm.org>
wrote:
>I use Metastorage. This is not exactly a framework but rather a code
generation tool.
Thanks for the pointer. I'll take a look.
Jan 29 '08 #5
On Mon, 28 Jan 2008 22:03:51 -0500, Jerry Stuckle
<js*******@attglobal.netwrote:
>I find it faster to write from scratch than try to modify something else
to make it work.
But productivity is pathetic compared to the tools we have in VB and
Delphi :-/
Jan 29 '08 #6
Gilles Ganault wrote:
On Mon, 28 Jan 2008 22:03:51 -0500, Jerry Stuckle
<js*******@attglobal.netwrote:
>I find it faster to write from scratch than try to modify something else
to make it work.

But productivity is pathetic compared to the tools we have in VB and
Delphi :-/
It's all what you're used to, I guess. I find it faster to code in PHP.
But then I don't use any code-writing tools for web work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 29 '08 #7
On Tue, 29 Jan 2008 02:14:20 -0200, Manuel Lemos <ml****@acm.org>
wrote:
>You can use Delphi for PHP. Same IDE philosophy. I have reviewed it last
year:
Did you like it? Is it worth it, or just some 1.0 that Borland will
kill?
Jan 29 '08 #8
On Tue, 29 Jan 2008 10:35:54 -0200, Manuel Lemos <ml****@acm.org>
wrote:
>Delphi for PHP is not very useful to me because it is only available for
Windows and I do not use Windows at all, but it may be a good
productivity tool for developers that use Windows on their desktop
machines to write PHP applications.
Thanks for the feedback. I'll download a trial version and see what
it's like.
Jan 29 '08 #9
Here's something I wrote a while ago:
http://sourceforge.net/search/?type_...1&words=irving

It's a generic CRUD processor, driven by the MySQL definition of the
table.

AS
Feb 4 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Damir Wilder | last post by:
Hello! Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a full table backup? The RESTORE DB command doesn't have this functionality - at least not according to the DB2...
5
by: sgdbprog1 | last post by:
Please can someone help me with the following question. Using mainframe db2 ie on MVS OS/390 for a select against a single table will db2 use mutiple indexes? ex: select * from table1 where...
0
by: rayone | last post by:
Hi folks. I need advice. 2 options, which do you think is the better option to display/retrieve/report on the data. Keep in mind reporting (Crystal), SQL Performance, VB Code, usability,...
4
by: PercyPercy | last post by:
For some reason I can't write the proper query to get a simple total from a single table. Here is the basic table design: Transaction ID___Product ID___ Transaction Date____Transaction Quantity...
13
by: Kosmos | last post by:
I've got an access table that I need to be secured. It will be on a fileshare that only people that can see the information will be able to access, I simply want to put a password on editing...
0
by: Serman D. | last post by:
Hi, I can't understand why mysql allows me to grant lock tables to all tables in a particular database, while it fails to accept the same command applied to a single table only. I've tested on...
1
by: sqldba20 | last post by:
Folks: I need help with a script. I have 4 tables with AsOfDate, Country and FactorInt columns. In each table AsOfdate and Country are the same for that date but the FACTORINT column varies. I...
2
by: mndprasad | last post by:
Hi i need to give two timestamp datatype in a single table of sql server 2005 DB..but it is showing error that it is not possible..pls anyone help me... my table:: create table { intime...
5
by: MandarkDC | last post by:
I am a total novice at access, who wants to move his inventory from Excel to Access, and add some functionality. One question that I haven't really seen answered in the general introductions to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.