PHP - Problem In Retrieving Data

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.

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.

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 ..

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.

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.

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

This topic has been moved to MySQL Help.

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

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;
}}

?>

The subject could be a bit vague, but my problem is simple. (I think so)

So I made a php test site that is quite similar to a forum. Where you see a title or a subject and when you click on it you will see more details about that subject.
I made my database and script for inserting data into my mySQL database.

I also did my output aswell, so every topic is posted on a webpage "archive" where you can see all the subjects.

But now I want to see the full details of that type of subject by clicking on it. I have no idea how to make that happen
googled it but didn't find any results...just wondering if it's even possible to do that.

I'm a new guy here!   

This topic has been moved to MySQL Help.

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

I have a navigation list displaying which is a mix of html and php, everything is working fine however now I want to convert this block of code into a function but am having major problems with quotes.

The line of code I currently have is 

$data = $db->query("SELECT * FROM menu")->fetchAll(PDO::FETCH_ASSOC);

foreach ($data as $row) { ?>
     <li><a href="<?php echo $row['url']; ?>" title="<?php echo $row['title']; ?>"><?php echo $row['icon'] . ' ' . $row['header']; ?></a></li>

<?php
	}
?>

As I say everything works using the above but now I am trying to echo the full li out and am having major issues with single and double quotes.

I currently have 

echo "<li><a href='#' title='the title'><i class='fas fa-user site-nav--icon'></i> Help</a></li>";

Now I am trying to use the $row['url'], $row['title'], $row['icon'] & $row['header'] as per the top example but I cannot get the combination of quote marks correct, whether to use double, single or a combination.

I would be grateful if someone could suggest the correct syntax for the a tag then I can work through the rest.

Thanks

I use Popshops Datafeed API and cant figure out an issue im having with an array. I'm trying to retrieve a category name from an array for the current page.

Here is the array code which is in the index.php file.

 $categories = array();
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );
  $categories[] = array( 'name' => 'page name', 
                         'search_options' => array( 'keywords' => 'page keyword' ) );


This is how the script calls the current page keyword.
<?php echo ucwords($_REQUEST[$popshops->nameSpace.'keywords']) ?> 

The code above works fine, so I thought all I had to do was change the 'keywords' to 'name' to get what I was looking for. But that does not seem to work?
<?php echo ucwords($_REQUEST[$popshops->nameSpace.'name']) ?> 

I've tried as much as my limited php knowledge can take me, so now I need some advice.

Here is the function in the popshops.php file they use to pull the page name out for the links in the navigation, but I just want to know how to retrieve just the category name for the current page, nothing else.

function customCategoryLink($category) {
    $url = $this->baseURL($this->params);
    
    if (isset($category['search_options']) && sizeOf($category['search_options']) > 0) {
      foreach($category['search_options'] as $key => $value) {
        $url = $this->addParameter($url,$key,$value);
      }      
    } else {
      $url = $this->addParameter($url,'keywords',$category['name']);
    }
    $url = str_replace('?&','?',$url);
    return '<a href="'.$url.'">'.$category['name'].'</a>';
  }

Thanks in advanced!
 

Code: [Select]
$a = $landSellCheck[0];
echo("<p>a: $a");
$a = $landSellCheck[1];
echo("<p>a: $a");
$a = $landSellCheck[2];
echo("<p>a: $a");

$i = 0;
$landSellCheck = $landSellCheck[$i];
echo("<p>b: (0): $landSellCheck");
$i = 1;
$landSellCheck = $landSellCheck[$i];
echo("<p>b: (1): $landSellCheck");
$i = 2;
$landSellCheck = $landSellCheck[$i];
echo("<p>b: (2): $landSellCheck");
As can be seen from the output below when I echo my array by manually inserting the index number, it works fine as it should. If I set the index number as a variable and echo it, it works for index value 0, for index value 1 is gives 'a' somehow (no idea where that comes from) and for index value 2 it is empty. What am I doing wrong?

Output is:

a: landSellConfirm7

a: landSellConfirm6

a: landSellConfirm1

b: (0): landSellConfirm7

b: (1): a

b: (2):

That must be very simple but i can not step over the issue what i have got.
1. i have file which displays the image called index.php with source code of
--------------------------------------------------------------------
...
<img src="sample.php?id=42" />
...
--------------------------------------------------------------------
2. then i have file sample.php with source code
-------------------------------------------------------------------------------------
require("sys/functions.php");
dbConnect();
$id = $_GET["id"];
if(!isset($id))
{
echo "select an ID";
}
else
{
$res = mysql_query("SELECT * FROM gallery where id=$id");
$row = mysql_fetch_assoc($res);

header("Content-type: image/$row[extension]");
echo $row['image'];
}
-------------------------------------------------------------------------------------------
3. i have successfully uploaded file to MySQL, i can see it as a record with id=42 (image - that is the actual file, extension - image extension)
4. when launching the index.php i am not getting an image but still can get a file size, approx. must be right 248kb. image itself does not display

Could anyone have a look and give me some idea to start with... thanks a lot.