https://reisub.nsupdate.info/git
/
smail.git
/
.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
2ea9381
)
counter user
dev
author
Fabián Bonetti
<mama21mama2000@yahoo.com.ar>
Fri, 28 May 2021 11:17:42 +0000
(08:17 -0300)
committer
Fabián Bonetti
<mama21mama2000@yahoo.com.ar>
Fri, 28 May 2021 11:17:42 +0000
(08:17 -0300)
scripts/counter_user.php
patch
|
blob
|
history
diff --git
a/scripts/counter_user.php
b/scripts/counter_user.php
index
e039f43
..
629dc05
100644
(file)
--- a/
scripts/counter_user.php
+++ b/
scripts/counter_user.php
@@
-1,25
+1,41
@@
<?php
<?php
-$mysqli=new mysqli('localhost', 'user', 'user_password', 'bd_name');
+$servername = "localhost";
+$username = "user";
+$password = "pass";
+$dbname = "mybd";
+
+// Create connection
+$mysqli = mysqli_connect($servername, $username, $password, $dbname);
+// Check connection
+if (!$mysqli) {
+ die("Connection failed: " . mysqli_connect_error());
+}
+
$mysqli->query("SET NAMES 'utf8'");
echo "Usuarios SMail Stable\n";
$q=$mysqli->query("SELECT mail_user FROM mail WHERE mail_user LIKE '%smail.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
$mysqli->query("SET NAMES 'utf8'");
echo "Usuarios SMail Stable\n";
$q=$mysqli->query("SELECT mail_user FROM mail WHERE mail_user LIKE '%smail.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
+
echo "Usuarios SMail Dev\n";
$q=$mysqli->query("SELECT mail_user FROM mail WHERE mail_user LIKE '%reisub.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
echo "Usuarios SMail Dev\n";
$q=$mysqli->query("SELECT mail_user FROM mail WHERE mail_user LIKE '%reisub.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
+
echo "Canales/Grupos SMail Stable\n";
$q=$mysqli->query("SELECT * FROM mail_lists WHERE channel_admin LIKE '%smail.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
echo "Canales/Grupos SMail Stable\n";
$q=$mysqli->query("SELECT * FROM mail_lists WHERE channel_admin LIKE '%smail.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
+
echo "Canales/Grupos SMail Dev\n";
$q=$mysqli->query("SELECT * FROM mail_lists WHERE channel_admin LIKE '%reisub.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
echo "Canales/Grupos SMail Dev\n";
$q=$mysqli->query("SELECT * FROM mail_lists WHERE channel_admin LIKE '%reisub.%'");
while($r=$q->fetch_assoc()) {
print_r($r);
}
-mysql_close($mysqli);
+
+$mysqli->close();
?>
?>
+