|
<pre><?php
$database = "starter_mag";
$password = "XXXXXXX";
$username = "XXXXXXX";
$hostname = "127.0.0.1";
$link = mysqli_connect($hostname, $username, $password, $database);
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "SELECT distinct TABLE_NAME FROM Information_schema.columns where TABLE_SCHEMA = '$database' ORDER BY table_name ASC";
$offset = 10000;
if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result)){
$tableName = $row['TABLE_NAME'];
$count = 0;
echo '------------------- INIT '.$tableName.' TABLE ---------------'.PHP_EOL;
do{
$tableQuery = "SELECT * FROM ".$tableName." limit ".$count*$offset.", $offset";
if($resultTableQuery = mysqli_query($link, $tableQuery)) {
if (mysqli_num_rows($resultTableQuery) > 0) {
while ($tableRow = mysqli_fetch_array($resultTableQuery)) {
echo ('('.$count.') '.$tableName.': ');
echo implode(',',$tableRow);
echo PHP_EOL;
}
}
}
$count++;
}while(mysqli_num_rows($resultTableQuery));
echo '------------------- END '.$tableName.' TABLE ---------------'.PHP_EOL;
}
mysqli_free_result($result);
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
mysqli_close($link);
modified 18-Sep-22 5:04am.
|
|
|
|
|
Wrong forum, notice the "Ask A Question?" at the top of the page.
Also give a little more description of what you've tried, what's wrong, et.. People are happy to help when they know the problem.
PartsBin an Electronics Part Organizer is finally available for download.
JaxCoder.com
|
|
|
|
|
I need to describe the functionality of this code, what it does, it's a challenge but I don't know anything about databases
|
|
|
|
|
|
|
We can take him.
|
|
|
|
|
As someone commented:
Quote: It would've been awesome if they had this roll into the Olympic stadium holding a torch during the opening show!
|
|
|
|
|
#Worldle #239 3/6 (100%)
🟩🟩🟨⬜⬜↖️
🟩🟩⬜⬜⬜➡️
🟩🟩🟩🟩🟩🎉
https://worldle.teuteuf.fr
It was binary search
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
I had to look at a map:
#Worldle #240 2/6 (100%)
🟩🟩🟩🟩⬜⬅️
🟩🟩🟩🟩🟩🎉
I figured the continent from the general shape, but I didn't even know that was an actual country ... and Wiki says it probably isn't.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
#Worldle #240 5/6 (100%)
🟩🟩🟩🟩🟨⬆️
🟩🟩🟩🟩🟨⬅️
🟩🟩🟩🟩🟨↙️
🟩🟩🟩🟩⬜↙️
🟩🟩🟩🟩🟩🎉
https://worldle.teuteuf.fr
I too figured out the continent. But after 4 tries, had to look at the map.
|
|
|
|
|
#Worldle #240 3/6 (100%)
🟩🟩🟩🟨⬜⬅️
🟩🟩🟩🟩🟨↙️
🟩🟩🟩🟩🟩🎉
https://worldle.teuteuf.fr
Had similar problem.
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
|
|
Visiting my mother in the South, dug up an old LP "Really" by J.J.Cale and listened to it while having dinner
Really album[^]
|
|
|
|
|
Style reminds me a lot like Clapton and Delbert McClinton
PartsBin an Electronics Part Organizer is finally available for download.
JaxCoder.com
|
|
|
|
|
Clapton was a big fan of JJ Cale, and they even made some records together.
Quote: The two finally met in the late '70s following a Cale show in London, when Clapton introduced himself backstage. "He was very, very polite and friendly. He showed me a guitar he had rebuilt. I said, 'That's fantastic,' and he said, 'This is a piece of (garbage).
|
|
|
|
|
Clapton has been a favorite o9f mine over the years.
Have had the luck to see him in concert twice and he puts on a good show.
PartsBin an Electronics Part Organizer is finally available for download.
JaxCoder.com
|
|
|
|
|
Turns out the payer's paler paper pager said nothing about a parer yesterday.
|
|
|
|
|
And a right git it was too ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Did the pacer's say anything?
// TODO: Insert something here Top ten reasons why I'm lazy
1.
|
|
|
|
|
No, but his pater did ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
And the paver? Did they weigh in?
To err is human. Fortune favors the monsters.
|
|
|
|
|
Just a bunch of pikers we all are.
|
|
|
|
|
Guess I was playing Poker
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
If they did, that would be RARER,!
|
|
|
|