richardw Posted January 8, 2007 Share Posted January 8, 2007 This is a simple program that will generate mysql code and forms for any given database and table. The information is read from the table schema and the connection string, INSERT, UPDATE, SELECT and DELETE statements are written. In additon, it builds two forms for inserting data and displaying data back so that content can be edited. Just copy and paste the code into a PHP page.The program based on feedback will be developed with a series of prompts so that a specific page can be written from top to bottom with the ability to select fields based on a checkbox. Try the program at:[url=http://www.readybydesign.com/data2b.php]http://www.readybydesign.com/data2b.php [/url] try any combination, but for speed you can input databse: dpw and table: roadFeedback needed. Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/ Share on other sites More sharing options...
Ninjakreborn Posted January 8, 2007 Share Posted January 8, 2007 * A little bland, atleast some styling, and a basic stylesheet would help* Getting some mysql errors when doing it (even with some of the tables and db's you show)* The output is very messy, especially the top part, if you reformatted it, (show the column name first), then the rest of the data, with some form of organization, split up with horizontal rules also, or something to visually differentiate the informationOther than that, I like it. Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-155799 Share on other sites More sharing options...
ober Posted January 8, 2007 Share Posted January 8, 2007 [quote]$HTTP_GET_VARS[/quote]Eww.. talk about old code. You should update this and soon. Also, your code is kind of inefficent and you don't do much if any error handling. Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-155814 Share on other sites More sharing options...
richardw Posted January 8, 2007 Author Share Posted January 8, 2007 You are correct. The initial page is not well formatted, but my idea was to test wether it was doable. I plan on breaking it into compents with more options and styling with prompts. I have been testing the code as I build new applications, with success. But I welcome feedback where errors may be found.Based on feedback above, I plan on developing this into a user friendly tool with more options. The present output was so that I could test the internal routines. I will look to incorporate more error trapping, and yes I will look to use newer code or maybe provide an option for different versions of mysql / php and populate the code respectively.Here is one application built from db: dpw and table: road (Well the input and edit pages are in a pw directory, but they allow for the output that can be seen)[url=http://www.providenceri.com/publicworks/road_closings.php]http://www.providenceri.com/publicworks/road_closings.php[/url]Thanks for the constructive comments. I hope to be able to post the code as GNU open source within a month after the formattiing and prompts are programmed. Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-155819 Share on other sites More sharing options...
Philip Posted January 8, 2007 Share Posted January 8, 2007 http://www.providenceri.com/publicworks/road_closings.php <- messy (I'm not sure if it is supposed to look like that... or if it is my browser)If I enter in something wrong (for the table)[code]Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/mywebf5/public_html/readybydesign/data2b.php on line 89 Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/mywebf5/public_html/readybydesign/data2b.php on line 440[/code]If I enter in something wrong for the database:[code]Unable to connect to the database[/code]You're going to want to have it check to see if there is a database and a table, before trying to display information off of them. Agreed with businessman332211, you need some style (but you discussed that ;)) And for this code:[code]$sql ="SELECT * FROM road WHERE id = ". $HTTP_GET_VARS["id"];$result = mysql_query($sql);$row = mysql_fetch_array($result);<?php echo $row[""]?><?php echo $row["id"] ?><?php echo $row["date"] ?><?php echo $row["street_nmbr"] ?><?php echo $row["street"] ?><?php echo $row["description"] ?><?php echo $row["street_nmbr1"] ?><?php echo $row["cross_street1"] ?><?php echo $row["street_nmbr2"] ?><?php echo $row["cross_street2"] ?><?php echo $row["event_name"] ?><?php echo $row["impact"] ?><?php echo $row["restriction"] ?><?php echo $row["reason"] ?><?php echo $row["begindate"] ?><?php echo $row["enddate"] ?><?php echo $row["startHour"] ?><?php echo $row["startMinutes"] ?><?php echo $row["startAP"] ?><?php echo $row["endHour"] ?><?php echo $row["endMinutes"] ?><?php echo $row["endAP"] ?><?php echo $row["zip"] ?><?php echo $row["term"] ?><?php echo $row["visible"] ?><?php echo $row["type"] ?><form enctype="multipart/form-data" name="road" method="post" action="<?php echo $PHP_SELF; ?>"><input name="id" size="6" type="int" value=""><br><input name="date" size="23" type="timestamp" value=""><br><input name="street_nmbr" size="7" type="blob" value=""><br><input name="street" size="24" type="blob" value=""><br><input name="description" size="99" type="blob" value=""><br><input name="street_nmbr1" size="4" type="string" value=""><br><input name="cross_street1" size="19" type="blob" value=""><br><input name="street_nmbr2" size="11" type="string" value=""><br><input name="cross_street2" size="19" type="blob" value=""><br><input name="event_name" size="17" type="blob" value=""><br><input name="impact" size="29" type="blob" value=""><br><input name="restriction" size="32" type="blob" value=""><br><input name="reason" size="123" type="blob" value=""><br><input name="begindate" size="23" type="timestamp" value=""><br><input name="enddate" size="23" type="timestamp" value=""><br><input name="startHour" size="6" type="blob" value=""><br><input name="startMinutes" size="6" type="string" value=""><br><input name="startAP" size="6" type="string" value=""><br><input name="endHour" size="6" type="blob" value=""><br><input name="endMinutes" size="6" type="string" value=""><br><input name="endAP" size="6" type="string" value=""><br><input name="zip" size="4" type="blob" value=""><br><input name="term" size="5" type="string" value=""><br><input name="visible" size="5" type="string" value=""><br><input name="type" size="14" type="blob" value=""><br><input type="Submit" name="submit" value="Submit"> <input type="reset" name="Clear" value="Clear"></form><?php echo $row["id"] ?><?php echo $row["date"] ?><?php echo $row["street_nmbr"] ?><?php echo $row["street"] ?><?php echo $row["description"] ?><?php echo $row["street_nmbr1"] ?><?php echo $row["cross_street1"] ?><?php echo $row["street_nmbr2"] ?><?php echo $row["cross_street2"] ?><?php echo $row["event_name"] ?><?php echo $row["impact"] ?><?php echo $row["restriction"] ?><?php echo $row["reason"] ?><?php echo $row["begindate"] ?><?php echo $row["enddate"] ?><?php echo $row["startHour"] ?><?php echo $row["startMinutes"] ?><?php echo $row["startAP"] ?><?php echo $row["endHour"] ?><?php echo $row["endMinutes"] ?><?php echo $row["endAP"] ?><?php echo $row["zip"] ?><?php echo $row["term"] ?><?php echo $row["visible"] ?><?php echo $row["type"] ?><form enctype="multipart/form-data" name="road" method="post" action="<?php echo $PHP_SELF;?>"><input name="id" size="6" type="int" value="<?php echo $row["id"] ?>"><br><input name="date" size="23" type="timestamp" value="<?php echo $row["date"] ?>"><br><input name="street_nmbr" size="7" type="blob" value="<?php echo $row["street_nmbr"] ?>"><br><input name="street" size="24" type="blob" value="<?php echo $row["street"] ?>"><br><input name="description" size="99" type="blob" value="<?php echo $row["description"] ?>"><br><input name="street_nmbr1" size="4" type="string" value="<?php echo $row["street_nmbr1"] ?>"><br><input name="cross_street1" size="19" type="blob" value="<?php echo $row["cross_street1"] ?>"><br><input name="street_nmbr2" size="11" type="string" value="<?php echo $row["street_nmbr2"] ?>"><br><input name="cross_street2" size="19" type="blob" value="<?php echo $row["cross_street2"] ?>"><br><input name="event_name" size="17" type="blob" value="<?php echo $row["event_name"] ?>"><br><input name="impact" size="29" type="blob" value="<?php echo $row["impact"] ?>"><br><input name="restriction" size="32" type="blob" value="<?php echo $row["restriction"] ?>"><br><input name="reason" size="123" type="blob" value="<?php echo $row["reason"] ?>"><br><input name="begindate" size="23" type="timestamp" value="<?php echo $row["begindate"] ?>"><br><input name="enddate" size="23" type="timestamp" value="<?php echo $row["enddate"] ?>"><br><input name="startHour" size="6" type="blob" value="<?php echo $row["startHour"] ?>"><br><input name="startMinutes" size="6" type="string" value="<?php echo $row["startMinutes"] ?>"><br><input name="startAP" size="6" type="string" value="<?php echo $row["startAP"] ?>"><br><input name="endHour" size="6" type="blob" value="<?php echo $row["endHour"] ?>"><br><input name="endMinutes" size="6" type="string" value="<?php echo $row["endMinutes"] ?>"><br><input name="endAP" size="6" type="string" value="<?php echo $row["endAP"] ?>"><br><input name="zip" size="4" type="blob" value="<?php echo $row["zip"] ?>"><br><input name="term" size="5" type="string" value="<?php echo $row["term"] ?>"><br><input name="visible" size="5" type="string" value="<?php echo $row["visible"] ?>"><br><input name="type" size="14" type="blob" value="<?php echo $row["type"] ?>"><br><input type="Submit" name="submit" value="Submit"> <input type="reset" name="Clear" value="Clear"></form> [/code]it could use a lot of cleaning up, but thats just my opinion ;) Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-156021 Share on other sites More sharing options...
emehrkay Posted January 8, 2007 Share Posted January 8, 2007 I havent played around with it that much, but i have a program that can modify header info - are these queries basic posts? Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-156047 Share on other sites More sharing options...
Philip Posted January 8, 2007 Share Posted January 8, 2007 Umm, I just noticed... why do you have your database login info in hidden fields? Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-156061 Share on other sites More sharing options...
neylitalo Posted January 9, 2007 Share Posted January 9, 2007 [quote author=KingPhilip link=topic=121498.msg500022#msg500022 date=1168292734]Umm, I just noticed... why do you have your database login info in hidden fields?[/quote]hehe... honey pot? :) Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-156242 Share on other sites More sharing options...
richardw Posted January 9, 2007 Author Share Posted January 9, 2007 [quote author=emehrkay link=topic=121498.msg500008#msg500008 date=1168289980]I havent played around with it that much, but i have a program that can modify header info - are these queries basic posts?[/quote]The forms and queries are basic at the moment. My intent is to allow the program to generate code based on selected features. I would be interested in seeing your program if it is open source as it may let me see more possibilities. Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-156655 Share on other sites More sharing options...
trecool999 Posted February 1, 2007 Share Posted February 1, 2007 Couldn't connect to database... :( Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-174859 Share on other sites More sharing options...
richardw Posted February 2, 2007 Author Share Posted February 2, 2007 I hope this will work for you,http://www.readybydesign.com/data2b.php try using just the folling db & tabledatabse: dpw and table: road Link to comment https://forums.phpfreaks.com/topic/33330-mysql-code-generator/#findComment-175375 Share on other sites More sharing options...
Recommended Posts