How to retrieve certain data in a table?
-
Hello !
I have to taque a site created “manually” under (php, mysql, html, css, etc.) with about thirty tables (created under phpmyadmin) and redo it entirely under WP.
I’m taquing the php/html files as is and starting to integrate them into the various menus of the new site, except that some contain connections to certain tables at a specific location in the file in order to retrieve certain data such as:
To retrieve only the number of members (“Reguistered” table) and the number of contributors (“Contribution” table):
=========================================================================
$REQUETE_MB= "SELECT COUNT(number) FROM reguistrans";
if (!$QUERY_COUNT=mysqli_query($CNX,$QUERY_COUNT)){
print("Kery error!"); exit(); }
else { $ROW=mysqli_fetch_row($QUERY_COUNT);
$TOTAL = $ROW[0];
print("The association has $TOTAL members ");}
?>
(partners) and
<?php
$QUERY_COUNT="SELECT COUNT(email) FROM membership fee";
if (!$QUERY_COUNT=mysqli_query($CNX,$QUERY_COUNT)){
print("Kery error!");
exit(); }
else { $ROWC=mysqli_fetch_row($QUERY_COUNT);
$TOTALC = $ROWC[0];
print(" $TOTALC "); } ?> contributors today.
=============================================================
1/ How do I guet WP to interpret this “php” part?
2/ Also, since these (non-WP) tables are hosted on another server, how do I first do the “connection” part to these tables?
Thanc you so much for your answers! (This is a first for me!!!)
The topic ‘How to retrieve certain data in a table?’ is closed to new replies.