PHP - This Is Strange. Google Showing All The H2 Tags In Search Results.

Hi there i have an array that catches all appropriate records from my database and selects a random row which is then outputted as a hyperlink.

Code: [Select]
$colname_Class3 = "3";
$colname_Ships3 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships3 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships3 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships3, "text"),
GetSQLValueString($colname_Class3, "int"));
$Ships3 = mysql_query($query_Ships3, $swb) or die(mysql_error());
$totalRows_Ships3 = mysql_num_rows($Ships3);

$count = 0;
while ($row = mysql_fetch_assoc($Ships3)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total3 = count($array3);
$random3 = rand(0,$total3 - 1);
$random_ship3 = $array3[$random3];
$ShipID3 = $random_ship3['ShipID'];
$url3 = '<a href="add_ship.php?recordID='.$ShipID3.'">Test3</a>';
echo '<span style="color: #009900">';
echo $url3;}

This all worked fine until i added another similar query:
Code: [Select]
$colname_Class4 = "4";
$colname_Ships4 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships4 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships4 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships4, "text"),
GetSQLValueString($colname_Class4, "int"));
$Ships4 = mysql_query($query_Ships4, $swb) or die(mysql_error());
$totalRows_Ships4 = mysql_num_rows($Ships4);

$count = 0;
while ($row = mysql_fetch_assoc($Ships4)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total4 = count($array4);
$random4 = rand(0,$total4 - 1);
$random_ship4 = $array4[$random4];
$ShipID4 = $random_ship4['ShipID'];
$url4 = '<a href="add_ship.php?recordID='.$ShipID4.'">Test4</a>';
echo $url4;}

On first look it seems fine, however once the page is refreshed the parsed recordID's both become the same number,
e.g: Test3 recordID 8 Test4 recordID 24
then after refreshed: Test3 recordID 24 Test4 recordID 24

Is there anything wrong with my code??

Thanks

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=325313.0

I am working on building a code that will check the results returned from and xml pull to see if they match the database and print back pass or fail on the screen, it works for the first result but then fails to display anything else. any help on where I went wrong would be helpful.

Code: [Select]
<?php
function pass($name, $level)
{
$sql1 = "SELECT * FROM `reqskills` WHERE `level` > 0 and `name` = '$name'";
$result1 = mysql_query($sql1);
while($row1 = mysql_fetch_array($result1))
{
if($level >= $row1['level'])
{
echo "Pass";
}
Else
{
echo "Fail";
}
}
}

$API = "address removed";
$xml = simplexml_load_file($API);
$sql = "SELECT * FROM `reqskills` WHERE `level` > 0";
$result = mysql_query($sql);
echo "<table width=100%";
echo "<tr><td>Skill</td><td>Level</td><td>Pass</td></tr>";
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td><?php echo $row['name'] ?></td>
<td><?php echo $row['level'] ?></td>
<td><?php 
foreach ($xml->result->rowset[0] as $value)
{
$typeID = $value['typeID'];
$sql = "select * from `invTypes` WHERE `typeID` = $typeID";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
echo pass($row['typeName'],$value['level']); 
}}

echo "</td></tr>";

}
echo"</table>";
?>

I am trying to work out how to work out rank on google results.

I so far have the results of the first page however can not work out how to get to the next page.

<?php
function google_search_api($args, $referer = 'google.php', $endpoint = 'web'){
$url = "http://ajax.googleapis.com/ajax/services/search/".$endpoint;
 
if ( !array_key_exists('v', $args) )
$args['v'] = '1.0';
 
$url .= '?'.http_build_query($args, '', '&');
 
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// note that the referer *must* be set
curl_setopt($ch, CURLOPT_REFERER, $referer);
$body = curl_exec($ch);
curl_close($ch);
//decode and return the response
return json_decode($body);
}
 
$rez = google_search_api(array(
'q' => 'test',
 ));
 
print_r($rez);

?>

Now I working off the http://code.google.com/intl/en/apis/ajaxsearch/documentation/reference.html#_class_GSearch

What I am trying to do is build is http://www.further.co.uk/tools/search-position-check/

I am almost there with doing it with bing results

function bingrank($keyword,$domain){
$rank = '0';
$urls = array();
for($i=0;$i<10;$i++){
$rn=$i=='0'?'':$i;
$query = "http://www.bing.co.uk/search?q=".urlencode($keyword)."&first=".$rn."1";
$result_page = file_get_contents($query);
preg_match_all('/class="sb_tlst"><h3><a href="(.*?)"/',$result_page,$matches);
foreach($matches[1] AS $url){
$urlst = str_replace('www.', "", preg_replace('(^http://|/$)','',$url));
$urlsz = explode("/", $urlst);
$urls[] = $urlsz[0];
if ($urlsz[0] == $domain){
return $i+1;
}
}
}
return 'N/F';
}

Any advice or help would be great.

Hi,   Total PHP noob, obviously.   I want some form submission results to be in bold text. So I have:  

$open = echo htmlentities("<strong>");
$close = echo htmlentities("</strong>");
$message .= 'Cushion Refilling Service: ' . $open . $_POST['cushion-refilling'] . $close . "\n\n";

  How should I be doing this?   Thanks

Richard

Code: [Select]
if (isset($_POST['update']))
{
$signature = $_POST['signature'];
$type = $_POST['type'];
$name = $_POST['name'];
$b=0;
While ($b < $i)
{
echo $signature[$b]."<br>";
echo $type[$b]."<br>";
echo $name[$b]."<br><br>";
$b++;
}}
I did echo '<pre>';
print_r($_POST);
echo '</pre>';

The results are
Code: [Select]
Array
(
    [sname] =>
    [notes] =>
    [signature] => Array
        (
            [0] => 1-1
            [1] => 1-2
            [2] => 1-3
        )

    [type] => Array
        (
            [0] => Test1
            [1] => Test2
            [2] => Test3
        )

    [name] => Array
        (
            [0] => Testa
            [1] => Testb
            [2] => Testc
        )

    [update] => Update
)

But for some reason nothing is showing up on the screen.

Does anybody know how to show the below php results in a table format?

<?php

if(isset($_POST['submit'])){
if(isset($_GET['go'])){

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$skill = $_POST['skill'];
   
//connect  to the database
$db=mysql_connect  ("127.0.0.1", "root",  "") or die ('I cannot connect to the database  because: ' . mysql_error());
   
//select  the database to use
 $mydb=mysql_select_db("resource matrix");
   

//query  the database table
$sql="SELECT DISTINCT First_Name, Last_Name, l.Resource_ID FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE First_Name LIKE '$fname' OR Last_Name LIKE '$lname' OR Skill_Name LIKE '$skill'";
   
//run  the query against the mysql query function
$result=mysql_query($sql);
   
//create  while loop and loop through result set
while($row=mysql_fetch_array($result)){
$First_Name  =$row['First_Name'];
$Last_Name=$row['Last_Name'];
$Resource_ID=$row['Resource_ID'];
   
//display the result of the array
echo "<ul>\n";
echo "<li>" . "<a  href=\"a.php?id=$Resource_ID\">"   .$First_Name . " " . $Last_Name .  "</a></li>\n";
echo "</ul>";
}
}
else{
echo  "<p>Please enter a search query</p>";

}
}

Hi there, 

So the below code is working for 1 entry, however there is 2 entries in the database which are different postcodes and I cannot get to show in Google Maps. When I do it without Mysql and just do it direct it works, but really want to do it from MYSQL - both postcodes are valid and tested as well.

 

<?php
$sql4 = "SELECT * FROM MK_migration_details";
$result4 = $conn->query($sql4);
?>


function initialize() {
        geocoder = new google.maps.Geocoder();
        var latlng = new google.maps.LatLng(40.768505,-111.853244);
        var myOptions = {
			mapTypeControl: false,
			fullscreenControlOptions: false,
			zoom: 8,
            center: latlng,
            mapTypeId: google.maps.MapTypeId.ROADMAP
			        }
        
		map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
   <?php     
		while($row4 = $result4->fetch_assoc()) {
  
			$mig_postcode = $row4["postcode"];	
				
		}		
				echo 'addPostCode("'.$mig_postcode.'")';
				
?>
   
	}
	

I know the issue lies with the PHP / Mysql Loop and the Javascript element 'addpostcode' when I put into the loop does not work, but works for a single address outside the loop.

 

Really appreciate your help guys!

 

Thanks you

Hi   I have 2 tables that I am searching infor for. One holds the phone info and the other the repairs that are available.   I have the code below and it displays on the webpage in a table for the phone information and then another table the repairs but they seem to be separate tables and headers. inbetween them is the phone and the details which separates the repairs but its not in a table.   Hopefully the code below will explain better.   What I would like it the phone details in one table and then a table full of all the repairs (I am not bothered about a new heading for each repair).

$result = mysql_query("SELECT * FROM phone, phonerepairs WHERE phone.model_no='".$_POST['model']."' AND phone.phone = phonerepairs.phone");

while($row = mysql_fetch_array($result))
{
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['model_no'].'</td>';
echo '<td width="130" align="center">'.$row['model'].'</td>';
echo '<td width="50" align="center">'.$row['year'].'</td>';
echo '<td width="150" align="center">'.$row['capacity'].'</td>';
echo '</tr>';
echo '</table><br>';
echo '</p>';
echo '<p>';
echo '<div id="pageheading"><h3><div id="title">Repairs we carry out for '.$row['model'].'</div></h3></div>';
echo '<table width="99%" cellpadding="5" cellspacing="0" border="1">';
echo '</p>';
echo '<p>';
echo '<tr>';
echo '<td align="center"><strong>Image</strong></td>';
echo '<td align="center"><strong>Fault</strong></td>';
echo '<td align="center"><strong>Repair</strong></td>';
echo '<td align="center"><strong>Cost</strong></td>';
echo '</tr>';
echo '<tr>';
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['fault'].'</td>';
echo '<td width="130" align="center">'.$row['description'].'</td>';
echo '<td width="50" align="center">&pound'.$row['cost'].'</td>';
echo '</tr>';
echo '</table><br>';

Thanks in advance    Martyn

I am writing a CRON job that will execute daily.  First it will identify from a MySql table the date in a field 'FAPforSale_repost35'  If the date is the today date it will then execute commands to delete photo images in a directory, delete the directory, and finally remove the record from the database.   I am on step one which is to build the array of records that match the days date.  When I run the code, there are no errors but I am not getting results even though the records in the test table are set for today.  Below is the select

<?php

 define( "DIR", "../zabp_employee_benefits_processor_filesSm/", true );
 
 require( '../zipconfig.php' );
 require( DIR . 'lib/db.class.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/configRecognition.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/libRecognition/MailClass.inc' );
 
 
 
$todayRepost35 = date("Y-m-d");
echo $todayRepost35;



function repostEndSelect()
 
      {
        
        global $db;
            
    $this->db = $db;
        
            
     $data = $this->db->searchQuery( "SELECT `FAPforSale_IDnumber`,  `FAPforSale_image1`,  `FAPforSale_image2`,  `FAPforSale_image3`,  `FAPforSale_repost35`  FROM  `FAP_forSaleTest` Where `FAPforSale_repost35` = '$todayRepost35' ");
    
    
         $this->FAPforSale_IDnumber = $data[0]['FAPforSale_IDnumber'];
        $this->FAPforSale_image1 = $data[0]['FAPforSale_image1'];
        $this->FAPforSale_image2 = $data[0]['FAPforSale_image2'];
        $this->FAPforSale_image3 = $data[0]['FAPforSale_image3'];
        $this->FAPforSale_repost35 = $data[0]['FAPforSale_repost35'];
        
        echo $this->FAPforSale_IDnumber;
        echo $this->FAPforSale_image1;
        echo $this->FAPforSale_image2;
        echo $this->FAPforSale_image3;
        echo $this->FAPforSale_repost35;
        
    } // ends function...
        
echo( ' Finished...' );

?>

Thanks in advance for any suggestions or direction.  Chapter two will be when I start testing the commands to delete.

So I have 2 queries, that has the potential to return alot of data, foreach loops running. The first shows each group heading, and the foreach nested is calling another query specific to the group heading. The result currently is a lengthy delay in results showing. (Now this may/may not be the most ideal code practise in this instance however... short term solution discussion please).

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
   Next
Next

Is there a command or other where I can say, Display HTML page as it stands while it continues to process the FOREACH loops?

EG:

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
      REFRESH HTML DISPLAYED
   Next
Next

Hi people.

I am creating a carpet website for a good friend of mine as a favour.  I am storing the carpets info in a MYSQL database and am currently trying to relay the info on a page.  I have the array kind of done but it is not producing the results I want.  Let me explain further:

The columns in my database under the table "carpets" a

id (auto incremented)
colour
type
title
price
description
imageloc

------

under the type I have various types of carpet (6-ish).  They a Twist, Striped etc etc...

Heres the php problem.


I have all the images there and ready on the page and want to link them all with linking commands. i.e:

the main page is at: http://www.ircdirect.co.uk/FTPServers/supremecarpets/index.php

the carpets results page is at: http://www.ircdirect.co.uk/FTPServers/supremecarpets/carpetlist.php

on the index.php page I want to link them so that for example:

If he looks for a striped carpet he clicks "striped" and is shows carpetlist.php but with the striped carpets displayed.

example link: <A HREF="carpetlist.php?type=striped">IMAGE HERE</A>

I have tried various coding on the carpetlist.php and cant seem to get it to work.

here is the snippets:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM carpets GROUP BY type"; 
 
$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){


echo "<TABLE CELLPADDING=0 CELLSPACING=0 WIDTH=100% />";

echo "<TR />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/topleft.png /></TD />";

echo "<TD BACKGROUND=images/main/search/top.png /> </TD />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/topright.png /></TD />";

echo "</TR />";

echo "<TR />";

echo "<TD BACKGROUND=images/main/search/left.png />";
echo " ";
echo "</TD />";

echo "<TD BACKGROUND=images/main/search/bg.png />";

echo "<FONT FACE=VERDANA SIZE=1 />";
echo $row['title'];

echo "</TD />";

echo "<TD BACKGROUND=images/main/search/right.png />";

echo " ";

echo "</TD />";

echo "</TR />";

echo "<TR />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/bottomleft.png /></TD />";

echo "<TD BACKGROUND=images/main/search/top.png /> </TD />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/bottomright.png /></TD />";

echo "</TR />";

echo "</TABLE />";

echo "<BR />";

}
?>

It displays ALL the results which is not what I want.  I want only striped carpets, blue carpets etc....

Help is needed and VERY much appreciated!

Kind Regards,
Ian

i have built pages that paginate with 10 rows per page (some pages show more but for the moment i want to focus on this particular page)

//Define Some Options for Pagination
$num_rec_per_page=10;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page;

$results = mysql_query("SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name) LIMIT $start_from, $num_rec_per_page") or die(mysql_error());

	$results_array = array();
	while ($row = mysql_fetch_array($results)) {
    	$results_array[$row['characterID']] = $row;
}

The above sets the variables for the pagination and below the results are echo with 10 rows per page   then i show the pagination links:

<?php 
$sql = "SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name)";

$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 
?>


      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="center"><div style="width:100%; text-align:center;">
          <ul class="pagination">
    <li class="selected">
	<?php
echo "<a href='capitalmember.php?page=1'>".'«'."</a> ";?> 
</li>
<?
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<li><a href='capitalmember.php?page=".$i."'>".$i."</a></li> "; 
};
?>
<li class="selected">
<? 
echo "<a href='capitalmember.php?page=$total_pages'>".'»'."</a> "; // Goto last page
?></li>
  </ul></div>
    <?php
  $pageNr = $page;   // Get Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  // 3 * 10 = 30
$to = $from + $rowsPerPage;      // 30 + 10 = 40
echo $pageNr;
/* Result: From page 30 to 40 */
  ?></td>
        </tr>
      </table>

this works great and shows me 10 results per page,   what i need to work out and work on next is:   echo the number of results above the records (for example: "showing records 1 to 10" and then on page 2 "showing records 11 to 21" and page 3 "showing records 22 to 32"   how can i work out the maths for this echo?   i was thinking along the lines of;

    <?php
$pageNr = $page;   // Gets Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  
$to = $from + $rowsPerPage;      // 30 + 10 = 40
// Now Show Results
echo $from; // Echo from
echo $to // Echo to
  ?>

but i'm still working on this..   then i need to look at shortening the amount of page links on the page if for example i have 500 records it shows me links 1 to 50 and eats up the page....   Appreciate any help and light onto my problems.   Many thanks
Edited by jacko_162, 11 January 2015 - 05:43 PM.

I was wondering how does one go about showing results from SELECT query in columns in a html table.

I have a list of products in a table, and would like to show them on the page in 4 columns. I have done many searches on google to try and find the sulution, but the majority of what im finding instead is about displaying a table from phpmyadmin as a table in html.

If its a large operation to do this, I would be very happy if someone could poiint me in the direction of a tutorial maybe.

Here is the code I have so far to display the products, but for some reason, it only show 1 row instead of all the rows from my table.

Code: [Select]
<?php

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "dbname";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM mcproducts");
while($row = mysql_fetch_array($result))
 {
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];

 }

?>
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
  $flagicon = "<img src=\"flags/ireland.jpg\">";
  }
  
  elseif ($flagicon=="UK") {
  $flagicon = "<img src=\"flags/uk.jpg\">";
  }  else
  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol ?> <?php echo $price ?></div>
                </div>
              </div>
             
</body>
</html>


Many thanks,

DB