PHP - Help: Simple_html_dom.php Select First Table Row Only

hello dear php-experts,

i fairly new to simple_html_dom usage and methods. I know a little the parser,
 
i want to gather some information from this site:

https://europa.eu/youth/volunteering/organisations_en#open

is this possible to get the content - of let us say 10 or 20 last records on that page - and subesquently to store it in my mysql - db!?

<?php
// Report all PHP errors (see changelog)
error_reporting(E_ALL);

include('inc/simple_html_dom.php');

    //base url
    $base = 'https://europa.eu/youth/volunteering/organisations_en#open';

    //home page HTML
    $html_base = file_get_html( $base );

    //get all category links
    foreach($html_base->find('a') as $element) {
        echo "<pre>";
        print_r( $element->href );
        echo "</pre>";
    }

    $html_base->clear(); 
    unset($html_base);

?>

 

I have the above code and I'm trying to get certain elements of the page but it isn't returning anything. 

 

Is it possible that certain PHP functions might be disabled on the server to stop that?

The above code works perfectly on other sites.

 

Is there any workaround?

 

 

btw:  i have created a small snipped as a proof of concept to run this with Python and BeautifulSoup - 

 

import requests
from bs4 import BeautifulSoup
 
url = 'https://europa.eu/youth/volunteering/organisations_en#open'
response = requests.get(url)
soup = BeautifulSoup(response.content, 'lxml')
print(soup.find('title').text)
block = soup.find('div', class_="eyp-card block-is-flex")

 

and this.... 

 

European Youth Portal
>>> block.a
<a href="/youth/volunteering/organisation/48592_en" target="_blank">"Academy for Peace and Development" Union</a>
>>> block.a.text
'"Academy for Peace and Development" Union'
 
>>> block.select_one('div > div > p:nth-child(9)')
<p><strong>PIC:</strong> 948417016</p>
>>> block.select_one('div > div > p:nth-child(9)').text
'PIC: 948417016'

 

what is aimed in the end - i want to gather the first 20 results of the page - and put them in to a sql-db or alternatively show the information in a little widget 

HI , newbie here !

I have 4 tables ( event, price, vehicle, town)

I want to select from a database when a user chooses the town, event and number of passengers (which I have got the form working ok)

when displaying results I can get it to retrieve the $town and $event details fine,I  just need  the vehicleID column in the vehicle table to match the price.vehicleID when it is equal to $pax



$calc = ("
       SELECT* FROM price, vehicle WHERE price.townID = $town AND price.eventID = $event AND $pax == vehicle.passenger AND price.vehicleID = vehicle.vehicleID
       ");

if you have a look at www.hirealimo.com.au you will see what m trying to do.

thanks in advance

$sql = "SELECT sum(tbl1.number) FROM tbl1, tbl2";

it only works if i have one table when i add the second it doesnt work. i just need the sum in one column from one table i just need other info from the other table too it wont work tho. im getting an entirely different number for the sum.

Hi,

I'm a little bit new to php and I'm having some issues selecting some data from a mySQL database and fetching it into a fluid html table.....


Basicly what I want is a table with 4 columns and a X number of rows depending on how much entry is stored in the DB.

Here's the SELECT code :

Code: [Select]
<?php 

mysql_connect("host", "user", "pass") or die(mysql_error()); 
mysql_select_db("DB") or die(mysql_error()); 

$id = $_GET['id'];

$data = mysql_query("SELECT * FROM artist_gallery WHERE artist_picid='$id'") 
or die(mysql_error());

while($info = mysql_fetch_array( $data ))

     {

Here the part I just can't figure.... what I want is to fetch the x number of picture in the DB into a html table :

Code: [Select]
echo "
<table border=\"1\" cellpadding=\"1\" cellspacing=\"0\">
<tr>
 <td><img src=\"".$info['picture']."\" border=\"0\" /></td>
 <td><img src=\"".$info['picture']."\" border=\"0\" /></td>
 <td><img src=\"".$info['picture']."\" border=\"0\" /></td>
</tr>
</table>
    ";
    }

?>

The pictures are just repeating 3 times at each row...

Any help will be greatly appreciated!!!


Thanks!

Hi,

I would like to do the following in PHP using a MySQL database, but not sure how.

select a, b,c etc.. from mailbox where id = X
then
insert id,a,b,c etc.. into problem

When I select, I will be calling the id

So I would like it to get data from mailbox and then insert it into problem.
How would I go about doing this?

Thanks for any help you can give me

I have 2 question, which are related to each other.
They are about my current school project. Which I have been really stupid for, I took it too slow and thought I had enough time.
But no, I had to do almost my whole project in the last 3 weeks and sunday is the deadline.
I have a couple pages to make left, which one of them is the hardest one and I have the 2 questions about it.

Question 1.


I have to make a invoice with 4 different prices, divided over 3 tables in my mysql.

Let me sum up the tables.

Products
Productsid - productprice

Productrule
Productruleid - amount - productid - maintainanceid

Maintainance
Maintainanceid - price

I need to show the price
The price of each product
The amount * productprice
The amount * productprice + price

All in a table, it mustn't be edited, so it not in a form.

I know I have to use a SQL select sum for it, but I have never used it, and my querys always fail in the first place

I used a for and while loop to choose the amount of and the name of products for the mechanic page.
There was a max of 5 products to select, just to keep it easier.
If I would only pick 2, it wouldn send something empty to the database and it wasn't required.
My teacher helped me with that and it works.

So then we come to question 2, can I use that in a table, instead of a drop down menu, which I used at the mechanic page.

This is the PHP code:
Code: [Select]
for($i=1;$i<=5;$i++)
{
if(($_POST['aantal'.$i] != "") AND ($_POST['product'.$i] != ""))
{
$query3 = mysql_query ("INSERT INTO onderdeelregel SET
aantal='".$_POST['aantal'.$i]."',
onderdelenid='".$_POST['product'.$i]."',
werkzaamhedenid='".$werkzaamhedenid."'");
}
}


And the HTML:
Code: [Select]
<table border="0">
<tr>
<th>Aantal</th>
<th>Product</th>
<tr>

<!-- START BLOCK : PRODUCT_REGEL -->
<tr>
<td>
<input class="wijzigInput" name="aantal{NUMMER}" id="aantal" type="text" maxlength="2" size="2" /></td>
<td>
<select name="product{NUMMER}">
<option selected="selected" class="wijzigOption" value=""></option>
<!-- START BLOCK : PRODUCT_REGEL_OPTION -->
<option class="wijzigOption" value="{PRODUCT_REGEL_WAARDE}">{PRODUCT_REGEL_NAAM}</option>
<!-- END BLOCK : PRODUCT_REGEL_OPTION -->
</select>
</td>
</tr>
<!-- END BLOCK : PRODUCT_REGEL -->
</table>
Oh I didn't used a while loop there, but I know I have to use it in the customer page.

I know this isn't going to work on my own, and I haven't got much time left.
I would really appreciate it if anyone could give me some code, or atleast a start of the sql select sum and the for and while loop in a table.
I know I have add other stuff to the invoice, but that isn't hard, so with this I should be able to do it and finish my project in time.
I usually don't like that, I want to learn it myself, but time is very little right now
Oh and sorry for the Dutch in my code.

Please help me, I don't want to stress out and fail it.
School is very important to me and I hate myself for taking it so slow.


Thanks a lot

Chris

guys, please help

i need balance amount of fees all students has to pay. Following is the DB structure. `feepayid` is primary key for paymentstable and paymentregister & `studentid` is primary in studentstable. I have written a query for this, please evaluate the query.

paymentstable
feepayid classid paydate paymode feeamount remarks feediscount 32 8 2012-03-06 19:32:35 1 500 hgfhf 0 31 8 2012-03-04 19:32:35 1 800 hgfhf 0 30 8 2012-02-06 19:32:35 1 1200 hgfhf 0 29 8 2012-02-06 19:32:35 1 1100 hgfhf 0
paymentregister
feepayid payid totalfee studentid 32 3 1500 2 31 2 3500 2 30 1 4500 4 29 3 5500 4
studentstable
studentid studentname 2 john 4 mathew 5 peter 6 mary
Code: [Select]
SELECT d.`studentid`, SUM(a.`totalfee` - (SELECT SUM(`feeamount`) FROM `paymentstable`  WHERE a.`feepayid` = `feepayid`)) AS balancefee
FROM `studentstable` d
LEFT JOIN `paymentregister` a ON a.`studentid` = d.`studentid`
GROUP BY d.`studentid`;

Hi, I'm a little bit new to php and i'm having a small problem. Let me explain with the script :

Code: [Select]
<?php

//connect to mysql

$data = mysql_query("SELECT * FROM forum_topic WHERE topic_id='$topic'") 
or die(mysql_error());

while($info = mysql_fetch_array( $data ))

$dete = mysql_query("SELECT * FROM forum_topic WHERE login='$info['username']'") 
or die(mysql_error());

while($info2 = mysql_fetch_array( $dete ))

     {

echo "......";
     }
?>
 
So I have the first SELECT command that will get the data from table forum_topic and array the data and after that I have a second SELECT that will get the data from table_members but this time time the WHERE clause equals to some data "arrayed" in the first SELECT command...And the end I need to output the data from both tables....

Here's the error I get :


Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/m/a/z/mazemontana/html/login/forum_viewtopic.php on line 73


...I know that my syntax is probably not good but can't figure out how to do it.....

Any help will be greatly appreciated!

Thanx

i need to pull the records from where status not = rejected does anyone know the correct syntax?
Code: [Select]
$data=mysql_query("SELECT * FROM design WHERE id='$id' AND status!='rejected' ") or die (mysql_error());

 

Hi there, wanted to see how I would have the columns I specified in 

$fields = array('id','type');

 

then be generated dynamically in the while loop and any other field I state in

$fields = array('id','type');

then its added to the while loop in the below
 

include('db.php');

class SelectData{


public function wpquery_select($conn,$sql,$fields){

$results = $conn->query($sql);

if($results->num_rows > 0){

	while($row = $results->fetch_assoc()){
		
		// How would you process the array $fields which holds all the rows specified and dynamically create echo $row['id'], $row['id'] and so on?
		
	}
	
  }

$conn->close();

 }

	
}



$select = new SelectData();

$sql = "SELECT * FROM orders";


$fields = array('id','type');


$select->wpquery_select($conn,$sql,$fields);

Thank you

I have a table in a database that I need to filter upon using dependent select boxes.  The database was poorly designed and would be difficult to break into separate tables without affecting code written in other places.  I have found some good code and understanding of how to implement the dependent select boxes if you have two tables with one column functioning as a lookup value between the two.

I have provided a short bit of sql of what the table looks like with some column names changed.  I would need to first sort by lastname and have firstname dependent on the selection of lastname.  Any help would be greatly appreciated.

Code: [Select]
create table `user` (
`id` int(3) Not Null Auto_increment,
`firstname` varchar (60),
`lastname` varchar (24),
`age` double ,
`hometown` varchar (75),
`job` varchar (75),
`birthdate` date
);
insert into `user` (`id`, `firstname`, `lastname`, `age`, `hometown`, `job`, `birthdate`) values
('1','Peter','Griffin','41','Quahog','Brewery','1960-01-01'),
('2','Lois','Griffin','40','Newport','Piano Teacher','1961-08-11'),
('3','Joseph','Swanson','39','Quahog','Police Officer','1962-07-23'),
('4','Glenn','Quagmire','41','Quahog','Pilot','1960-02-28'),
('5','Megan','Griffin','16','Quahog','Student','1984-04-24'),
('6','Stewie','Griffin','2','Quahog','Dictator','2008-03-03');

hi im trying to use  query to select from a table where the price is between to values that the user has to input such as min of 3 and max of 8 and return all the fields from the database where it is true im unsure how to do this but this is what i have so far   $res = pg_query ($conn, "SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price = < && > ");

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none."

I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you.

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

I want to make a table for each paddler_id (Field) which exists into pushup Database

My code for paddler_id = 1 is


require "../sql.php";

$result = mysql_query("EXPLAIN pushup");
$r = mysql_query("SELECT * FROM paddlerinfo t1 LEFT JOIN pushup t2 on t2.paddler_id=t1.id LEFT JOIN practicedate t3 on t3.practice=t2.practice_id ORDER BY t1.firstname ASC ");
$r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");

echo "<table width='30%' border='1' cellpadding='0' cellspacing='0' style='font-family: monospace'>";
echo "<tr>";
echo "<td>DATE</td>";
while ($row = mysql_fetch_array($result)) {

if (in_array($row["Field"], array("paddler_id", "practice_id", "p_id"))) continue;

echo "<td>",($row["Field"]), "</td>";
}
echo "</tr>";

while (($data = mysql_fetch_array($r1, MYSQL_ASSOC)) !== FALSE) {
   unset($data["p_id"],$data["paddler_id"]);
echo "<tr>";
   foreach ($data as $k => $v) { 
echo "<td>";
      echo"$v";
echo "</td>";
}

echo "</tr>";
}


echo "</table>";

mysql_free_result($result);
mysql_free_result($r);
mysql_free_result($r1);
mysql_close();



The problem is on line $r1 = mysql_query("SELECT * FROM pushup  where paddler_id =1 ORDER BY practice_id ASC ");
I want to put something which makes it paddler_id = X where x = 2,3,4,5... and x exists in database and do not print twice the x (because that database may have rows where x = same id


How do i do that??