:: Forum >> Version 1 >>

Using AW with PHP and MySQL


Does anybody have a working example of a AW using PHP with a MySQL database?

Or can anybody give me some advise on what I need to do? Like what fields I need to create in MySQL

Any help is much appreciated

Many thanks

Monday, August 29, 2005
In regards to what fields you need in mySQL, thats totally up to you as the developer and what you're trying to accomplish with the application you are writing.

in regards to the rest...
i suggest you scroll down in the forums, not less than 3 days ago this topic was discussed in lenght with code examples and the like.

I also suggest using the FORUM SEARCH before askin a question.
Monday, August 29, 2005
I always use the search function in all the forums I participate in and moderate thank you.

Which topic are you referring to anyway? The one about connecting Access to MySQL using ODBC or the topic about using Macromedia's ColdFusion with MySQL?

I've never used ColdFusion nor do I have any desire to learn it. I'm currently learning PHP and I'm starting to understand how it works so some help/advise and maybe some examples would be of great use to me.
Monday, August 29, 2005
I've managed to get it working wooopeeee !!! :)
Monday, August 29, 2005
I'm using it with tabs ".dynamic-tab-pane-control" on our intranet. Quite useful at the moment - looking into drag & drop of extra fields at some point.
Monday, August 29, 2005
Here's How I've Done It.

require 'your_database_here.php';
$query2 "SELECT * FROM equipmentlist ORDER BY Type, Id"//Build The Query
$result2 mysql_db_query($dbname$query2$link) or die("Cannot $query2"); //Run The Query

$num_rows2 mysql_num_rows($result2);  //Get The Number Of Rows

while ($row2 mysql_fetch_array($result2))  //Create An Array Of Data
{$mydata[] = "[\"$row2[Id]\", \"$row2[Type]\", \"$row2[Status]\", \"$row2[Mmduser]\", \"$row2[Mmdpassword]\", \"$row2[Notes]\"]";}

$mydata implode(",\n"$mydata); //Turn The Array Into A String

print "var myData = [\n".$mydata."\n"."];";
Down In The Bottom Section, You'll Find 'obj.setRowCount'. Use The Num Rows You Created Earlier Here.

Hope That Helps!
Rick Clark
Friday, October 7, 2005

This topic is archived.

Back to support forum

Forum search