Replies Back to Article

PHP and Dreamweaver MX Continued

upload image
September 16, 2003 by thee soul

is there also a way to input (upload) an image within this script and upload the file to a "var/www/home/img" folder?. And if you open the data is is associated with that particular data.?

Thanks, george.

,RE: upload image
September 17, 2003 by Allan Kent

Hi George,

there's an excellent extension on DMXZone called Pure PHP Upload which sounds like it will sort you out.

http://www.dmxzone.com/ShowDetail.asp?NewsId=4509

Allan

Problem with edit page
May 6, 2004 by lime limeo

Hi,

I tried this tutorial, but I'm having some problems. After I've clicked the edit link, I don't see the values that where associated with the primary key, instead I always see the first data in my table. But when I put my mouse over the EDIT link, I do see the correct Primary key. It seems that the edit page does'nt receive the PK.

My recordset is set with get PK from URL, what else should I verify ?

Thank you,

RE: Problem with edit page
May 7, 2004 by Allan Kent
Hi, sounds like the filter for the rsCountry recordset isn't being set correctly and it is using the default of 1 for the country_pk - double check that you spelt the country_pk URL paramater correctly in the Edit link in countries.php as well as in the Recordset dialog for rsCountry in edit.php. Allan
Too hard
June 2, 2004 by jim holmes
I found this way too confusing - especially the bit about putting recordsets into DW - big steps seemed to be glossed over. I gave up!
Also..
June 2, 2004 by jim holmes

...I found myself wondering well - what IS a 'Null'...why would I want/not want one? What IS a primary key and what does it do?

These things were not explained, so it would be very hard to create my own database from this tutorial...

RE: Too hard
June 2, 2004 by Allan Kent
Hi, have you read the first article in this series http://www.dmxzone.com/go?4390 which explains creating the datanbase that you're working with? allan
RE: RE: Too hard
June 2, 2004 by jim holmes

Hi Allan,

yes - I did go through that one, but as I posted above, I found myself wanting to know more about why things were as they were ( Nulls/Primary Keys/etc..) I guess you have to limit the scope of the tutorial at some point though!

mysql_fetch_assoc() ... not a valid resource
August 17, 2004 by linda haker

When I try to view the page countries.php to see if the php works (First page, item "Displaying data"), I get an error message:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

I did everything according to your article (which is great, btw!). Any idea what I could've overlooked?

Linda

---
php-4.3.8
mysql-4.0.2
apache_2.0.50

Updating Content
October 10, 2004 by Bill Robinson

As usual Macromedia has provided another easy way to work on the web. Your articles have been very useful. I cannot sem to get the Update feature to work. I have the forms at the following url:

http://www.333connect.com/country1.php

It will add and delete but not update. I have tried everything.

 

Brilliant !
March 2, 2005 by Harry Nibble

This tutorial really did get me on the right road to the place I want to be.

True that there were times I really did have to think about what I was doing,  and I had a few issues along the way but persistence paid off.

Sometimes the screenshots helped me so if you get stuck somewhere,  study them and look for differences.

One part which really hung me up was setting the parameters for delete/edit.   I could not get my link text the same as the sample (delete.php?country_pk=<?php echo $row_rsCountries['country_pk']; ?> ).   In partucular the "country_pk" part and had to edit that manually.

Time to put my pedantic hat on and mention a typo.   The last page third paragraph says "This however we will need to add a hidden field".  I think it means to say "This time however ..."  (well,  I did say I was being pedantic !   :o)

The bottom line is,  thanks for your efforts producing a very illuminating and helpful tutorial,  it rocks !

A Little problem
October 27, 2005 by Karen Lynch

Hey, great article - got me up and running however, I have a little problem.  Say I want to display part of the info from the database then when the user clicks "read more" how do I link to another page with the entire feature?  I have tried linking with: MessagesDisplay.php?<?php echo $row_teaser['code']; ?>= but never get the correct record.

Thanks for your help