Buongiorno
Vi chiedo un aiuto per una formula in php da integrare una pagina già pronta.
Ho effettuato vari tentativi con le funzioni echo tuttavia mi riportano sempre errore.
Debbo mostrare tutto il contenuto di alcune colonne di una tabella
Esattamente debbo mostrare tutto il contenuto della colonna username e id presenti della tabella ptsu_log
Potete aiutarmi.
Vi allego il codice della pagina dove debbo integrare la funzione, ho gia indicato dove dovro aggiungere le funzioni
Vi ringrazio per aiuto
Codice PHP:
<?
$includes[title]="Manage PTSU Ads";
//**VS**//$setting[ptsu]//**VE**//
//**S**//
$sql=$Db1->query("SELECT COUNT(id) AS total FROM ptsu_log WHERE status = 0");
$total_offers_wait=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT COUNT(id) AS total FROM ptsu_log WHERE status = 1");
$total_offers_approved=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT COUNT(id) AS total FROM ptsu_log WHERE status = 3");
$total_offers_deny=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT SUM(pamount) AS total FROM ptsu_log WHERE status = 0");
$total_value_offers_wait=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT SUM(pamount) AS total FROM ptsu_log WHERE status = 1");
$total_value_offers_approved=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT SUM(pamount) AS total FROM ptsu_log WHERE status = 3");
$total_value_offers_deny=$Db1->fetch_array($sql);
$includes[content].="
<script>
url_variables = '".iif($sid, "sid=".$sid."&").iif($sid2, "sid2=".$sid2."&").iif($siduid, "siduid=".$siduid."")."';
search_str='".$search_str."';
ajax_resource='ptsu';
</script>
<div id=\"returnOut\"></div>
<div style=\"float: right; display: none;\" id=\"loading_alert\"><tt style=\"color: gray\">Loading</tt> [img]images/loading.gif[/img]</div>
<ul id=\"maintab\" class=\"shadetabs\">
<li class=\"selected\"><a href=\"#default\" rel=\"manage_ads\">Manage Ads</a>
[*]<a href=\"#\" rel=\"search_ads\">Search Ads</a>
[*]<a href=\"#\" rel=\"new_ad\">New Ad</a>
[*]<a href=\"#\" rel=\"edit_ad\">Edit Ad</a>
[*]<a href=\"#\" rel=\"approve_ads\" rev=\"approve_ads_load()\">Approve Ads</a>[/list]
<div class=\"contentstyle\" style=\"width: 700px\">
<div id=\"search_ads\" style=\"display: none; padding: 3px;\">
<div align=\"center\">
<table>
<tr>
<td align=\"center\">Search <input type=\"text\" name=\"search_str\" id=\"search_str\" value=\"\">
<select id=\"search_by\">
<option value=\"id\">Id
<option value=\"title\">Title
<option value=\"target\">Banner Url
<option value=\"pamount\">Value
<option value=\"credits\">Number Credits
<option value=\"signups_today\">Number Completed Today
<option value=\"signups\">Number Completed Total
<option value=\"active\">Active Offers (0/1)
<option value=\"rotation\">Rotation Offers (0/1)
</select>
<input type=\"button\" value=\"Search\" onclick=\"dosearch()\"></td>
</tr>
</table>
</div>
</div>
<div id=\"edit_ad\" style=\"display: none; padding: 3px;\">
<div align=\"center\">
You must select an ad to edit from the manage ads tab.
</div>
</div>
<div id=\"new_ad\" style=\"display: none; padding: 3px;\">
<script>
function verifyForm() {
return true;
}
</script>
<div align=\"center\">
<div id=\"new_ad_message\" class=\"messagebox\" style=\"display: none;\"></div>
<form id=\"newAdForm\">
<table width=\"450\">
<tr>
<td width=\"200\"><div class=\"form_row_title\"> Title: </div></td>
<td><div class=\"form_row_value\"> <input type=\"text\" name=\"title\" value=\"$title\"> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Banner Url: </div></td>
<td><div class=\"form_row_value\"> <textarea rows=\"8\" cols=\"25\" name=\"target\" class=\"fields\">$target</textarea></div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Username: </div></td>
<td><div class=\"form_row_value\"> <input type=\"text\" name=\"user\" value=\"$username\" readonly=\"readonly\"> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Credits: </div></td>
<td><div class=\"form_row_value\"> <input type=\"text\" name=\"credits\" value=\"0\"> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Class: </div></td>
<td><div class=\"form_row_value\"> <select name=\"cclass\">
<option value=\"C\">Cash
</select> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Value: </div></td>
<td><div class=\"form_row_value\"> <input type=\"text\" name=\"pamount\" value=\"\".$settings[ptsu_value].\"\"> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Active: </div></td>
<td><div class=\"form_row_value\"> <input type=\"checkbox\" value=\"1\" name=\"active\" checked=\"checked\"> </div></td>
</tr>
<tr>
<td><div class=\"form_row_title\"> Rotation: </div></td>
<td><div class=\"form_row_value\"> <input type=\"checkbox\" value=\"1\" name=\"rotation\" checked=\"checked\"> </div></td>
</tr>
<tr>
<td colspan=2 align=\"center\"><input type=\"button\" value=\"Add Link\" onclick=\"create_ad()\"></td>
</tr>
</table>
</form>
</div>
</div>
<div id=\"manage_ads\" style=\"display: block\">
</div>
<div id=\"approve_ads\" style=\"display: block\">
</div>
</div>
<font color='blue'>[b]Offers Wait: ".number_format($total_offers_wait[total])."</font> - <font color='green'>[b]Offers Approved: ".number_format($total_offers_approved[total])."</font> - <font color='red'>[b]Offers Deny: ".number_format($total_offers_deny[total])."</font>[/b]
<font color='blue'>[b]Offers Value Wait: ".number_format($total_value_offers_wait[total],2)."</font> - <font color='green'>[b]Offers Value Approved: ".number_format($total_value_offers_approved[total],2)."</font> - <font color='red'>[b]Offers Value Deny: ".number_format($total_value_offers_deny[total],2)."</font>[/b]
--------------------------------------------------------------------------------------------------------
QUI DEBBONO APPARIRE TUTTI I DATI CONTENUTI NELLE COLONNE username - status DELLA TABELLA ptsu_log
--------------------------------------------------------------------------------------------------------
<script type=\"text/javascript\">
//Start Ajax tabs script for UL with id=\"maintab\" Separate multiple ids each with a comma.
//startajaxtabs(\"maintab\")
startTabs(\"maintab\");
update_manager(0, 100, '', '');
</script>
";
//**E**//
?>
Rispondi quotando