PHP - Fetching Results From Two Tables

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

Hi there,    My friend asked me to help him perform a task today and I was completely stumped as to how I should complete it. Being someone who is reasonably experienced with PHP programming I didn't think I would find it absolutely impossible to complete, maybe hard, but not impossible. So I wondered if someone would now be able to explain to me in order to assist me in expanding my knowledge how to complete this task.    https://www.dropbox....B8M6cr_z7a?dl=0   Here is a link to the files he sent me, please ignore the C++ section.   If anyone could help / begin to give an explanation please fire away. I feel so bad about myself for NOT knowing that I'm now motivated to learn more!   Many thanks!

hello guys

i heard there is a way that you can make something like a database on a text editor and when ever u want to change the info you just open a text editor and change the information


How is this called? where can i find a tutorial? any tips? thanks you very much 

Hi,
I was wondering if any one can help me out with this little issue. I select some data, and put it on a while loop, so something like while($row = mysql_fetch_array($result)){ body }
but at the very last element in the array I'd like to something a little different than else.

So, i have 4 elements. For the first 3 I'd like to print element1, element2, element 3, element4
Notice the missing comma at element4

Hi ,

i am working on a PHP code that would fetch me the" title and the description" from another web page something similar to www.Digg.com .After searching a couple of Open source codes developed by some generous coder I found this piece of code:

I have tested this code and it works fine, but the confusion here is it only works from external internet and Iam not able to extract the contents when i use the same piece of code from my office intranet(Our intranet has full access to the internet ) and the best part is when i use the same url for fetching content from Digg.com from my office intranet it works fine.

The error I get is file_get_contents time out after 60 seconds
OR
I get a blank page result without any content

But the same piece of code when used outside of my intranet works perfectly fine.

Please let me know if you find anything incorrect!

Thanks

Code: [Select]
<?php

if(isset($_POST['submitlink'])) 
{
function getMetaTitle($content){
  $pattern = "|<[\s]*title[\s]*>([^<]+)<[\s]*/[\s]*title[\s]*>|Ui";
  if(preg_match($pattern, $content, $match))
return $match[1];
  else
return false;
}

$url = $_POST['submitlink'];

$data = array();

// get url title
$content = @file_get_contents($url);
$data['title'] = getMetaTitle($content);

// get url description from meta tag
$tags = @get_meta_tags($url);
$data['description'] = $tags['description'];

$dom = new domDocument;

@$dom->loadHTML($content);

$dom->preserveWhiteSpace = false;

$images = $dom->getElementsByTagName('img');

foreach($images as $img)
{
$imgurl = $img->getAttribute('src');       
$alt = $img->getAttribute('alt');
//$size = getimagesize($imgurl);
//echo "Title: $alt<br>";
//echo $imgurl;
//echo '<img src="'.$imgurl.'"  title="'.$alt.'" width="50px"/>';


}

$formdata .= '<table><tr><td>Title:</td><td><a href=';
$formdata .= 'gethome.php?url=';
$formdata .= $url;
$formdata .= '>';
$formdata .= json_encode($data['title']);
$formdata .= '</a></td></tr>';
$formdata .= '<tr><td>Description:</td><td> ';
$formdata .= json_encode($data['description']);
$formdata .= '</td></tr></table>';
}

Hello, iam almost done with my project .. except there is one more thing left which somehow i cant manage to figure it out....... i manged to make a proxy array which rotates proxies randomly on every try..... but i want for my users to be able to add them manually via the textarea... so they put their proxies and
as much as they want...... so then i guess explode should be used to fetch the proxies that were added by the user from the textarea and put them in an array like u see down and then with the curl array_rand it randomises them on evry try The real problem is i dnt know how to indetidy the explode cause iam not adding them manually they will be added via textare by users....... so when they add the ips they need to be fetched from the textare.
THNX IN ADVACE

$proxies = array(  
    '000.000.000.00:000',   <----------------- should i keep this ? cause ips will be added from textarea by users ?
    '000.000.000.00:000',  
    '000.000.000.00:000',  
    '000.000.000.00:000',  

);  
curl_setopt($ch, CURLOPT_PROXY,$proxies[array_rand($proxies)]);  <----- AFTER and array is made using exploit this will call it :)

<textarea cols='22' class='area' rows='14' name='proxies'>PROXIES</textarea><br><input type='submit' value='Test'><br></p><p align='center' dir='ltr'><b>  

Edited by madmike3, 20 August 2014 - 05:29 AM.

Hello,

I'm using pbb forum

http://xemix.pl/


When I tried to get topics using rss feeds module, I got this error.

Code: [Select]
Fatal error: Uncaught exception 'Exception' with message 'Erroe occured while loading url by cURL.
Couldn't resolve host 'pbboard.com'' in /home/a5402323/public_html/includes/FeedParser.php:226
Stack trace:
#0 /home/a5402323/public_html/includes/FeedParser.php(157): FeedParser->getUrlContent()
#1 /home/a5402323/public_html/modules/admin/feeder.module.php(218): FeedParser->parse('http://absba.or...')
#2 /home/a5402323/public_html/modules/admin/feeder.module.php(49): PowerBBFeederMOD->_AddFeedStart()
#3 /home/a5402323/public_html/admin.php(89): PowerBBFeederMOD->run()
#4 {main} thrown in /home/a5402323/public_html/includes/FeedParser.php on line 226
the host said thet

Hello,cURL is installed by default here Many Thanks,Helpdesk Staff


any help !!!!

my current code for getting a page is
<?php 
$page = $_GET['page'];  //Gets the (page=) from the URL
   if($page){  
   $site = file_exists($page.'.html') ? $page.'.html' : 'home.html';}
   else{
   $site = 'home.html'; // Else include the default home.php file.       
   }
   include($site);
?>

the problem with it is it only checks for html pages.
I would like to have it check for html then php pages and it pull up whichever is valid.

i tried to do it myself but im a php n00b. pls help
         <?php 
$page = $_GET['page'];  //Gets the (page=) from the URL
   if($page){  
   $site = file_exists($page.'.html') ? $page.'.html' : 'home.html';}
   elseif
   $site = file_exists($page.'.php') ? $page.'.php' : 'home.html';
else{$site = 'home.html'; // Else include the default home.php file.       
   }
   include($site);
?>

^^ is what i did. any help will be appreciated. Thanks

Hi guys,
I am using a search form that's supposed to pull data out of database and display them. I managed to to do that using the following:

while($rows = mysql_fetch_assoc($result))
{

echo "-Title: " . $rows['title'] . "<br/>" . "-Author: " . $rows['author'] . "<br />";

Displays something like this:
-Title: Young One
-Author: Edwards Bonnie.
----------------------------------

I have links related to each book in a folder and I want to make the title clickable and each title should take me to the corresponding book page.

I know that I have to do something like <a href=\"...........\">$rows['title']</a>", but as far as I know all titles will take me to one page using that! please help and thank you.

Hello
I have the following code
Code: [Select]
<?php


// STORE DATABASE VARIABLES
$hostname_cnConnection = "localhost";
$database_cnConnection = "tekou";
$username_cnConnection = "root";
$password_cnConnection = "1234";
$cnConnection = mysql_pconnect($hostname_cnConnection, $username_cnConnection, $password_cnConnection);
mysql_set_charset('utf8',$cnConnection);
// CONNECT TO DATABASE
mysql_select_db($database_cnConnection, $cnConnection);


$data = mysql_query("SELECT * from jos_users") 
 
 or die(mysql_error()); 
// Print "<table border cellpadding=3>"; 
 while($info = mysql_fetch_array( $data )) 
 { 
 // echo $info['id'];
  $prod_id=$info['id'] ;
//  echo "Product ID " .$prod_id; //Show Product Id
  
mysql_query("UPDATE jos_vm_user_info SET first_name = '".$info['name']." WHERE user_id = ".$info['id']) or die(mysql_error());  


  }
echo $info['id'];
 
?>

I want to read every $name and update in jos_vm_user_info the first_name but I think I have error in code because nothing happens.
I quess that .$info['id'] doesnt return a single number but all numbers but I dont know how to fix it.
Please someone to help me.

Hi,   I am working on coupon script which generate coupon.   The coupon script have two types, one is redemption and second one is printable in the same process it send sms to customer.   But issue is when it send SMS, sometime SMS works nice and lots of time SMS content got missing. I could not understand why it happening. Is it scripting issue or another?   The script code as below:   ---------------------------------------------------------------------------------------------------------- //Send coupon code to customer by SMS                         $smsparameters = "select * from cs_options where option_id in ('23','24','25','26')";                         if(!($smsparametersresult = mysql_query($smsparameters))) { echo $smsparameters.mysql_error(); exit; }                         while($smsparametersrow = mysql_fetch_array($smsparametersresult)) {                                     $smsparametersarray[] = $smsparametersrow['option_value'];                         }                                                          define('SMS_SERVICE_URL', $smsparametersarray[0]);                         define('KEY', $smsparametersarray[1]);                         define('USERNAME', $smsparametersarray[2]);                         define('PASSWORD', $smsparametersarray[3]);                                                                                           $automationquery = "select * from cs_automation where automation_id='6'";                         if(!($automationresult = mysql_query($automationquery))) { echo $automationquery.mysql_error(); exit; }                         $automationrow = mysql_fetch_array($automationresult);                         $automationrow['automation_value'];                         if($automationrow['automation_value']=='1') {                                                                                     $sms_order_id = $_SESSION['new_order_id'];                                                        $current_date = date('Y-m-d');                                                                       $smsquery = "select * from cs_order as ord left join cs_customer as cust on ord.order_user_id = cust.customer_id where ord.order_id = '$sms_order_id'";                                     if(!($smsresult = mysql_query($smsquery))) { echo $smsquery.mysql_error(); exit; }                                                                        $sms_items = mysql_fetch_assoc($smsresult);                                                                         $order_coupon_id4 = explode(", ", $customer_email_items['order_coupon_id']);                                                                                                                                                    foreach($order_coupon_id4 as $coup_id) {                                                 $coupon_id = $coup_id['order_coupon_id'];                                                 $query = "select * from cs_coupons as coup inner join cs_company as comp on coup.coupons_store = comp.retailer_id inner join cs_payments_currency as curr on coup.coupons_currency_id = curr.currency_id inner join cs_countries as cont on comp.country = cont.country_id inner join cs_states as stat on comp.state = stat.state_id inner join cs_cities as citi on comp.city = citi.city_id inner join cs_area as aria on comp.local_area = aria.area_id where coup.coupons_id = '$coupon_id'";                                                                                                 if(!($result = mysql_query($query))) { echo $query.mysql_error(); exit; }                                                 $coupon = mysql_fetch_array($result);                                                                                                 $coup_name = $coupon['coupons_name'];                                                 $coup_code = $coupon['coupons_code'];                                                 $custdiscount = $coupon['coupons_product_discount'];                                                 $coup_valid_date = date("d-m-Y", strtotime($coupon['coupons_exp_date']));                                                                                                                                                                                                             $couponcodeforsms = $sms_items['order_coupon_code'];                                                 $couponcodeforsms1 = explode(", ", $sms_items['order_coupon_code']);                                                                                                                                                    $smscount = count($couponcodeforsms1);                                                                                                 $mobilenoforsms = $sms_items['customer_mobile'];                                                 $custnameforsms = ucwords($sms_items['customer_fname']);                                                 $company_name = $coupon['company_name'];                                                         $company_address = $coupon['city_name'];                                                                                                 $ch=curl_init();                                                                                                                                   curl_setopt($ch, CURLOPT_URL, "".SMS_SERVICE_URL."?user=".USERNAME."&password=".PASSWORD."&phone=".urlencode($mobilenoforsms)."&text=".urlencode('Hi '.$custnameforsms.', Coupon from CrackMyDeal : '.$coup_code.', '.$custdiscount.'% off on '.$coup_name.' at '.$company_name.', '.$company_address.', Valid till '.$coup_valid_date.'. T&C Apply.')."&type=t&senderid=".KEY."");                                                                                                 curl_setopt($ch, CURLOPT_HEADER, 0);                                                 curl_exec($ch);                                                 curl_close($ch);                                     }                         }     ----------------------------------------------------------------------------------------------------------------     The SMS which works nice:   Hi Paresh, Coupon from CrackMyDeal : CRACKD2014, 20% off on WebHosting (Business) at Unique InfoTech, Kamothe, Valid till 31-12-2014. T&C Apply.   -------------------------------------------------------------------------------------------------------------- And missing content SMS :   Hi Paresh, Coupon from CrackMyDeal : , % off on at , , Valid till 01-01-1970. T&C Apply. --------------------------------------------------------------------------------------------------------------

ok i display description from database with no isue but the thing is if there are links in description even the links like http://somesite.com shows as normal text on browser. how can i make them clickable?

Hi,

I am trying to migrate my project from mysql to mysqli but with little knowledge of the later.

Among the noticeable errors is that the code is no longer fetching data from the database, and I am also getting UNDEFINED VARIABLE errors on the in the mysqli statement that should be binding results to variables.

Here is the code if you can help:

//set connection variables
$host = "localhost";
$username = "root";
$password = "password";
$db_name = "mydb"; //database name

//connect to mysql server
$mysqli = new mysqli($host, $username, $password, $db_name);

//check if any connection error was encountered
if(mysqli_connect_errno()) {
    echo "Error: Could not connect to database.";
    exit;
}

//Just counting ...required for pagination...
$query = "SELECT COUNT(*) FROM t_persons";

$result = mysqli_query($mysqli,$query) or die(mysqli_connect_errno());
$num_rows = mysqli_fetch_row($result);


$pages = new Paginator;
$pages->items_total = $num_rows[0];
$pages->mid_range = 9; // Number of pages to display. Must be odd and > 3
$pages->paginate();

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
    
    if ($stmt = $mysqli->prepare("SELECT p.PersonID,
                p.ImagePath,
                p.FamilyName,
                p.FirstName,
                p.OtherNames,
                p.Gender,
                p.CountryID,
                p.StatusID,
                i.IncidentDate,
                i.IncidentCountryID,
                i.AgencyID,
                i.KeywordID
 
FROM t_incidents i
INNER JOIN
  t_incident_persons ip ON ip.IncidentID = i.IncidentID
INNER JOIN
  t_persons p ON ip.PersonID = p.PersonID    

WHERE p.PersonID>0" . $likes . " ORDER BY p.PersonID DESC $pages->limit")) {    
    
    /* Execute the prepared Statement */
    $stmt->execute();
    
    /* Bind results to variables */
    $stmt->bind_result($PersonID,$ImagePath,$FamilyName,$FirstName,$OtherNames,$Gender,$CountryID,$StatusID,$IncidentDate,$IncidentCountryID,$AgencyID,$KeywordID);
    
    /* fetch values */
    while ($rows = $stmt->fetch()) {
     // display records in a table

//    $PersonID=$row[0];
?>
    <div class="thumbnail">
<a href=details.php?PersonID=<?php echo $PersonID ?> target=gallery><img src="./Persons_Images/<?php echo $row[1]; ?>" width="100" height="130" alt="" /></a><br>
<a href="details.php?PersonID=<?php echo $PersonID; ?>"> <?php echo $row[2]; ?> <?php echo $row[3]; ?></a>
</div>

  <?php }?>

<?php
    }

    /* Close the statement */
    $stmt->close();


/* close our connection */
$mysqli->close();
?>               

I will appreciate.   Joseph    

Hi,

I am trying to fetch a file with function file_get_contents() from a website, but am getting following error.

[function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.0 403 Forbidden in /data/22/1/27/17/1842180/user/1999295/htdocs/web/modules/index.php on line 14.

using following code,

Code: [Select]
$content = file_get_contents($source);

$handle = fopen($destination, 'wb');
fwrite($handle, $content);
fclose($handle);
does it have something to with http header, which might be required to set as HTTP/1.1 in php

Regards,
Abhishek

I have made an autocomplete form... originally the values were static:


$aUsers = array(
      "Adams, Egbert",
      "Altman, Alisha",
      "Archibald, Janna",
   );


Now I want the values from a database table DEVICES row name DeviceName:


$sql = "SELECT DeviceName FROM DEVICES";
$res = mysql_query($sql);

$aUsers = array();
while ($row = mysql_fetch_assoc($res)) {
       $aUsers[] = $row;
}


It will not display the values in my autocomplete form when text is entered.... but with static data it will. Im confused!

Thank you