Solved

php code generator

Posted on 2011-09-09
6
257 Views
Last Modified: 2012-05-12
Hello experts,
It is the Nth time I have to write versyy similar code to update/edit/remove records from tables using php/phpmyadmin/mysql.

My tables has some 1toMany relations and manyToMany relations
(like users, books , userbooks tables)

Is there a generator for these kind of things ? How could I speed up this "boring" and "repetitive" task ?

reagrds
0
Comment
Question by:yarekGmail
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Expert Comment

by:nanharbison
ID: 36514651
You can do this in PHPMyAdmin, which then provides the code that you can copy and paste if you need to use it for multiple records.
0
 
LVL 9

Expert Comment

by:rinfo
ID: 36515992
Have you considered writting a databasehelper class used in say dotnet.
There helper basically are class that returns say a datatable, or datareader when parameters are set for query ,params, connection.
Something like  datatable dt = GetDatatable(qry);
Getdatatable in defined in a class which uses default connection and return a datatable.
The above example can be extended to include storeproc, params etc.
Think about this if you are a good php programmer i am sure you can write such a class in php after all this iis how config.php is prevelent in php
0
 
LVL 17

Expert Comment

by:nanharbison
ID: 36516009
Just thought of this, find a database class where you just plug in a few things, like this one:
http://www.micahcarrick.com/php-mysql-database-class.html
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 17

Accepted Solution

by:
nanharbison earned 500 total points
ID: 36516022
Oh wait, that is a PHP4 class, here is the newer version:
http://www.micahcarrick.com/php5-mysql-database-class.html
0
 

Expert Comment

by:ctrlclick
ID: 36516117
Sounds like you should be using a framework like cakephp or yii.
Personally I use cakephp which has a very handy shell script called BAKE for baking all my CRUD functionality. The nice thing about cakephp as opposed to a code generator like phpmaker is that the code is very easy to work with after it has been generated, especially if you take the time to really learn the framework.
0
 
LVL 110

Expert Comment

by:Ray Paseur
ID: 36519685
Perhaps you could use some kind of "pre-canned" functions.  I usually write a "row_getter" and a "row_putter" for my tables.  These are kept in a common script and I can call the methods from any place in my programming that makes sense.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question