|  | 
  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 walrothmySQLi 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 walrothThanks 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
 |