extract data from static table

dstonek

I have some static tables. Each cell contains a photo and sometimes a descriptive text.
I need to get filename and description in the same order they appear in the table to add them in a mysql table.
Thanks in advance for any help on how to do this.

toddmarx

I had to do the same thing a while back and found that DreamweaverMX has a built in feature that made this all drag and drop. If you dont have DWMX, I would need to see the code that you have so far and see what I can do with it. I am not one of the experts, bud I did have to do this one a while back. 🙂

dstonek

I am using DWMX. I only found "export table" wich only exports the descriptive text.
How do you use drag and drop.
I cannot make some tests right now, I´m not in my desk.
I build group of data in Excel and then export it to MySQL.
I don´t have a code, I simply want to get the data from static tables only once.
Thank you

toddmarx

Ok, hope you stitting down, this will get a little on the lengthy side.

With DWMX it is so much easier. Open your page that you are wanting to put these tables. Create the tables. Now, look on the right and open the sub window "Application". On the Database tab, it will tell you what all you need to do before you can use this feature. (define a site, point to a testing server, ect). It will walk you throught that pretty much step-by-step. Once you have all of this done, click on the "Bindings" tab. On the bindings tab, click on the "+" sign. Then press "record set". Then just go through the interface there and it will walk you through what all you will need to do. This creats a binding, once this is done, you just drag and drop the info that you want to use and dreamweaver will write the code out and stuff.

I hope that helps you out. It is a little tricky and difficult to use at firts, but once you learn what all dreamweaver is looking for and stuff then you can just whiz right through setting up bindings and using that data. Also, when you are done, make sure to click on the database tab and click on the "+" again. This creates a connection to the database. You need to set one up for your "live" page. Unless, the info that you have given this previously will use the same info. For instance,

My testing server is "localhost", but right now, the site that I am buidling is hosted by someone else and MySQL is not on the same server, it is at mysql2.smarterlinux.com. So what I have doen to make things easier is that I have named the connection the same for both of them (ie mysqlconnect). DW tells the php server to <?php require_once("connections/mysqlconnect.php") ?>. Since the one for my local testing site is named the same as the one for the live site, I dont have to change the name of the "require_once" tag. I hope that this all makes sense. It is really easier than it sounds. If you cant get it, let me know and we will discuss more in private or something.

Hope it helps,
Todd

dstonek

Hi Todd, thanks for your help!
I am familiar with bindings and recordsets.
I don´t understand "drag and drop".
I have a static page with only one table.
Each cell contains a photo and a description (in the same cell) Not all photos have a description. I´ve created an aux MySQL table with two fields "photo" and "text". Also the respective recordset in a new empty php file.
¿Do I have to drag the entire table? ¿Drop where?
Thanks,
Daniel

toddmarx

Once you have created the binding, click on the recordset (the + sign next to it). There it will show you all the fields that you can use, then click on one, drag it to where you want it show up and then drop it place. 🙂

dstonek

Todd: I suspect we are not talking about the same thing.
<?php echo $row_Recordset1['photo']; ?>
This is the code of the dragged and placed field "photo".
How do I relate it whith the photo filenames in the static table?

This is an example of a static table. Pictures and text in each cell.

Photo1.jpg
TXT1

Photo2.jpg
TXT2

Photo3.jpg
TXT3

I need a list like

photo1.jpg | TXT1
photo2.jpg | TXT2
photo3.jpg | TXT3

Three records to add to a MySQL table.
A more specific example of one of my static tables is at

www.stonek.com/faunaing.htm
Thank you
Daniel

toddmarx

Ok, I think I see what you are getting at now. If I have this right, you are looking to have php/mysql display the pics and stuff automatically to where all you have to do is save the image to your image dir, and then add the image name and text into a Db right?

If so, I can help. I do apologize for the confusion and stuff, I am still very new to php/mysql and stuff. Ok, here is the code. This will tell php to go and get the image and desc and display to the browser and keep going until all records are shown:


 <?php  

  //here is the binding
mysql_select_db($database_mysqlconnect, $mysqlconnect);
$query_getImages = "SELECT * FROM table_name";
$getImages = mysql_query($query_getImages, $mysqlconnect) or die(mysql_error());
$row_getImages = mysql_fetch_assoc($getImages);
$totalRows_getImages = mysql_num_rows($getImages);
?>
<?php //here is where you will get the image, and the text to go with it
	  //and loop until all records are displayed
 do { ?>
<img src="images//<?php echo $row_getImages['image_field_name']; ?>"> 
<?php echo $row_getImages['text_field_name']; ?><BR>
<?php } while ($row_getImages = mysql_fetch_assoc($getImages)); ?>
 <BR>


  <?php 
  mysql_free_result($getImages);
?>

I hope that this is what you are looking for. If not, I apologize for all the confusion and time wasted. Just repost question and let one of the guru's try it. 🙂

~Todd😃