|
PHP - Improved Method To Display Pdo Query
I've used a showQuery() method for years which accepted a SQL string and data array. Sometimes, I just have the PDO statement and I need to add temporary script just to keep track of the SQL string. Was looking at debugDumpParams() today which prompted me to create the new showStmtQuery() method. My approach of extracting the table from debugDumpParams's printed results is a little clunky. Any recommendations? Could/should other information from debugDumpParams's output be used? I typically don't use bound parameters but know I should more often. Suggestions how this could be changed to work with bound parameters? Thanks
function showQuery(string $sql, arrray $data, bool $keepLineBreaks=false):string {
$keys = [];
$values = [];
foreach ($data as $key=>$value) {
$keys[] = is_string($key)?'/:'.$key.'/':'/[?]/';
$values[] = is_numeric($value)?$value:"'$value'";
}
$sql = preg_replace($keys, $values, $sql, 1, $count);
return $keepLineBreaks?$sql:str_replace(array("\r", "\n"), ' ', $sql);
}
function showStmtQuery(\PDOStatement $stmt, array $data, bool $keepLineBreaks=false):string {
ob_start();
$stmt->debugDumpParams();
$sql = ob_get_contents();
ob_end_clean();
//$sql = strtok(substr($sql, strpos($sql, '] ')+2), "\n");
$start=strpos($sql, '] ')+2;
$sql = substr($sql, $start, strpos($sql, "\nParams:") - $start);
return showQuery($sql);
}
$data=[5,50];
$sth = $pdo->prepare('SELECT *
FROM my_table
WHERE id > ? AND id < ?');
echo(showStmtQuery($sth, $data).PHP_EOL); //SELECT * FROM my_table WHERE id > 5 AND id < 50
$data=['lowId' => 5, 'highId' => 50];
$sth = $pdo->prepare('SELECT *
FROM my_table
WHERE id > :lowId AND id < :highId');
echo(showStmtQuery($sth, $data).PHP_EOL); //SELECT * FROM my_table WHERE id > 5 AND id < 50
Changed to use original showQuery function Similar TutorialsHi, Im currently using the following code, to list 'Todays 5', however can the following be improved im uneasy with using php for the date comparison - perhaps have it within the sql? DB Structu I have a column named 'flash_date' (and the type is: varchar(32)) which contains a timestamp generated by time() $yesterday = strtotime('-1 day'); $time = time(); $result = mysql_query("SELECT * FROM site_flash WHERE flash_date > '{$yesterday}' AND flash_date < '{$time}' DESC LIMIT 5"); I use AJAX method to get the value for `$month` from the year-month selection in my page. The year-month is pass correct correctly when it gets into my PHP code. But i am not sure how do i get the value and use it for my sql condition. I'm trying to plot a graph using Chart JS according to the year-month selection from the user. when the user select "2021-03" all the order that is made in the month of March will be plotted into the graph. There's no data shown in my page now and i do not know how can i query it. Can anyone enlighten me how can i do it? Because i do not know what mistake did i made here. Any kind of explanation will be appreciated. Thanks!
This is the code that i use for year-month selection
<div class="col-2 my-auto">
<input type="month" id="month" class="form-control" value="<?php echo date('Y-m'); ?>">
</div>
<div class="col-2 my-auto">
<button type="button" class="btn btn-info" onclick="loadchart();">
<i class="nc-icon nc-zoom-split"></i>
</button>
</div>
This is the AJAX method
<script type="text/javascript">
function loadchart()
{
$('#spin1').show();
var month= $('#month').val();
var data = {
month: month,
}
$.ajax({
method:"GET",
data:data,
url:"includes/loadchart.php",
success:function(data)
{
$('#loadchart').html(data);
}
});
}
this is my loadchart.php
<?php
include '../session.php';
if(isset($_GET['month']))
{
$months = $_GET['month'];
?>
<?php
$days = array();
$gross_sales = array();
$average_sales = array();
$type = CAL_GREGORIAN;
$month = date('n');
$year = date('Y');
$day_count = cal_days_in_month($type, $month, $year);
for ($i = 1; $i <= $day_count; $i++) {
$sql = "SELECT *, SUM(purchase_price) as purchase_price FROM ordered_items WHERE DAY(order_datetime) = '$i' AND MONTH(order_datetime) = MONTH('".$months."') AND YEAR(order_datetime) = YEAR('".$months."') AND order_status = 5 ";
$query = $conn->query($sql);
$total = $query->num_rows;
$row = $query->fetch_assoc();
if($row['purchase_price'] != 0)
{
$gross_sales[] = $row['purchase_price'];
}
else if ($row['purchase_price'] == 0 && $i <= date('d')) {
$gross_sales[] = 0;
}
$average_sales[] = $row['purchase_price'] / $day_count;
$day = $i.'/'.$month;
array_push($days, $day);
}
$days = json_encode($days);
$daily_gross_sales = json_encode($gross_sales);
$average_gross_sales = json_encode($average_sales);
?>
<script>
const colors = {
colorcode: {
fill: '#51cbce',
stroke: '#51cbce',
},
};
var ctx2 = document.getElementById("attChart").getContext("2d");
const attChart = new Chart(ctx2, {
type: 'line',
data: {
labels: <?php echo $days; ?>,
datasets: [{
label: "Gross Sales: RM",
fill: true,
pointBackgroundColor: colors.colorcode.stroke,
borderColor: colors.colorcode.stroke,
pointHighlightStroke: colors.colorcode.stroke,
borderCapStyle: 'dot',
pointRadius: 5,
pointHoverRadius: 5,
pointStyle: 'dot',
data: <?php echo $daily_gross_sales; ?>,
showLine: true
},
{
label: "Average Sales: RM",
fill: true,
pointBackgroundColor: '#FF0000',
borderColor: ' #FF0000 ',
pointHighlightStroke: '#FF0000',
borderCapStyle: 'dot',
pointRadius: 5,
pointHoverRadius: 5,
pointStyle: 'dot',
data: <?php echo $average_gross_sales; ?>,
showLine: true
}
]
}
<?php
}
?>
I do not know why my query from the loadchart.php is incorrect. Please help me with this advice me on this issue thanks!
$sql = "SELECT *, SUM(purchase_price) as purchase_price FROM ordered_items WHERE DAY(order_datetime) = '$i' AND MONTH(order_datetime) = MONTH('".$months."') AND YEAR(order_datetime) = YEAR('".$months."') AND order_status = 5 ";
Hi I have created a Database class that uses the singleton method. I have a query method within this class so i would call this to return an array of results. What i need to know is what would be the best way to use this returned array Database Class: Code: [Select] <?php class Database { private static $dbInstance; private $hostname; private $username; private $password; private $database; private function __construct() { $this->hostname = 'localhost'; $this->username = 'user'; $this->password = 'pass'; $this->database = 'test'; mysql_connect($this->hostname, $this->username, $this->password); mysql_select_db($this->database); } public static function getDBInstance() { if (!self::$dbInstance) { self::$dbInstance = new Database(); } return self::$dbInstance; } public function query($q) { return mysql_query($q); } } ?> Person Class: Code: [Select] <?php require_once('Database.php'); class person { public function getName($id) { $con = Database::getDBInstance(); $query = $con->query("select name from data where id = ".$id); $result = mysql_fetch_assoc($query); echo $result['name']; } } ?> Index page: Code: [Select] <?php require_once('person.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php $person = new person(); $person->getName(1); echo "<br />"; $person->getName(2); ?> </body> </html> Hi, I'm new to PHP/MySQL and need some help getting my query to work for my selection list: The selection list is built with: <form action='processformmissing.php' method='POST'> <fieldset> <legend>Choose Department</legend> <select name='depart'> <option value=''></option> <?php while ($row = mysqli_fetch_array($result)) { extract($row); echo "<option value='$department'>$department</option>\n"; } ?> </select> <p><input type='submit' value='Select Department' /></p> </fieldset> </form> The data is then sent to: $depart = $_POST['depart']; $deptlike = "%".$depart."%"; echo "<p>$depart</p>"; echo "<p>$deptlike</p>"; $query = "SELECT * FROM lifecerts INNER JOIN employees ON lifecerts.cid = employees.cid WHERE department LIKE '$deptlike' ORDER BY employees.name"; Hitting the submit button from my selection list form seems to be working fine because when I echo my data ($depart and $deptlike) it is giving me the correct value, but the query doesn't give me any results. However, if my post data comes from a text box instead of a selection list, my query works fine. Any thoughts on what I'm doing wrong??? Many thanks! Hello all, I have made the multi level marketing downline tree, but the problem with it now, it gives only the downline of one result, as the query gives 2 results what I want now is to make it give the downline of both results not just one, and it's always 2 results, not more here is my code Code: [Select] <?php $id = $_GET['id']; $result = mysql_query("SELECT id FROM users WHERE id = '".$id."' ORDER BY id"); $row = mysql_fetch_assoc($result); if ($row['id'] == 0) { echo" <table> <div id=\".piccenter\""; echo "<tr>"; echo "<img src=\"icon.gif\" border=0 align=\"center\">"; echo ""; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$row['id']."'"; echo ""; echo "</div>"; } } $result2 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$row['id']."'"); $rows2 = mysql_fetch_assoc($result2); foreach ($rows2 as $row2) { if ($row2['id'] == 0) { echo" <div id=\".picleft\"> <img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0 >"; echo "<br />"; echo "'".$row2['id']."'"; echo "</div>"; echo " <td>"; echo "</td> "; } } $result3 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows2['id']."'"); $row3 = mysql_fetch_assoc($result3); if ($row3['id'] == 0) { echo"<div id=\".picright\"> <img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$row3['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result4 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$row3['id']."'"); $rows4 = mysql_fetch_assoc($result4); if ($rows4['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows4['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result5 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows4['id']."'"); $rows5 = mysql_fetch_assoc($result5); if ($rows5['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows5['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result6 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows5['id']."'"); $rows6 = mysql_fetch_assoc($result6); if ($rows6['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows6['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result7 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows6['id']."'"); $rows7 = mysql_fetch_assoc($result7); if ($rows7['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows7['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result8 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows7['id']."'"); $rows8 = mysql_fetch_assoc($result8); if ($rows8['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows8['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> "; } $result9 = mysql_query("SELECT id FROM users WHERE recruiteris = '".$rows8['id']."'"); $rows9 = mysql_fetch_assoc($result9); if ($rows9['id'] == 0) { echo"<img src=\"icon.gif\" border=0 align=\"center\">"; } else { echo "<img src=\"images.png\" border=0>"; echo "<br />"; echo "'".$rows9['id']."'"; echo ""; echo " <tr> <td>"; echo "</td> </tr> </tbody> </table> "; } ?> hello all, I am using the following code to retrieve mysql data and show on my page.. Code: [Select] <?php include "dbconnect.php"; $link=dbconnect(); $result = mysql_query("SELECT * FROM playlist where date= '2011-09-06'") or die(mysql_error()); echo "<table width = 100% border = '0' cellspacing = '2' cellpadding = '0'>"; while ($friendList = mysql_fetch_array($result)) { echo "<tr>" . "<td><a href='memberindex.php?id = ".$friendList['id']."'><img src='".$friendList['image']."' title='".$friendList['artist']."' alt='".$friendList['album']."'/><br />".$friendList['album']."</a><br /></td> " . "</tr> "; } echo "</table> "; ?> this code retrieve image and album name from the table and display as below: id 1 image1 album1 id 2 image2 album2 id 3 image3 album3 but i want to display the info as below: id1-----------------id2---------------id3 image1------------image2-----------image3 album1------------album2-----------album3 i want image and album name of a product as column but other product as rows. I hope you understand. anyone can help me with this please? Hello, I know this should be pretty simple to figure out, but everything I try is giving me absolutely no results. I have a mysql query selecting columns from my database and returning results. I have the results printing out right now, so I can see that this part is working. All I want to do is take the results and put them into a table to display on my page. Basically, take what's in the database table and copy it to a table I can put on the web. FYI I am using sourcerer so the "connect" code is taken care of for me in the "JFactory" bit of code. Here is the first part of my code, selecting the information from the database. {source} <?php $db = JFactory::getDbo(); $query = $db -> getQuery(true); $query -> SELECT($db -> quoteName(array('first_dept_name', 'last_name', 'dept', 'position', 'phone_num'))); $query -> FROM ($db -> quoteName('#__custom_contacts')); $query -> ORDER ('first_dept_name DESC'); $query -> WHERE ($db -> quoteName('contact_category')."=".$db -> quote('YTown Employees')); $db -> setQuery($query); $results = $db -> loadObjectList(); print_r($results); Here is where I am trying to print the results into a table. I got this code directly from a PHP book, but I am getting nothing at all returned back to me. I get table headers, but no data. <?php echo "<table><tr><th>Name</th><th>Department</th></tr>"; while ($row = mysqli_fetch_array ($result)){ echo "<tr>"; echo "<td>".$row['last_name']."</td>"; echo "<td>".$row['dept']."</td>"; echo "</tr>"; } echo "</table>"; ?> {/source} I have a clothing store website which displays all my products with a price range of $0-$25 great on left side of my webpage with the count number beside it like so. Hi, I am new to the boards and php and mysql. I have created a database and can add entries via a form. I can query the database with another form and get the results to display in a table. All good so far as that is what I was hoping to achieve but one of the fields I want to display as a hyperlink but I am having problems with the syntax as I keep getting errors when I try to wrap the variables in <a href > tag. Code: [Select] <tr> <td><?php echo $fquery['prefix']; echo $fquery['website']; ?><?php echo $fquery['website']; ?></td> </tr> now that displays e.g. http://www.example.comwww.example.com. so I feel I am nearly there I just need advice as to how to construct a hyperlink from the fields queried. Hey all. I have a query that selects data from a datbase based on a criteria. Easy enough. But now I am growing and the amount displaying is too much. How can you, via php, have a queries result be displayed only so many at a time and auto create links that show the rest? Like if query returns 82 results, I want it to display 25 immediately and create 3 links at the bottom. The next link would show 26-50. The next 51-75. And the final 76-82. etc Example: Code: [Select] $result = mysql_query("SELECT * FROM pay"); $num_rows = mysql_num_rows($result); while($row = mysql_fetch_array($result)) { echo $row['first_name']; echo $row['last_name']; echo $row['item_name']; echo $row['option_selection1']; echo $row['payment_date']; echo $row['stat']; } This is simple. But what happens when the results are 125? I want to limit it to displaying 25 at a time. Is the only way to manually create seperate pages and have each one show 1-25, then 26-50, etc? Or is there a way to have the script do it, itself? Any tutorials out there on this specifically? Hopefully I am making sense. Thanks! I have a "Members" page that displays my organizations members info via My SQL. Currently, the database displays "State" quick links at the top and has the members organized by State down the page. If you click on one of the State links at the top, it will navigate to the section of the page with that state and associated members. I want the members associated with a specific state to be displayed only once I click the associated state link -- instead of all of the information showing at once like it is now. The page I am referring to can be seen at this link: http://homesforhorse...rs.com/members/
<?php
update_option('image_default_link_type','none');
include("/home/cingen/config_admin.php");
function listMembers() {
$sql = mysql_query("SELECT c.*, s.*
FROM (".TABLE_MEMBERS." c LEFT JOIN ".TABLE_STATE." s on c.state = s.state_abbr)
WHERE c. status = '1'
ORDER BY c.country, c.state, c.organization ASC");
while ($row = mysql_fetch_array($sql)) {
$display_members = false;
$organization = stripslashes($row['organization']);
$website = stripslashes($row['website']);
if ($website) {
$link = "<a href='http://".$website."' target='_blank'>";
$endlink = "</a>";
} else {
$link = "";
$endlink = "";
}
$display_members .= $link.$organization.$endlink."<br />";
if ($row['address']) $display_members .= stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />";
if ($row['city']) $display_members .= stripslashes($row['city']).", ";
if ($row['state']) $display_members .= stripslashes($row['state'])."";
if ($row['zip']) $display_members .= " ".$row['zip'];
$display_members .= "<br />";
if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
if ($row['contact_title']) $display_members .= ", ".stripslashes($row['contact_title']);
if ($row['phone']) $display_members .= "<br />Tel: ".stripslashes($row['phone']);
if ($row['email']) $display_members .= "<br />".$row['email'];
if ($row['website']) $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a><br/>";
if ($row['year_est']) $display_members .= "Founded in ".$row['year_est'].".";
if ($row['org501c3'] == "1") $display_members .= " A 501(c)3 non-profit.";
if ($row['gfas'] == "1") $display_members .= "<br />GFAS: Accredited Sanctuary.";
if ($row['gfas'] == "2") $display_members .= "<br />GFAS: Verified Sanctuary.";
if ($row['member_category']) $display_members .= "<br />".$row['member_category'];
$display_members .= "<br /><br />";
$entries[$row['country']][$row['state_name']][] = $display_members;
}
$countrylinks = false;
$statelinks = false;
$display = false;
if(is_array($entries)){
$display .= '
<div class="memberlist">';
foreach($entries as $country=>$state_members){
$countrylinks .= '<a href="#'.$country.'">'.$country.'</a> ';
$display .= '
<h2 id="'.$country.'">'.strtoupper($country).'</h2>
<div class="country">';
if(($state_members)){
foreach($state_members as $state=>$members){
$statelinks .= '<a href="#'.$state.'">'.$state.'</a> ';
$display .= '
<h3 id="'.$state.'">'.strtoupper($state).'</h3>
<div class="state">';
if(is_array($members)){
foreach($members as $key=>$member){
$display .= '
<div class="member">
'.$member.'
</div>';
}
}
$display .= '
</div>';
}
}
$display .= '
</div>';
}
$display .= '
</div>';
}
$statelinks1 = '
<h2>Members List</h2>
<strong>Quick Links</strong><br /><br />
'.$statelinks.'<br /><br />'
.$display;
return $statelinks1;
}
add_shortcode('memberlist', 'listMembers');
function listRescueStandards() {
$display_members = '';
$sql = mysql_query("SELECT vc.*, s.*, m.*
FROM ".TABLE_COMPLIANCE." vc, ".TABLE_STATE." s, ".TABLE_MEMBERS." m
WHERE vc.member_id = m.cid
AND m.status = '1'
AND m.state = s.state_abbr
ORDER BY m.state, m.organization ASC");
while ($row = mysql_fetch_array($sql)) {
$organization = stripslashes($row['organization']);
if ($row['website']) {
$link = "<a href='http://".$row['website']."' target='_blank'>";
$endlink = "</a>";
} else {
$link = "";
$endlink = "";
}
if($x!=$row['state_name']){
$display_members .= "<br /><strong>".strtoupper($row['state_name'])."</strong><br />";
$x = $row['state_name'];
}
$display_members .= $link.$organization.$endlink."<br />
".stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />
".stripslashes($row['city']).", ".stripslashes($row['state'])." ".$row['zip']."<br />";
if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
if ($row['contact_title']) $display_members .= ", ".stripslashes($row['contact_title']);
if ($row['phone']) $display_members .= "<br />Tel: ".stripslashes($row['phone']);
if ($row['fax']) $display_members .= "<br />Fax: ".stripslashes($row['fax']);
if ($row['email']) $display_members .= "<br />".$row['email'];
if ($row['website']) $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a>";
if ($row['year_est']) $display_members .= "<br />Founded in ".$row['year_est'].".";
if ($row['org501c3'] == "1") $display_members .= "<br />This organization IS registered with the IRS as a 501(c)3.";
if ($row['org501c3'] != "1") $display_members .= "<br />This organization is NOT registered with the IRS as a 501(c)3.";
$display_members .= "<br /><br />";
}
return "<div class='memberlist'>" . $display_members . "</div>";
}
add_shortcode('standardslist', 'listRescueStandards');
Hello all. I'm using this code to go through the database and output certain user-defined numbers Code: [Select] <?php mysql_connect ("pdb1.awardspace.com", "anastasov_db","moscow1945") or die (mysql_error()); mysql_select_db ("anastasov_db"); $term = $_POST['term']; $sql = mysql_query("select * FROM countries WHERE cocode = '$term'"); while ($row = mysql_fetch_array($sql)){ echo '<br/> Code: '.$row['cocode']; echo '<br/> Country: '.$row['coname']; echo '<br/><br/>'; } ?> Now how would I go about making a page that appears if the script can't find any results in the database? Thank you in advance
My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
The error messages I am getting a Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome. This is the query which should likes salestrack productid with printers productid, but even though there are data no result is showing and I really dont know why. Please help Code: [Select] SELECT salestrack.orderid AS orderid, salestrack.salesman AS salesman, printers.rrp AS price, salestrack.name AS name, salestrack.phone AS phone, salestrack.email AS email, printers.name AS printername, salestrack.orderdate AS orderdate, salestrack.status AS STATUS FROM printers, salestrack WHERE salestrack.productid = printers.productid AND salestrack.status = 'OPEN' ORDER BY salestrack.orderdate I am trying to create 3 columns of data from a query. I have used this code before for 2 columns but and now wanting to use for three columns.
There are 5 records from a join query. The first two columns display the results, 2 results in the left column and 3 results in the center column. The right column displayw empyt text used in displaying the results, there is no data to populate and it seems to mimic the the number from the center, 3.
Here is the URL to see the problem
http://specialslocat...ignID=1IBu3992p
Here is the Code for the query and the 3 column results.
<?php
$UN_URL = $_GET['un'];
$mS_MGMTcampaignID_URL = $_GET['mS_MGMTcampaignID'];
?>
<table width="944" border="1" align="center" cellpadding="0" cellspacing="0">
<?php
$result = mysql_query( "SELECT * FROM manager_Specials_company_mgmt MSCM LEFT JOIN b2c_coupons B2CC ON (MSCM.mS_MGMT_id = B2CC.m_primeID )WHERE mS_MGMTcampaignID = '$mS_MGMTcampaignID_URL' ORDER BY mS_MGMT_m_company ASC" );
$num_results = mysql_num_rows($result);
$numb_tb_rows= ceil($num_results/3)
?>
<?
if ( $numb_tb_rows > 0 ) {
?>
<tr >
<td colspan="4" valign="top" class="body_text_10_Center"><strong><?=$mS_campaignName_mS?> is proud to sponsor <?=$num_results?>
<?
if ( $num_results == 1 ) {
?>
company:</strong>
<?
} elseif ( $num_results > 1 ) {
?>
companies:</strong>
<?
}
?>
</td>
</tr>
<tr class="body_text_10_Center">
<!-- Column 1 -->
<td width="320" class="body_text_10_Center" valign="top">
<? // column #1
if($num_results>=1)
{
for($i=0; $i<$numb_tb_rows; $i++)
{
$row= mysql_fetch_array($result);
?>
<?php
if(!empty ($row["m_logo"])) {
?>
<div align="center">
<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
</div>
<?php
} else {
}
?>
<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
<?=stripslashes($row["b2c_m_address1"])?> <?=stripslashes($row["b2c_m_address2"])?><br />
<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
Phone: <?=stripslashes($row["b2c_m_phone"])?><br />
Fax: <?=stripslashes($row["b2c_m_fax"])?><br />
<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
Hours of Operation: <?=stripslashes($row["m_coupon_title"])?><br />
<?=stripslashes($row["m_coupon_desc"])?><br /><br />
<div align="center">
<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
<hr width="80%" size="1" />
</div><br /><br />
<? // END column #1
}
}
?>
</td>
<!-- Column 2 -->
<td width="320" class="body_text_10_Center" valign="top">
<? // column #2
if($num_results>=2)
{
for($i=($numb_tb_rows); $i<$num_results; $i++)
{
$row= mysql_fetch_array($result);
?>
<?php
if(!empty ($row["m_logo"])) {
?>
<div align="center">
<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
</div>
<?php
} else {
}
?>
<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
<?=stripslashes($row["b2c_m_address1"])?> <?=stripslashes($row["b2c_m_address2"])?><br />
<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
Phone: <?=stripslashes($row["b2c_m_phone"])?><br />
Fax: <?=stripslashes($row["b2c_m_fax"])?><br />
<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
Hours of Operation: <?=stripslashes($row["m_coupon_title"])?><br />
<?=stripslashes($row["m_coupon_desc"])?><br /><br />
<div align="center">
<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
<hr width="80%" size="1" />
</div><br /><br />
<? // END column #2
}
}
?>
</td>
<!-- Column 3 -->
<td width="320" class="body_text_10_Center" valign="top">
<? // column #3
if($num_results>=3)
{
for($i=($numb_tb_rows); $i<$num_results; $i++)
{
$row= mysql_fetch_array($result);
?>
<?php
if(!empty ($row["m_logo"])) {
?>
<div align="center">
<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
</div>
<?php
} else {
}
?>
<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
<?=stripslashes($row["b2c_m_address1"])?> <?=stripslashes($row["b2c_m_address2"])?><br />
<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
Phone: <?=stripslashes($row["b2c_m_phone"])?><br />
Fax: <?=stripslashes($row["b2c_m_fax"])?><br />
<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
Hours of Operation: <?=stripslashes($row["m_coupon_title"])?><br />
<?=stripslashes($row["m_coupon_desc"])?><br /><br />
<div align="center">
<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
<hr width="80%" size="1" />
</div><br /><br />
<? // END column #3
}
}
?>
</td>
</tr>
<?
} else {
echo "";
}
?>
</table>
Thanks for any help in advance.
Mike
I have no clue about to go abt this one: I have form which has some: Code: [Select] <table> <tr> <td> <form> Title display info </form> </td> </tr> </table> I need to add an additional link next to title such that when someone clicks on the link the table expands and displays rsult of a query. Code: [Select] <table> <tr> <td> <form> Title LINK if( link is clicked ) { $query=select display query results } else { dont display query results display info } </form> </td> </tr> </table> I have a 3-tables Good day and Merry Christmas to all, I just spent a good time of my christmas eve trying to figure out this problem. I hope one of you santas would be so kind as to help me with it. First off I have two tables; employee and employee_works both connected via employee_id key. Basically I have a parent window we'll call parent.php. inside the parent page is a search button that once clicked will open a child window we'll call child.php inside the child page is a list, lets say employees with name, employee_id, etc. My main concern is this: How do I populate parent.php based off the employee selection I made in the child window. Example: -Access parent.php -Click on search -Click on [ID: 004] [NAME: JOHN SMITH] [PHONE: 1233456] [DATE HIRED: JULY 16, 1992] <---format of a row in child.php -child.php automatically closes and parent.php now shows all data from employee_works with the employee_id = 004 Is this even possible? I know this is vary vague and would be willing to explain more if needed. My website is built mostly on javascript and php. In an .html, before : <!-- BEGIN myquery --> I need to stop output and check the content of "myquery" Is there a command for that ? Thank You. Say a user puts in a support request, and for every request it generates a unqiue string, and enters it into the database. Ok, now say there is a text field, when the user enters their unique string and it finds a match, it displays the data along with it. How can I accomplish this? Im kind of new to mysql, but I know basic SQL. Would be great if somebody could point me in the right direction! Thanks |
|||||||