PHP - Pulling Data Out Of An Remote Html Table

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

Code: [Select]
id: 20 Reason: this is a test
id: 21 Reason: Tests
id: 22 Reason: Lolcatz
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: 36 Reason: Test
As you can see on the 2nd code box there are id's 20,21,22 and 36 in the database the rest are not active in the database.

i am using using Code: [Select]
for to pull out the id that starts with the lowest value in the database, and only have it run until it gets to the maximum value.
Code: [Select]
for ($id=$set_min; $set_max<=7; $id++)
{
                // $id=$set_min is pulling the smallest value and $set_max is pulling the maximum value so it stops  after it gets to 36
$query=mysql_query("SELECT * FROM posted WHERE id = $id");
$query_row=mysql_fetch_array($query);

$reason = $query_row[reason];
$pulled_id = $query_row[id];
$pulled_pic22 = $query_row[picture];
$href_pull = "<a href=" . "search.php?id=" . "$id" .">";

echo "<td>" . $href_pull . "<img src=$pulled_pic22 height=200 width=150 />" . "</td>";
}

how would i make it so i do not pull the values 23-35 which are not in the active database.

Example: http://dev.hackmuch.com/of-the-day/search.php?id=36

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?


<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

 = array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>


an example XML file would be:
Code: [Select]
<!--
 Automatically generated data from EVE-Central.com
-->
<!-- This is the new API :-) -->
−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

index.php?page=1 that link style but there is not hard files it is all to be stored in the DB

here is what i have got so far

Code: [Select]
<?

$result = mysql_query("SELECT * FROM page") or die(mysql_error());
$row = mysql_fetch_array( $result );

if(isset($_GET['page'])) {
echo $row['text'];
} else {
$result = mysql_query("SELECT * FROM page
 WHERE id='1'") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo $row['text'];
}
?>
but always shows page ID 1 (home page) so i no i am missing something just not sure what hehe

DB structu
Code: [Select]
menu
----id (auto increase)
----name (home, about etc)
----id2 (page weight)
pages
----id (auto increase)
----name (page name home, about etc)
----text (page text)


link structure from the menu

Code: [Select]
<?

$result = mysql_query("SELECT * FROM menu ORDER BY id2") or die(mysql_error()); 


?>
<table>
<?
while($row = mysql_fetch_array( $result )) { ?>

<tr><td>
<a href="index.php?page=<? echo $row['id'];?>"><? echo $row['name']; ?></a>
</td></tr> <?
}
?>
</table>


dont think i have missed any info that i have on file but not sure why it will not link so thought of you guys hehe

Thanx in advance

Ok I have a fairly straight forward question. I am designing a baseball website and I am trying to add in a schedule, here is what I have:

Data Bases
1) Teams DB - Each team has a unique team ID, location, logo, and owner
2) Schedule DB - Each game has a unique game ID, and the schedule is set up like this: AWAY = Team ID, HOME = Team ID....

So I assume I am using the JOIN command to pull the schedule from both databases, any idea how the SQL command would look?

OK, I've scoured the forms on here, searched and tutorial read and even pulled out an old PHP book. Alas, I'm stumped.

First off, my two tables that I'm trying to pull data from:

rubric
-------------------------------------
---- code ---- | ---- title --------
-------------------------------------
ABCD            | Category Name


schedule
----------------------------------------------------
------ name ------ | ------ short_title ------
----------------------------------------------------
ABCD-123-4569   | Title Is Here


Now, none of these share the same value, per say. rubric.code shares the first THREE letters from schedule.name, but that is all.
What I'm trying to do is something similar to the old:

A
apple
automobile

B
banana
basket
bench

C
car
child
crumb

... etc, etc, where the letter heading is actually the rubric.title value and then underneath it it lists all the matching short_title from
schedule where the first four letters of schedule.name match the value of rubric.code - if that even makes sense.

Unfortunately these are the tables I have to work with. If anyone out there has any ideas, I would be thrilled to hear them. Another
thing that is driving me crazy is that this server I'm working on doesn't have error reporting turned on so I've been stuck with just a
white screen to let me know something is amiss.

I'm running PHP Version 5.3.3-7+squeeze8 if that helps.

Thank you!

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

Hey Guys,

I'm struggling with some logic of how to do something wondering if anyone can point me in the right direction.

Details:
I am making a PHP/MySQL game to learn more PHP, I've got my login/logout system created. However I am planning on the game been map based on a 100x100 grid. I have two tables:

USERS
Username, Password, x, y
Test, Test, 1, 1


MAP
X, Y, type
0,1,1
0,2,1
0,3,2
0,4,3
0,5,2
etc

I am stuck on how to get the user's logged in X and Y coordinates and then compare them with the map table X and Y, to see what type of field to show, 1,2 or 3.

Is there a name for this type of function so I can do some research on it? Or could someone give me an example? Would be fantastic if anyone has any advice.

Thanks in advance
NewcastleFan

Hi,

I have a table that contains posts and each post has a datetime field.

Im trying to work out how I can show entries from today, this week and this month so I can have a link that shows all posts from today or this month etc.

Any one know how I can do this ? My current piece of code that pulls the data from the db looks like this :

Code: [Select]
$texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6");
I want to add a bit that acts like : WHERE date = today


Hope that makes sense, Im a bit of a newbie

Thanks in advance,

Scott

Hi,

having problems getting checkboxes to display all reuslts when a user selects more than one check box say in the category section and one in the location section - see page http://www.partyco.co.uk/event-and-party-venues/ - submit to see reults page:

I managed to get it to display reults if the user only seletc either a right or left column option OR one of each - BUT not when thet select multiple categories and one location - and ideas how to do this ? putting it into an array perhaps - but how - new to some of this....

here is the code for the reults page:
Code: [Select]
<?php
$location = $_POST[location];
$category = $_POST[category];
?>

<?php

$Link = mysql_connect("xxxxxxxxx", "xxxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

// selects db listings when location not given
if (empty($location)) {
$query = "SELECT * FROM venues WHERE category = '$category' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when category not given
} elseif(empty($category)) {
$query = "SELECT * FROM venues WHERE location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());

// selects db listings when both given
}else {
$query = "SELECT * FROM venues WHERE category = '$category' and location = '$location' order by title";
$result = mysql_query($query) or die(mysql_error());
}

while($row = mysql_fetch_array($result)){
echo "<div class=\"resultsShort\" style=\"margin-bottom:10px;\">";
echo "<h2 id=\"resultsHeading\">";
echo $row['title'];
echo "</h2>";
echo "<p class\"resultspara\">". nl2br($row['description']). "</p>";
echo "<h4 style=\"margin:5px 0 0 0; padding:0;\">Contact details</h4>";
echo "<p class\"resultspara\">". nl2br($row['contact']). "</p>";
echo "<div style=\"float:left; width:124px; height:40px; margin:10px 15px 0 0;\">";
echo "<a href=\"/party-supplier-resources/email-supplier.php?title=". $row['title']. "&email=" . $row['email']. "&location=" . $row['location']. "&category=" . $row['category']. "\" title=\"contact this venue here\">";
echo "<img src=\"/images/email-supplier.jpg\" width=\"124\" align=\"right\" height=\"35\" alt=\"contact this supplier button\" border=\"0\" /></a>";
echo "</div>";
echo "</div>";
}


?>


<?php include("../include/shareLinks.php"); ?>


<div id="popupContact">
<a id="popupContactClose" title="close this window">close x</a>
<h1>Supplier Directory Enquiry Form</h1>
<?php include("../include/enquiryform.php"); ?>
</div>
<div id="backgroundPopup"></div>


<?php
mysql_close ($Link);
?>
Any help appreciated!

Aaron

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hey!

I have it so users can submit info to my site. They have to check some check boxes and radio buttons. I want them to be able to edit this information, so I want to have the data pulled from the MySQL database and have the correct radio button selected (and the text bolded). So I'm thinking some sort of array to check for each value in the database... but I don't really know.

There are a few groups of radio boxes and check boxes but here is an example of one.

Code: [Select]
<input type="radio" name="stage" value="Stage 1" /> Stage 1
 <input type="radio" name="stage" value="Stage 2" /> Stage 2
 <input type="radio" name="stage" value="Stage 3" /> Stage 3

The information is pulled from the database like this:

Code: [Select]
$res=mysql_query("SELECT * FROM ACTIVE WHERE INDEX_ID=$id");
if(mysql_num_rows($res)==0) echo "There is no data in the table <br /> <br />";
else
{
 for($i=0;$i<mysql_num_rows($res);$i++)
 {
  $row=mysql_fetch_assoc($res);
 }
}

So when I pull information (lets say I want to echo it) it'd look like this:

Code: [Select]
$row[STAGE]
The value for the stage selection can only be Stage 1, Stage 2 or Stage 3 so I need it to be selected when the page loads.

Thanks!

Hello

I have 2 database tables:

1) products which contain 3 columns: id, description and unit

2) units which contains 2 columns: id and description

I need to pupulate html table with data from 2 database tables.this is the structu

id, description, unit, unit_description (the first 3 columns come from table 1 and the fourth column from table 2

I know hot to pupulate the table according to the 3 columns: (the remarks are for the 4th column that i dont know how to call). I want this column to get the description of the unit in the row from the second table in the database - using the get_unit_desc in the GlDbOra.php file (Not by making a join in the select) 

How can I do that? I'll be happy for any help

index.php

<?php
    require_once("../xxx/Includes/GlDbOra.php");
    $cursor='';
    $cursor=DBOracle::getInstance()->get_products();
?>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Products</title>
        <script type="text/javascript" src="../../Bundles/php-ajax/jquery-3.5.1.js"></script>  
        <script src="../Bundles/bootstrap-4.5.0-dist/js/bootstrap.min.js"></script> 
        <link href="../Bundles/bootstrap-4.5.0-dist/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css"> 
        <link href="../xxx/css/global_style.css" type="text/css" rel="stylesheet" madia="all"/> 
    </head>
    <body>
        <div class="container">
            <div class="row">
                <div class="panel  panel-primary filterable">
                   <div class="panel-heading">
                        <h3 class="panel-title">Products</h3>
                        <div class="pull-right">
                            <button class="btn btn-default btn-xs btn-filter"><span class="glyphicon glyphicon-filter"></span> Filter</button>
                        </div>
                    </div>
                    <form id="data_form" name="datatable_form" method="POST">
                        <div class="table-repsonsive">
                            <table class="table table-bordered" id="tab_logic">                                        
                               <thead>
                                    <tr class="filters" id="table_header_2_btn">
                                        <th width="12%"><input type="text" class="form-control" name="Id[]" value="" placeholder="Id" disabled /></th>
                                        <th width="30%"><input type="text" class="form-control" name="DESCRIPTION[]" value="" placeholder="Description" disabled /></th>
                                        <th width="12%"><input type="text" class="form-control" name="UNIT[]" value="" placeholder="Unit"  disabled /></th>
<!--                                        <th width="30%"><input type="text" class="form-control" name="UNIT_DESCRIPTION[]" value="" placeholder="Description" disabled /></th> -->
                                        <th width="12%"></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                        foreach ($cursor as $cursorCurrentRow) 
                                        {
                                            echo '<tr class="form-group">';
                                            echo "<td width=".'"12%"><input type="text" name="ID[]" value="'.htmlspecialchars($cursorCurrentRow['ID'], ENT_QUOTES).'" disabled style="border:none;"></td>';
                                            echo "<td width=".'"30%"><input type="text" name="DESCRIPTION[]" value="'.htmlspecialchars($cursorCurrentRow['DESCRIPTION'], ENT_QUOTES).'" disabled style="border:none;"></td>';
                                            echo "<td width=".'"12%"><input type="text" name="UNIT[]" value="'.htmlspecialchars($cursorCurrentRow['UNIT'], ENT_QUOTES).'" disabled style="border:none;"></td>';
//                                            echo "<td width=".'"30%"><input type="text" name="UNIT_DESCRIPTION[]" value="'.htmlspecialchars($cursorCurrentRow['DESCRIPTION'], ENT_QUOTES).'" disabled style="border:none;"></td>';
                                            echo "<td width=".'"12%">'
                                                    . '<a class='.'"add" title='.'"Add" data-toggle='.'"tooltip"><i class='.'"material-icons">&#xE03B;</i></a>'
                                                    . '<a class='.'"edit" title='.'"Edit" data-toggle='.'"tooltip"><i class='.'"material-icons">&#xE254;</i></a>'
                                                    . '<a class='.'"delete" title='.'"Delete" data-toggle='.'"tooltip"><i class='.'"material-icons">&#xE872;</i></a>'
                                                    . '</td>';
                                            echo "</tr>\n";
                                        }
                                        ?>
                                </tbody>
                            </table>
                        </div>
                    </form>
                </div>
                <button class="regular_button" id="add-new"><span class="glyphicon glyphicon-plus"></span> Add Rows</button>
                <button class="regular_button" id="save_rows"><span class="glyphicon glyphicon-floppy-save"></span> Save</button>
            </div>                
        </div>
     </body>
</html>

GlDbOra.php

<?php
    class DBOracle 
    {
        
        private static $instance = null;

        public static function getInstance() 
        {
            if (!self::$instance instanceof self) 
            {
                self::$instance = new self;
            }
            return self::$instance;
        }
        public function __clone() 
        {
            trigger_error('Clone is not allowed.', E_USER_ERROR);
        }

        public function __wakeup() 
        {
            trigger_error('Deserializing is not allowed.', E_USER_ERROR);
        }

        public function __construct () 
        {
            $databaseConfig = include 'config.php';
            $OracleUser=$databaseConfig['Oracle_User'];
            $OraclePwd=$databaseConfig['Oracle_Pwd'];
            $OracleDB=$databaseConfig['Oracle_DB']; 
            $this -> OracleUser = $OracleUser;
            $this -> OraclePwd = $OraclePwd;
            $this -> OracleDB = $OracleDB;
            $this->con = oci_connect($this->OracleUser, $this->OraclePwd, $this->OracleDB);
            if (!$this->con) {
                $e = oci_error();
                trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
                exit;
            }
        }

        public function get_products() 
        {
            $cursor='';
            $query = "begin get_products(:cursor); end;";
            $stid = oci_parse($this->con, $query);
            $p_cursor = oci_new_cursor($this->con);
            oci_bind_by_name($stid, ':cursor', $p_cursor, -1, OCI_B_CURSOR);
            oci_execute($stid);
            oci_execute($p_cursor, OCI_DEFAULT);
            oci_fetch_all($p_cursor, $cursor, null, null, OCI_FETCHSTATEMENT_BY_ROW);
            oci_free_statement($stid);
            oci_close($this->con);
            return  $cursor;
        }

        public function get_unit_desc($unitid) 
        {
            $unit_desc='';
            $query = "begin :unit_desc_bv := get_unit_desc(:id_bv); end;";
            $stid = oci_parse($this->con, $query);
            oci_bind_by_name($stid, ':id_bv', $unitid);
            oci_bind_by_name($stid, ':unit_desc_bv', $unit_desc,30);
            oci_execute($stid);
            oci_free_statement($stid);
            oci_close($this->con);
            return $unit_desc;
        }
    }
?>