PHP - Moved: Retrieving Data From Two Tables, To View Statuses And Wallposts As On Facebook

Hi,
I need to get data from an XML file, like the format below:
Code: [Select]
<ISBNdb server_time="2011-05-31T19:19:42Z">
<BookList total_results="1" page_size="10" page_number="1" shown_results="1">
<BookData book_id="build_your_own_database_driven_web_site_using_php_mysql_4th_" isbn="0980576814" isbn13="9780980576818">
<Title>
Build Your Own Database Driven Web Site Using PHP & MySQL, 4th Edition
</Title>
<TitleLong/>
<AuthorsText>Kevin Yank, </AuthorsText>
<PublisherText publisher_id="sitepoint">SitePoint</PublisherText>
<Details change_time="2009-04-02T00:30:10Z" price_time="2011-05-31T17:46:10Z" edition_info="Paperback; 2009-06-15" language="" physical_description_text="360 pages" lcc_number="" dewey_decimal_normalized="5" dewey_decimal="005"/>
</BookData>
</BookList>
</ISBNdb>
I need to know how you get the details from <title>,<AuthorsText><PublisherText> and Bookdata. Tried using the example on W3C, using simplexml_load_file but it only returns:
Code: [Select]
ISBNdb
BookList:
Code I'm currently using is:
Code: [Select]
$xml = simplexml_load_file("http://isbndb.com/api/books.xml?access_key=----&results=details&index1=isbn&value1=".$isbn);
echo $xml->getName() . "<br />";

foreach($xml->children() as $child)
  {
  echo $child->getName() . ": " . $child . "<br />";
  }

I have a simple query and need to print the result.
My code does not print a resulr but the query is valid and returns a result.
Any help appreciated.
Code: [Select]
$query = ("SELECT * FROM wp_book WHERE Author_ID = '$Author_ID'");

            $result = mysql_query($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());
            echo mysql_error();
            if (!$result) {
                echo "<br />";
                echo"No Result";
            }
            echo"Result";
           

            while($row = mysql_fetch_assoc($result)){
           
            echo $row['WorkingTitle'];

            }

I would like to display weather conditions on my website and store them in mysql database.
I wonder if it is possible to load web page into php for parsing so the required info could be found and used?
Is it doable with php and what functions could you recommend for this functionality?
How can I have program running in the background on the server which would be triggered every so often to perform this task?
Another question is if I want to trigger some action once a week like Tuesday at noon, is there function in php which could be used to check what day of the week and time it is ?
I am new to website design so any help will be greatly appreciated.

Hi, i have a transaction table which includes following fields.
 
    tran_ID,account_number,account_type,transaction_type,amount,Date

I want to know how these data can be retrieved and display in another table. The table is filled with several records.

Thanks,
Heshan

Hey all,

Quick sum up: I have a social website where users can follow/post/vote etc. I am adding a new facebook-like activity wall feature to each users profiles.

I have worked on this bit for a few days now and can't seem to get it to work properly. What I want is, well, exactly like the facebook wall as I mentioned...When a visitor visits a user's profile, that user's activity will display, whether they recently "voted" on a post, commented, or posted something of their own, I would like it to display on their profile and of course, have the most recent entries on top.

The problems I am having right now a it's displaying some things twice and it's not sorting them by the most recent.

I am working with 3 tables here (I only posted the columns that I am using):
Code: [Select]
Table structure for table votes_posts
Field Type Null Default
indexer int(11) No
post_id int(11) No
vote int(11) No
user_name varchar(250) No
date varchar(255) No

Table structure for table posts
Field Type Null Default
id int(11) No
name varchar(30) No
content text No
datetimerss varchar(255) No
category int(11) No

Table structure for table comments
Field Type Null Default
id int(12) No
post_id int(12) No
name varchar(30) No
content text No
type varchar(30) No
datetimerss varchar(255) No

$users is just $_GET['user']
The timeAgo() function, simply displays the very popular "posted xx ago" date time.
<ul class="streamActivity">
<?php
$checkActivity = "SELECT votes_posts.post_id, votes_posts.user_name, votes_posts.vote, votes_posts.date, 

posts.id, posts.content, posts.name, posts.datetimerss, categories.category, 

comments.post_id AS comm_postid, comments.content AS comm_content, comments.name AS comm_name, comments.datetimerss AS comm_date, comments.type 

FROM `votes_posts` 

LEFT OUTER JOIN `posts` ON votes_posts.post_id = posts.id 

LEFT OUTER JOIN `comments` ON posts.id = comments.post_id 

LEFT OUTER JOIN `categories` ON posts.category = categories.cat_id

WHERE (votes_posts.post_id = posts.id AND user_name = '$user')

OR (comments.post_id = posts.id AND comments.name = '$user')

OR (posts.name = '$user') ORDER BY votes_posts.date, posts.datetimerss, comments.datetimerss ASC";
$checkActivityResult = mysql_query($checkActivity);

if (mysql_num_rows($checkActivityResult) > 0) {

while ($sessionAct = mysql_fetch_array($checkActivityResult)) {

$category = strtolower($sessionAct['category']);

$dateVote = timeAgo($sessionAct['date']);

$datePost = timeAgo($sessionAct['datetimerss']);

$dateComm = timeAgo($sessionAct['comm_date']);

$namePost = $sessionAct['name'];

$nameComm = $sessionAct['comm_name'];

$nameVote = $sessionAct['user_name'];

$idVote = $sessionAct['post_id'];

$idPost = $sessionAct['id'];

$idComm = $sessionAct['comm_postid'];

$contentPost = $sessionAct['content'];

$contentComm = $sessionAct['comm_content'];

$typeComm = $sessionAct['type'];

if ($namePost == $user) {

$classList = 'storyPost';

$classIcon = 'iconMuttr';

$name = $namePost;

$content = $contentPost .' ... read more';

$datetime = $datePost;

}

elseif ($nameComm == $user && $typeComm == "Comment") {

$classList = 'actionPost';

$classIcon = 'iconComment';

$name = $nameComm;

$content = 'Commented "'. $contentComm .'"';

$datetime = $dateComm;

} elseif ($nameComm == $user && $typeComm == "Advice") {

$classList = 'actionPost';

$classIcon = 'iconAdvice';

$name = $nameComm;

$content = 'gave Advice "'. $contentComm .'"';

$datetime = $dateComm;

}

elseif ($nameVote == $user) {

if ($sessionAct['vote'] == "1") {

$classList = 'actionPost';

$classIcon = 'iconLaughed';

$name = $nameVote;

$content = 'Laughed at "'. $contentPost .'"';

$datetime = $dateVote;

} elseif ($sessionAct['vote'] == "2") {

$classList = 'actionPost';

$classIcon = 'iconLoved';

$name = $nameVote;

$content = 'Showed Love on "'. $contentPost .'"';

$datetime = $dateVote;

} elseif ($sessionAct['vote'] == "3") {

$classList = 'actionPost';

$classIcon = 'iconIdiot';

$name = $nameVote;

$content = 'called '. $namePost .' an Idiot for "'. $contentPost .'"';

$datetime = $dateVote;

}

}
?>

<li class="row-activity <?php echo $classList; ?>">

<a href="" class="avatar"><img src="/images/avatars/default_male.jpg" /></a>

<div class="info">

<div class="userName">

<a href=""><?php echo $name; ?></a>

</div>

<span class="msgBody"><?php echo $content; ?></span>

<div class="imgTimeStream">

<span class="img <?php echo $classIcon; ?>"></span>

<span class="source"><?php echo $datetime; ?></span>

</div>

</div>

</li>
<?php

}
} else {

echo '<p>This user has no recent activity.</p>';
}
?>
</ul>


I am by no means an expert programmer...everything I know I have pretty much taught myself over the past year or two, so I can only imagine how ugly this truly is lol. I am learning each and everyday though, and I hope to continue

Also, within each type of activity, there will be slightly different CSS classes on some things.
Example:
if the result row is a post then the css class of the list item would be "post"
if the result row is a vote then the css class of the list item would be "vote"
etc.

Any help would be appreciated!

Hello,

can someone help me with my proggraming problem please. Am new in this so i still have lots problems.

I need to put all data from my MySQL table in one table in html.
There is catch... i need to design output to give me table with x rows and 3 columns, so it means while reading data from database it need put every 4th in new row. And if there  isnt 3 data (or better say if there isnt 3 full <td>)  in row code will automatically add empty <td> or 2 in table.

So...did somebody do this before or have some code ?

All i got for now is 

Code: [Select]
$td ='<td align="center"><img src="'.$row['name'].'.png" />
<p style="font-family:Verdana, Geneva, sans-serif; font-size:15px">
Number: <b style="font-size:40px;">'.$row['serial'].'</b></p>
<br><img width="90" height="29" src="'.$logo.'"/></td>';

$tr ='<tr>'.$td.'</tr>';

$html='<table border="1" align="center">'.$tr.'</table>';
Thanks.

Hello,

is it possible to retrieve data from remote form, from another domain that I can't control.
I want to type in number in my local form text field and then post it to remote form and retrieve data. I know how to retrieve data from local mysql, but don't know how to retrieve it from remote form.

Remote form: http://www.otto.de/is-bin/INTERSHOP.enfinity/WFS/Otto-OttoDe-Site/de_DE/-/EUR/PV_DirectOrder-Start?ls=0#lmPromo=la,3,hk,home,fl,Sidebar_Bestellen

Working number: 31477682

I want to type in 31477682 on my local text field and retrieve data(price, color, status like "lieferbar") from another domain.

Hi,

My transaction table looks like this.It includes following fields.
tran_ID,account_type,account_number,transaction_type,amount,Date

The records regarding each transaction is stored in this table. I want to know how i retrieve the data from this table into another form or table.The coding is what i want...

My actual purpose would be to allow cash supervisor to update records. But first it needs to retrieve data. Then only he can check things and update if necessary.

Thanks,
Heshan.

Hi There all, having an issue with simple xml... hopefully someone will be able to shed some light on this. 

I have this data in an xml feed from an API: 

<ID>job no 1 </ID>
    <Name>job name</Name>
    <State>job status</State>    
    <Tasks>
      <Task>
         <Name>task name 1</Name>
      </Task>
      <Task>
          <Name>task name 2</Name>       
                </Task>
              
<ID>job no 2</ID>
     <Name>job name</Name>
     <State>job status</State>    
     <Tasks>
        <Task>
           <Name>task name 1</Name>
        </Task>
        <Task>
           <Name>task name 2</Name>       
         </Task>

I would like to display these in a table pretty much as it is shown above.

Job no 1     job name    job status

                             job 1 task name 1

                            job 1 task name 2

Job no 2     job name    job status

                             job 2 task name 1

                            job 2 task name 2

etc

my code looks like this : $required is narrowing down specific states not shown for clarity 

 $xml_current=simplexml_load_string($jobs_task_response) or die("Error: Cannot create object");
     
    foreach($xml_current->Jobs->Job as $item_current) {
        if (in_array((string)$item_current->State, $required)) {     
            $projects_current[] = array(
                'job_no'          => (string)$item_current->ID,
                'job_name'        => (string)$item_current->Name,
                'job_status'      => (string)$item_current->State,
            );
            foreach($item_current->Tasks->Task as $current_tasks){
                $projects_task[] = array(
                'job_tasks'       => (string)$current_tasks->Name,
                );
            }
        }         
    } 

 
    foreach ($projects_current as $proj_current) {
        $job_no =$proj_current['job_no'];
        $job_name =$proj_current['job_name'];
        $job_status =$proj_current['job_status'];       
        $clr_current = $colors[$job_status];
        $project_id = $job_no;  

        $tdata_1 .= "<tr id='current' class='card-body collapse-show'>";
        $tdata_1 .= "<td class='th-sm-1 bg-white '><a href='../details/index.php?pid=$job_no' class='text-left ml-1'>$job_no</a></td>";
        $tdata_1 .= "<td data-target='#" . $job_no . "' data-toggle='collapse' class='th-sm-2 bg-white text-left ml-1'>$job_name</td>"; 
        $tdata_1 .= "<td class='th-sm-2 " . $clr_current . " text-left ml-1 '>$job_status</td>";
      
        foreach ($projects_task as $proj_tasks){
        $job_tasks =$proj_tasks['job_tasks']; 
        $tdata_1 .= "</tr>";
        $tdata_1 .= "<tr id='" . $job_no . "' class='card-body collapse'> ";
        $tdata_1 .= "<td class='th-sm bg-white text-left ml-1'></td>";
        $tdata_1 .= "<td class='th-sm bg-white text-left ml-1'></td>";
        $tdata_1 .= "<td class='th-sm " . $clr_current . " text-left ml-1'>$job_tasks</td>";
        $tdata_1 .= "</tr>";
        }

    }

 what I get with this code however is;

Job no 1     job name    job status

                             job 1 task name 1

                            job 1 task name 2

                            job 2 task name 1 

                            job 2 task name 2

 

Job no 2    job name   job status

                          job 1 task name 1

                          job 1 task name 2

                          job 2 task name 1

                          job 2 task name 2       

 

I'm sure there is a simple answer to this, I just can't seem to put my finger on it. 

Can anyone help please? Much appreciated thanks in advance!

Hi guys ..   please help me .. I don't know how to do this and I tried but there were no satisfied  results..   I want to retrieve a Title (ing_title) from a database called k_db2 , in a table called content_langs  depending on its ID , which called ing_contID   example: if ing_contID=1 , then show the ing_title with this id ing_contID   the above code should be in a php file ..   then I want to include this php file inside the header of my website.. by importing the ing_contID from the database and depending on it the title should be shown..     I really tried but I couldn't find any solution ..   if you could help me in the first part of this problem I'll be glad ..

Hello, I'm learning PHP, so a completely noob, right now. First to the question itself, I want to know how to retrieve the data(variables & it's values) from the url, which was made or generated(or whatever right word is) by using http_build_query() in php. I created a querystring($string) with certain variables & dynamic values that I'm passing to a url

I have a very simple system (few files) having simple articles (only title and a paragraph description) stored in single text files. I catch the data by

Code: [Select]
$data=file('article1.txt');
$title=$data[0];
$description=$data[1];
This simple system works perfectly, but the problem appears when increasing the number of files (e.g. more than 10,000 articles). This is a problem connected with the OS behavior for handling huge number of files. My first question: Is there theoretically a faster system (e.g. database-based) for retrieving data, comparing with retrieving from plain text file?

Second question: what can be an alternative for this very simple system (no search query or additional field)?

1. XML: It has the same problem if storing in different files.
2. Mysql: It is very advanced for this system.
3. SQLite:I am thinking of this, but it still have advanced structure of SQL.
4. DB Berkeley: I am not familiar with Oracle at all, and I need to install something new on my server. Is it really worth of trying?
5. Anything else?

In general, I just need fast reading the data. I have no idea how much the speed of these systems are different to determine which is worth of consideration. Thanks for sharing your idea.

Hi,   I need to log into a website to check for the latest data, and I want to automate this with php script that will use a cronjob to log in, retrieve the data and email it to me.   Currently I'm stuck on the logging in part (I'm testing the script below on my squirrelmail email login page). I've tried using the snoopy php class (sourceforge.net/projects/snoopy/) but it seems the POST variables aren't being recognised (because the email program is directing me to the log in page, as opposed to telling me that my username/password is wrong).   (is it even possible for a servers to accept POST variables in this way??? I'm kind of surprised but lots of poeple seem to use snoopy to login via userforms)   Please could someone point me in the right direction?   Thanks,   Stu     / load the snoopy class and initialize the object /
$snoopy = new Snoopy(); / set some values /
$login_form['login_username'] = 'MY_USERNAME';
$login_form['secretkey'] = 'MY_PASSWORD'; $snoopy->cookies['vegetable'] = 'carrot';
$snoopy->cookies['something'] = 'value'; / submit the data and get the result /
$snoopy->submit('http://webmail.MY_WE...rc/redirect.php' $p_data); / output the results /
echo '<pre>' . htmlspecialchars($snoopy->results) . '</pre>';
Edited by stubarny, 14 June 2014 - 11:27 AM.

Please help! how can i query data from different tables? I've tried so many codes already but it won't work. Attached Files  Untitled1.png   39.93KB   0 downloads

This is for band website for its event listings. The main event page list everything fine, but once selecting the "Details" link which activates the switch event. Its no longer showing anything. When I had one event in the data base it worked fine, but now I have 3 events in the database and now its not working.

Page can be viewed he http://184.66.66.169/ffy/event.php

Code: [Select]
<?php
 //Event Code Here

$eventid = (isset($_GET["id"])) ? intval($_GET["id"]) : 0;

switch($_GET["list"]=='true')
{
case "0":
if($_GET["id"]== $eventid)
{

$result = mysql_query("SELECT * FROM event ORDER by eventdate DESC");
if (!$result) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($result)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));

print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
<font size="-2" color="#CCCCCC"><a href="event.php?list=true&eventid='.$id.'">Details</a></font><br />
<hr color="#FFFFFF" width="100" align="left" size="1">
</td>
</tr>
  </table>
');

}}
break;
case "true":
if($_GET["id"]==$eventid)
{

$resultd = mysql_query("SELECT * FROM event WHERE id=$eventid LIMIT 1");
if (!$resultd) {
   die("query failed: " . msql_error());
}

while ($row = mysql_fetch_array($resultd)) {
list($id, $eventdate, $header, $description, $image, $location) = $row;
$description = nl2br($description);
$eventdate = date("M j, Y",strtotime("$eventdate"));
print('
<table width="680" border="0" cellpadding="14" cellspacing="0">
 <tr>
 <td>
<div class="myFont"><font size="+1" color="#4e8baf">'.$eventdate.' - </font><font size="+1"><b>'.$header.'</b></font></div>
'.$description.'<br />
<hr color="#FFFFFF" width="100" align="left" size="1">
<center>
'.$location.'
</center>
</td>
</tr>
  </table>
');

}
break;
}}

?>