Some Help Please Guys... 1

[coldfused]

Ok here is where I am at. I have this little league thing i'm doing where I have to secure the data being sent from the form. Decided not to have the info sent to a email client at all. As per Wullie's suggestion little league was cool with storing the submitted form in a database on the server, accesible only through user name password.

My problem is I dont know how to set up mysql tables and such for php forms to store the data, start the database class on september,1st...does me no good at this moment, and I need to get this site up in the next few days, all I am waiting on is securing this form.

Do you guys know of any cgi script, or javascript form processor that stores the data submitted to a txt file or something, in some formatted way so that they can access the file and print it out with the registration info from the form. I can do the htaccess thing to protect the diractory where the files will be stored, just need some help getting the data processed and stored.

I found this

http://phpformgen.sourceforge.net/

which is really cool program(minus the creating the form for ya part) that processes through php and stores to a form based database file generated by the php, or can access sql tables if you know how.

Now the form based data file that it creates would be fine except it looks like this:

http://mwll.com/example.gif

Which does me no good if the typical house mom that will be collecting the data cant just simply log into the page and print out the registration in some kind of formatted way, so they then can be taken on registration day and submitted along with the fee.

Guys any help would be greatly appreciated, I really need to wrap this up quickly.

And I promise I am taking SQL, MY SQL and PHP Starting in September at

http://www.hwg.org/

- So I will learn this real soon, Just need to work through this one.

http://www.orlandomediasolutions.com

http://www.mlstaffing.com

 

[Wullie]

Hi Mate,

I don't use PHP so I can't really help you with that, but the format that the picture shows is the same as if you stored it in any database. (MySQL etc)

The whole point of the database is that each set of data is stored in a row, then you can pull the appropriate data that you need and then you use your data to populate a page for them to print, you don't want to print directly from the database.

Hope this helps

Wullie

http://www.necomputers.org.uk

http://www.freshlookdesign.co.uk

http://www.freshlookdesign.com

http://www.whiland.co.uk

The pessimist complains about the wind. The optimist expects it to change.
The leader adjusts the sails. - John Maxwell

 

[Gatorajc]

Do you have any experience at all with a database? How are you accessing MySQL? Command line or GUI.

Do you know how to do the connection from PHP to MySQL?

AJ


If at first you do not succeed, cheat!

 

[coldfused]

Unfortunatley not at this time AJ. Through my host I can connect to mysql through GUI, Just have no idea what i'm doing yet.

That is why I was looking for a cgi or javascript that would do it for me. I would just pay the guy who does my database stuff to do it, but this one is a non profit project, by the time I payed him, I would be at a loss. So I have to do this one myself.

But like I said by first of the year I will be well trained in all of this, just does me no good at this moment. Will keep looking.

Thanks guys...

http://www.orlandomediasolutions.com

http://www.mlstaffing.com

 

[deecee]

make a file and call it say dbaseconnection.php...This file will hold the info for your connection string to the database

<?php
# FileName=&quot;Connection_php_mysql.htm&quot;
# Type=&quot;MYSQL&quot;
# HTTP=&quot;true&quot;
$hostname_connCasino = &quot;dbase connection(most of the time localhost will do)&quot;;
$database_connection_name = &quot;dbase name&quot;;
$username_connection_name = &quot;username&quot;;
$password_connection_name = &quot;password&quot;;
$connection_name = mysql_pconnect($hostname_connection_name , $username_connection_name , $password_connection_name ) or die(mysql_error());
?>

now that you have your connection string set up you would lead off a page that uses this connection with

<?php require_once('Connections/dbaseconnection.php'); ?>

so with this you should be able to connect to your database. Virt I know you are into flash so if you have DWMX there are some great extensions to help you out with what you are trying to do. Just hit the Macromedia Exchange or let me know and i can send you my php extensions that i use. But honestly about 20 minutes on the exchange and you should have 90% of them. I hope this is what you are looking for but if not then maybe someone else can use it.

<signature>
sometime you just gotta say &quot;WHAT THE @#*% !!&quot;
</signature>

 

[coldfused]

Thanks deecee, will look into the extensions at macromedia.

http://www.orlandomediasolutions.com

http://www.mlstaffing.com

 

[coldfused]

Deecee I looked on the exchange for the extensions, but was unclear which ones specificly to use. Could you either send the ones you speak of, or atleast point me to the right direction?

Thanks,

http://www.orlandomediasolutions.com

http://www.mlstaffing.com

 

[deecee]

here is a link to all my extensions (1 large file). some probably are repeated. (approx. 20 mb)

http://www.cascadecorp.com/dreamweaver.zip

i dont have much time right now to go through them and pick the ones most useful but once all are installed you will have pretty much full php functionality in DWMX just like with ASP or Coldfusion (for the most part). Since it is a large file i will have to take it down by 5:00 Pacific time as it sucks up company server space.

<signature>
sometime you just gotta say &quot;WHAT THE @#*% !!&quot;
</signature>

 

[coldfused]

Thanks alot Deecee, take them down anytime.

http://www.orlandomediasolutions.com

http://www.mlstaffing.com