Skip to main content
S
SquareEyes79
Participant
July 26, 2009
Question

Using MySQL to populate website with product data

  • July 26, 2009
  • 4 replies
  • 792 views

Hi,

I have a product database which i want to use to quiclly populate parts of my website with the same info e.g. product A 'name' and 'price' in three different locations.

I have set up a IIS7, PHP and MySQL environment. In a new php file I can successfully connect to my database tables in Dreamweaver CS4, using the 'Database' tab.

When I right click and 'View Data' - no probs

When I add a Recordset, for e.g. with no filters to show all my data, and i click 'Test' all my data appears.

However, when I click 'OK' and go back to Dreamweaver nothing appears in Design View or Live View except a little php icon.

If I select Dynamic table, using the recordset, the colun headings appear but no product data.

When I do a test php echo statement the text appears, so why does the data not appear?

Thanks in advance for any help. Pls keep advice as simple aas possible!

This topic has been closed for replies.

4 replies

S
SquareEyes79Author
Participant
July 27, 2009

Update to update!

I don't know why but today my single data cell bindings I drag into Design View are displaying in Live View and Live Data View!

Hoorah.

Wish I knew why though!

S
SquareEyes79Author
Participant
July 27, 2009

Update.

OK. I can get the data from my database to show up in Live Data vew, but I can only seem to select data down to column level.

I can create Recordset - SELECT RowA FROM table WHERE columnA = columname

I tried Recordset - SELECT RowA FROM table WHERE columnA = 1; but this is when no data displays on screen.

I need to select an individual cell value from my database table to display within my webpage. I know this is possible by writing the PHP scipt outside of Dreamweaver (but I'm only a beginner!) Is it possible using the Advanced Recordset menu interface in Dreamweaver?

Thanks

S
SquareEyes79Author
Participant
July 26, 2009

Thanks for the quick response.

I have checked wat you said and noted that the PHP icon appears in Design View, but when I click Live View nothing appears (not even the icon).

I added a 'Hello World' text in the same file to test PHP and it does display in Live View.


Any more advice?

DwFAQ
DwFAQ
Participating Frequently
July 26, 2009

Heya,

If you want to view dynamic data in design view of Dreamweaver instead of the little php icon you have to enable Live View. Click on the lightning bolt icon in the toolbar between code/split/design view buttons and the Title text field or press Shift/Command/R to enable Live Data View.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices