|
jack walroth - 2019-02-23 01:15:00
<?
// sept 17 2011
// cloud connect script
$server="mariadb-080.wc2.phx1.stabletransit.com";
$username="618547_jaxADMIN1";
$password="jaxLSMS1818";
$database="618547_jax78s";
$db = mysqli_connect($server, $username, $password);
mysqli_select_db($database,$db);
$db = mysqli_connect("mariadb-080.wc2.phx1.stabletransit.com", "618547_jaxADMIN1", "jaxLSMS1818");
mysqli_select_db("618547_jax78s",$db);
$result = mysqli_query("SELECT * FROM forsale",$db);
echo "<table border=3>\n";
while ($myrow = mysqli_fetch_row($result)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>
<td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9] );
}
echo "</table>\n";
?>
</body>
</html>
Dave Smith - 2019-02-23 01:33:45 - In reply to message 1 from jack walroth
mySQLi uses the link as the first property in methods that require the link, so...
mysqli_select_db("618547_jax78s",$db);
should be...
mysqli_select_db($db,"618547_jax78s");
and...
$result = mysqli_query("SELECT * FROM forsale",$db);
should be...
$result = mysqli_query($db,"SELECT * FROM forsale");
Also, if these are the real credentials to access your database you will need to immediately change the user and password since you have publicly posted them here.
Dave
jack walroth - 2019-02-23 03:10:42 - In reply to message 1 from jack walroth
Thanks Dave,
I appreciate your response and will go ahead and try this with my code.
Not quite the real credentials, thanks for warning.
best regards,
Jack
|