iplaywithfire

Agreed. My next implementation is small - I guess I didn't have a good way of explaining. If you look at it, you will see there is a submit button. I just need help getting the submit button working. Maybe the script to echo "hey it works!" once the button is pushed. I can't seem to get the submit button assigned to the form. I'm getting the error: Notice: Undefined index: submit in /Applications/MAMP/frameworks/SAFE/SAFE.php on line 123 Now I know 'submit' isn't the index to use - rather it should be 'safe' or 'at-risk', etc... I don't know why I have 'submit' in this code. If I can get the submit button to work with the dynamically created form, I'll be happy. Then I can move on to adding the content from each row into the database. ====== And I appreciate your willingness to vouch for my files -- that sounds wrong.

For those of you who don't like to read long posts, I'm sorry. But, I think it would be a disservice to not include as many details as possible - so you can see the broad scope of the project (what I'm trying to achieve) and to lay groundwork for my current problem. And, to those who don't like to download attachments - again I'm sorry. But, I can assure you that I'm not uploading anything harmful. I'm only doing it to provide all of my source code so that others can help me and/or learn from it. If preferred, I can post all of the source code too - if asked. =======OVERVIEW of the scope of the project======= I am a Safety Representative within a company. One of my tasks is to observe behaviors of employees and document trends as they relate to safe and at-risk actions. I already created a program that uses excel forms that I input into it to spit out statistics and neat graphs. Now I'm turning to php / mysql to make my job a little bit easier - it's not needed, but it's something I find myself doing in my free time. Basically, I want to be able to create forms to use for tracking these behaviors (this was easy enough to figure out in the way I laid out my mysql structures). From these forms that I create, I want to record this information and in turn spit out statistics and graphs, etc.... I attached a .pdf as an example form that I have created. Basically I want to be able to recreate this form via php and mysql (not that hard). But what's troubling me is dynamically creating this form from the database (which I have achieved) and then posting the users' results to the database (this is the problem). The user will be able to create their own sections to manage and keep track of statistics with. I think the way I set up my database is the best way of tracking those results too -- I included a file to query the database to create the tables and structure along with some data to give you a look at how I set it up. =======The Problem======= I can dynamically create the form from the database and even have text input fields within each section and category. I'm just having trouble with getting the submit button to actually commit it to the database. I don't know where to begin. Each row needs to it's own entry within a table, but I want the user to be able to fill out the form and submit it all at once. With the code I included, everything works except for the actual submit button. When the submit button is clicked, I want each row (I call them OBSERVATIONs in the database) to be recorded to the DATA table. The DATA table keeps up with how many forms were submitted (so a user can later go back and see their entry). Each OBSERVATION is recorded along with their data (safe, at risk, code, comments). If the safe or at-risk fields have no entry then I don't want it to record (I can set this conditional up). ============== I'm sure it will all make more sense if you look at my included code (that somewhat works), the way I set up my database, and the .pdf form I've included. Basically I want to be able to add / create more forms or add / create more observations to each form all the while it dynamically keeps track of my stats. I think setting up the database the way that I did will allow for me to keep track of more stats or show numbers in a different way. [attachment deleted by admin]

NVM. Just found and started playing with mySQL's export features... it generates a script

I looked on the internet and can't find a viable solution... I have a database set up the way I like it (no data in it or anything) - just the database itself along with tables and fields. I need to create a php script that will copy the template database and make a new one. Or Is there a way within phpmyadmin to output the php code necessary to do this? I found that within phpmyadmin if I copy a database it will show the query it used to create it, but it truncates it - not leaving me with the entire code. I just need to create a new database with my given tables and fields without having to go through and code it all myself - either copying it or having phpmyadmin spit out the code would be great!

I'm using the Zend AMF framework + php + as3 document classes to connect to a mySQL database. Everything is fine, I have an established connection and can retrieve data from the database. But my problem is retrieving it all AND retrieving it dynamically. For example, I want to query mySQL for a list of databases (this step isn't so important - I'm only doing this in case there are multiple users storing data in their own database - I can use php to determine which database to connect to based on their login etc...). Then query a particular database for a list of tables (store them in an array). Retrieve the array into flash and retrieve all of the fields from each table. Here's how I see the solution (just having trouble wrapping my head around it): php class called on by flash that queries the database. The php class queries for a list of tables within the database that is passed in. This class returns an array to flash. Flash uses a for loop to go through each table name and pass it into a php class that returns an array of fields based on each table name. I'll just post all of my code so that it may spark some ideas. I need to convert a lot of the hardcoded names (i.e. the database name) so that I can dynamically call and retrieve all of the information on a mySQL database and store it in flash so that I can easily use the data. my PHP class: <?php class SAFE { public function __construct() { mysql_connect("localhost", "root", "root"); mysql_select_db("CLEVELAND_SCHERER"); } public function getFields($table) { $result = mysql_query("SELECT * FROM `$table`"); $info = array(); while($row = mysql_fetch_assoc($result)) { array_push($info, $row); } return $info; } public function getTables() { $tableResults = mysql_query("SHOW TABLES FROM CLEVELAND_SCHERER"); $tableArr = array(); while($row = mysql_fetch_assoc($tableResults)) { array_push($tableArr, $row); } return $tableArr; } } my AS3 code: package com.SAFE { import flash.display.MovieClip; import flash.net.NetConnection; import flash.net.Responder; public class SAFE extends MovieClip { var nc:NetConnection = new NetConnection(); var tables:Array = []; //stores the names of the tables in a given database public function SAFE():void { nc.connect("http://localhost/SAFE/"); //gets all the tables in the database and stores them in the tables[] array var tableRes:Responder = new Responder(getTables, onError); nc.call("SAFE.getTables", tableRes) //trace(tables[0]); } function getTables(e:Object):void { for(var i:int=0; i<e.length; i++) { //pushes the names of tables in a database to the tables[] array //this is not dynamic (CLEVELAND_SCHERER is the database name hardcoded into this script) tables.push(e[i].Tables_in_CLEVELAND_SCHERER); //trace(tables[0]); } var fieldRes:Responder = new Responder(getFields, onError); nc.call("SAFE.getFields", fieldRes, tables[0]); } function getFields(e:Object):void { for(var i:int=0; i<e.length; i++) { trace(e[i].DATE); } } function onError(e:Object):void { trace(e); } } } Right now it works 100% but it's not what I'm looking for. I just need some help wrapping my head around some of the for loops with multiple arrays and actually using them in flash (i.e. calling on them after they're in flash - array.tablename[j].field[k] = etc....) What's the best way of retrieving all the data from a database dynamically and using it in flash?

Like I said, I'm not asking for someone to spoon feed me answers. I'm looking for the basic structure of setting up the database in regards to the form I uploaded. What's the best way of setting up the database to record the information that's given on the forms? My way seems inefficient, in that setting up a database for each 'section' of the form can create a lot of databases (especially if I want to split this up and create the forms for different job sites). I'm just having difficulty organzing the data on an excel spreadsheet to a database. Any help would be appreciated.

First of all, I'd like to say thank-you if you're taking the time to read this and respond to me. This question merely has to do with the fact of setting up / organizing the database(s) within mySQL. I'm working on a project with the attached .pdf form that collects data. I already have it up and running through excel via vba, etc... The excel version spits out nice graphs, data sheets, statistics, etc... Now, I'm moving on and trying to create this on the web so that it's OS independent and can be accessible and written to from any computer. I figured the best solution would be to manage the results through mySQL databases and access them with php (and hopefully in the future the zend framework + flex/flash + php). But that's not important. I'm not asking for this to be coded for me - I'm just asking for opinions and information. With the given form, what is the best way to store this information that's recorded? In excel it's easy, all I have to manage is cells. I was thinking that each section should be a database (i.e. PPE, Fall Avoidance, etc...) and each entry under that being a table with the corresponding fields (Safe, At Risk, Code, Comments, ID). But, I got to thinking, that could be a lot of databases if I want to extend the form in the future with more sections. Safe and At Risk will be INTs - Code will only contain a letter A, B, or C. Comments will hold, well, comments. I need to be able to have a location to place the date, area, time, project #, and the person who recorded this too (as seen at the top of the form). I hope I'm not being vague - ultimately, what is the best way to store the information using the given form? I'll also attach another form to show you what the information looks like once it is filled out. Thanks for any information! [attachment deleted by admin]