Thread: MySQL for iOS?
View Single Post
turtle
Lord of the Rant.
Formerly turtle2472
 
Join Date: Mar 2005
Location: Upstate South Carolina
 
2022-01-17, 12:43

That is possible I suppose. I'm just struggling through the networking and docker right now. I know networking, just learning how docker handles it.

Searching around I found this article that talks about a "simple" php page to test connections.
Code:
<?php # Fill our vars and run on cli # $ php -f db-connect-test.php $dbname = 'name'; $dbuser = 'user'; $dbpass = 'pass'; $dbhost = 'host'; $link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'"); mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'"); $test_query = "SHOW TABLES FROM $dbname"; $result = mysqli_query($link, $test_query); $tblCnt = 0; while($tbl = mysqli_fetch_array($result)) { $tblCnt++; #echo $tbl[0]."<br />\n"; } if (!$tblCnt) { echo "There are no tables<br />\n"; } else { echo "There are $tblCnt tables<br />\n"; } ?>
Thing about this is it requires CLI php and I would like something like this but variables in the docker config so it can be simply updated as needed.

Louis L'Amour, “To make democracy work, we must be a nation of participants, not simply observers. One who does not vote has no right to complain.”
Visit our archived Minecraft world! | Maybe someday I'll proof read, until then deal with it.
  quote