I am a newbie to this:
To begin with, I set up an 'apache' testing server on my machine.
Then using MySQL Front I created a MySQL database from a .xls file to be hosted @ localhost
Using php script through dreamweaver was able to display through a browser, information accessed from within the MySQL database created.
Everything working afters hours of trials and tribulations......
Contacted my isp where I received information regarding access to phpMyAdmin hosted on their server...
Using phpMyAdmin I have imported the data to a table within a database created by my isp.
Table is called 'chemical' database is called 'wx110245' password '******' host 'localhost'
Updated php script to reflect this, and uploaded php file to server via ftp.
though php script is not displaying data.
script is as follows below
world is displayed but no data from the database.....
Q: once I have setup the database in phpMyAdmin is there a last process required in terms of deployment? or is there something else you can see in my process that requires change?
__________________________________________________ _____
<?php print 'world'?>
<?php
$mysqli = new mysqli('localhost','atomek','******');
$mysqli->select_db('wx110245');
$result = $mysqli->query("SELECT* FROM chemical");
while($row = $result->fetch_assoc()) {
print '<hr align="center" width="600">'.'<span class="text01"><b>Chemical: </b></span>'.'<span class="text03"><b>'.$row['Chemical'].'</b></span>'.'<br/>'.'<span class="text01"><b>Paints & Products: </b></span>'.'<span class="text03">'.$row['Paints & Products'].'</span>'.'<br/>'.'<span class="text01"><b>Resins, Varnishes and Stains: </b></span>'.'<span class="text03">'.$row['Resins, Varnishes and Stains'].'</span>'.'<br/>'.'<span class="text01"><b>Caulking/ Fillers/ Sealants etc: </b></span>'.'<span class="text03">'.$row['Caulking/ Fillers/ Sealants etc'].'</span>'.'<br/>'.'<span class="text01"><b>Glues/ Adhesives: </b></span>'.'<span class="text03">'.$row['Glues/ Adhesives'].'</span>'.'<br/>'.'<span class="text01"><b>Walls, Wall frames, Ceilings, Roofing: </b></span>'.'<span class="text03">'.$row['Walls, Wall frames, Ceilings, Roofing'].'</span>'.'<br/>'.'<span class="text01"><b>Timbers: </b></span>'.'<span class="text03">'.$row['Timbers'].'</span>'.'<br/>'.'<span class="text01"><b>Floors and Floor Coverings: </b></span>'.'<span class="text03">'.$row['Floors and Floor Coverings'].'</span>'.'<br/>'.'<span class="text01"><b>Insulation, membranes: </b></span>'.'<span class="text03">'.$row['Insulation, membranes'].'</span>'.'<br/>'.'<span class="text01"><b>Conduits, piping, plumbing: </b></span>'.'<span class="text03">'.$row['Conduits, piping, plumbing'].'</span>'.'<br/>'.'<span class="text01"><b>Fixtures and furnishings: </b></span>'.'<span class="text03">'.$row['Fixtures and furnishings'].'</span>'.'<br/>'.'<span class="text01"><b>Soft Furnishings: </b></span>'.'<span class="text03">'.$row['Soft Furnishings'].'</span>'.'<br/>'.'<span class="text01"><b>Description: </b></span>'.'<span class="text03">'.$row['Description'].'</span>'.'<br/>'.'<span class="text01"><b>Main component use: </b></span>'.'<span class="text03">'.$row['Main component use'].'</span>'.'<br/>'.'<span class="text01"><b>Health concerns and other details: </b></span>'.'<span class="text03">'.$row['Health concerns and other detail'].'</span>'.'<br/>'.'<span class="text01"><b>Sources - see information sources for details: </b></span>'.'<span class="text03">'.$row['Sources - see information sources for details'].'</span>'.'<br/>'.'<br/>';}
$result->close(); ?>
__________________________________________________ _____