PHP - Applying Limit To First Instance Of Each Item In A Column

Well I am looking to change this url

Code: [Select]
http://website.com/product.php?Item=2369
to

Code: [Select]
http://website.com/product.php?Item=Item-Name

Heres a snip of the code that handles that.

<?php include_once('mysql_connect.php');$id = (int)$_GET['Item'];?>()

any help would be appreciated.

Hello,

I'm attempting to build a Model View Controller and I've run into some issues with inheriting objects / extending classes. The application is focused around a "SuperObject", which contain instantiated libraries, helpers, controllers, models and views.

I current have a Base class, which is effectively the "SuperObject". Previously I called the function GetInstance() within my model to get an instance of the SuperObject and assign it to a variable. So, $this->Instance->(The Object)->(The Method)();

However, I want to remove the need for that variable $this->Instance and just have $this->(The Object)->(TheMethod)();

And so, If you see my Controller class, libraries are instantiated as $this->Object which works perfectly. If from, within my controller I was to load the Model class. For example, $this->Loader->Library('Model'); when that model becomes instantiated, even though an extension of the Base class, I cannot use the libraries I instantiated in my controller.

And of course there is a Fatal Error: Fatal error: Call to a member function UserAgent() on a non-object

Code: [Select]
<?php

class Base
{
private static $Instance;

public function Base()
{
self::$Instance =& $this;
}

public static function &GetInstance()
{
return self::$Instance;
}
}

function &GetInstance()
{
return Base::GetInstance();
}

Code: [Select]
<?php

class Controller extends Base
{
function Controller()
{
parent::Base();
$this->Initialize();
}

function Initialize()
{
$Array = array(
'Uri',
'Loader',
'Router',
'Database',
);

foreach($Array as $Object)
{
$this->$Object = loadClass($Object);
}

}
}
Code: [Select]
<?php

class Model extends Base
{
function Model()
{
parent::Base();
echo $this->Input->UserAgent();
}

    }

Code: [Select]
<?php

class Home extends Controller
{
function Home()
{
parent::Controller();
}

function index()
{
$this->Loader->Library('Session');
$this->Loader->Library('Model');

$Data = array(

'Controller' => $this->Router->FetchClass(),
'Title' => ucfirst($this->Router->FetchClass())

);

$this->Loader->View('meta',$Data);
$this->Loader->View('header',$Data);
$this->Loader->View('home');
$this->Loader->View('footer');
}
}

Any input would be appreciated!

So, I have what I think is an odd question.  I have a function that contains a for loop.  Within that for loop, it checks for a new condition and if it is true, it calls the very function it's already in.  So, within the for loop inside of function "a", it can call function "a" with new arguments which will then start a new for loop to be "nested" to the previous for loop, in a way.  My problem is trying to keep the values of the variables so that once the new for loop (or loops) finish, the previous for loop won't be stopped up by the new variable values that have since changed.  Make sense?  So, two questions:

1. How do I lock in values that make them unique to that very call of that function and keep them unique through further iterated versions?

2. I imagine, in theory, that for loops stay in memory in state as a new "instance" of that same for loop runs through, right?  Basically, is what I'm doing possible in that a for loop calls itself, in essence, to create a new "instance" of that for loop, then when it finishes, have the previous loop continue iterating?

For question #1, I've already thought about using variable variables, but that doesn't work because every time the function is called, the variable variable will change to new values based on the new arguments and instantiating the function again.  I'm kind of looking for a way to make unique "instances" of a method that don't mess with future calls to that method and where future calls don't mess with currently iterating loops in that method.

Phew, I think I confused myself.  Thanks for any help.

Hey Guys. I have a shopping cart script that loops through the shopping cart session  array and assigns values to the property of a class. For some weird reason the subtotal property only works when I use the self keyword. If I use the $this-> instance variable  the sub total does not get assigned the subtoal price. Its just NULL.   Does anyone have any suggestions as to why it may not be working.   Below is a quick copy and paste of my code. Please be aware that some there may be some syntax mistakes as a result to copying and pasting part of my code that is relevant to this issue. Thanks!

class CoreCartFunctions {

protected static $subtotal;
protected $menu_item_price = NULL;

public function GetMenuItem() {

//self:items is the cart session array that is initilized in a construct method
//Assign the values for each cart array
      foreach (self::$items as $menu_item_id_session) {


$this->menu_item_price = getItems($this->menu_item_id,"menu_item_price")*$this->item_qty;

self::$subtotal += $this->menu_item_price; 
//Does not work with the following ---> $this->subtotal += $this->menu_item_price; 

}




}

Hello,

I need to find the target html address within some raw html. I know it lies between Needle 1 and Needle 2 below.

Needle 1:
</span></a>&nbsp;&nbsp; <a href="

Needle 2:
" rel="nofollow"><span class=pn><span class=np>Next&nbsp;&raquo;</span></span></a></div>

Nornally I would just use the explode() function but my headache is that there are many instances of Needle 1 in the raw html code and I want my output array always have the same number of elements. However I do know that my target html address is directly after the last instance of Needle 1.

How should I go about splitting the html code into an array that always has 3 elements? I'd like the first element to include code up to and including the last instance of Needle 2, the 2nd element to have the target html address, and the 3rd element to have Needle 2 and any following code.

Thanks for any pointers (my main struggle is identifying the last instance of needle 1),

Thanks,

Stu

Hey,

I'm trying to save a MySQL-Link source as an instance variable in my query class.
The problem is that MySQL sees it as an invalid MySQL-Link (supplied argument is not a valid MySQL-Link resource).
What I'm I doing wrong?

//Walle

Code: [Select]
private $connection;
//Construct
public function __construct(&$connection)
{
  $this->connection = $connection;
}

//Where the error occurs
public function exe_query($sql)
 {
  $result = mysql_query($sql, $this->connection);
  if(!$result) {
  throw new Exception(mysql_error());
 }
 return $result;
}

Hope someone can help, I am trying to add up all the values of a variable in a PHP while loop and have tried several approaches but none seem to work. Hopefully someone can point out what the correct method is.

I've set up some code to pull the pay rate from a MySQL table, and then calculate that person's earnings based on the amount of time they spend on a particular job. That works fine:

           while ($row = $getrate->fetch_assoc()) {

              $staffrate = $row["Rate"];

              $earnings = ($staffrate/3600) * $jobeventtimeseconds;

              $earningsformatted = number_format($earnings, 2);

           }

However there may be a number of jobs for different people with different rates, so I want to add all of these up and output the total. So for example if I had values of 125.00, 35.50 and 22.75 I want to show 183.25 as the total.

So I tried a few things I found on forums on the subject:

$totalearnings = 0;

foreach($earningsformatted as $key => $value) {

   $totalearnings += $value;

}

echo $totalearnings;

That didn't work so I tried another method that someone suggested:

$total=array($earningsformatted);

echo array_sum($total);

The 2nd method outputted just the last individual value, the 1st method didn't work at all. Does anyone have a working method that can be used to do this?

Thanks

Hi, I have an output of print_r he

Google_Service_Calendar_Acl_Resource Object
(
    [stackParameters:Google_Service_Resource:private] => Array
        (
            [alt] => Array
                (
                    [type] => string
                    [location] => query
                )

            [fields] => Array
                (
                    [type] => string
                    [location] => query
                )

            [trace] => Array

I am wondering what is the right syntax to create the instance and set the variables? Thanks, Ted

I know you can use str_replace to replace a value with another value, or an array of values with an array of other values. What I'd like to do is replace each instance of a single value with an array of values which get iterated through for each instance found. Think prepared statements that you don't have to call setString or setInt on. Here's a made up example.
Code: [Select]
$db->query = 'SELECT * FROM users WHERE user_name = ? AND user_role = ?;
$db->params = array('hopelessX','admin');
$db->executeQuery(); //this contains a call to a private function that does the replace

I have everything else working except this. It works if I specify an array of values to replace and do something like below, but I was hoping to not have to support that method of replace if I didn't need to.
Code: [Select]
$db->query = 'SELECT * FROM users WHERE user_name = :name AND user_role = :role;
$db->replace = array(':name',':role');
$db->params = array('hopelessX','admin');
$db->executeQuery(); //this contains a call to a private function that does the replace

I can do it that way if I need to or I could make some overly complicated thing that finds each instance of the question mark, replaces it with a unique value and then adds that unique value to a replace array similarly to the method in code block two but that defeats to the purpose of making this simple database adapter in the first place (although it was mostly just for fun anyway).

Anyway, if anyone has any advice and knows of a simple means to achieve this goal that would be much appreciated.
Thanks in advance

json_decode returns a stdClass Object.
Is there any way where I can get instance of my class instead of the same?

I mean If I json_decode the below string then it will provide me instance of stdClass and not instance of Person class
{"name":"a"}

How to achieve the same?

Thanks in advance

CSJakharia

I have a table that contains the schools in my system:

schools
id
name
location
...

Then, I have three tables that use the id of this table:

schoolAdmins
schoolID

schoolContests
schoolID

students
schoolID

When I go to delete a school from my system, I want to check to see if that school is connected to any of these three other tables first.  This is what I tried (but obviously failed because I'm here) where I'm passing the query the $studentID in question:

SELECT * FROM schoolAdmins, schoolContests, students WHERE (schoolAdmins.schoolID = $schoolID) OR (schoolContests.schoolID = $schoolID) OR (students.schoolID = $schoolID)

I'm really new to the concept of querying multiple tables in a single statement, so I'm just kind of guessing at this point.  Thanks in advance.

I have a scenario in PHP, i need a smart way:
1. I run one process on background forever, scheduler.php - done
2. User on the web submit their task in DB to be processed by the above process(scheduler.php) - done
3. scheduler.php read the db after every 1 sec, looking for user's task.

Problem:
Ideally, if it founds like 10 or more tasks it should process them concurently(in parallel)..i.e it should not wait one task to be fully executed so as to run the next one as one task might take a very long time to be fullu executed.
I would do like exec("nohup php <path>/file_name.php >> /dev/null 2>&1 &"), but if i have alot of tasks this will create zombie processes.

Any smart way to do this will be highly appreciated!

Hi All

 

I have not really played around with PHP in ages so I am having a hard time trying to figure out the best way to proceed. Anyhow... what I need to get done is to take a singleton pattern core database class that has a extended driver based class (ie; the type of database server the connection is connecting to), and build a new class that dynamically handles as many driver based connections that are called using a single instance. As a side note, I tried PDO but it only supports a single driver per class instance, and then each of those connections cannot not have their on set of properties that relate to each connection. Anyway, I was thinking that the best way to handle all the driver specific connections, is to hand out a 'unique hash reference' that points to an array of connection objects and the object properties. then when the client runs any sql function they pass the 'unique hash reference'  which the class then returns the object and it properties that will be used by the class to call up the driver specific sql function that was requested by the client. So what do you all thing about that....

 

TIA

stephanieT

 

PS...

 

I reason i need this is because I need to update up 25 different databases based on data stored on all the databases and  not all of the database servers are of the same type, (ie; MSSQL, Oracle, MySQL, MariaDB, berkeley DB, postgres, sqlite2,3, etc, etc)!

Edited January 16, 2019 by StephanieT

I have gold data being reported here goldprices.org.uk (scroll down near the bottom). Recently it broke for no apparent reason. I checked the scraper and everything seems to be OK. The issue is that the gold price in (troy) ounces is being scraped fine - however to work out the price in grams you must multiply by 0.0321 (grams in a troy ounce). The code looks like this:

Code: [Select]
$ounce_price = null;
    $grams_price = null;
    if(count($nodes) == 1 && $nodes[0][1]) {
        $ounce_price = $nodes[0][1];
        $grams_price = $ounce_price * 0.0321;
However $ounce_price * 0.0321 breaks the code and returns '0.0321'.

I then tried the code:

Code: [Select]
$ounce_price = null;
    $grams_price = null;
    if(count($nodes) == 1 && $nodes[0][1]) {
        $ounce_price = $nodes[0][1];
        $grams_price = $ounce_price + 1;
And the code returned the value '2'. So it appears that when $ounce_price is being multiplied/subtracted etc it reverts to a value of '1'. However if I do $grams_price = $ounce_price the value is the correct ounce price.

I'm so confused as to why when adding an equation to $ounce_price the value reverts to '1' as opposed to equalling the correct number. Any help here would be HUGELY appreciated - I've been stuck for several days and only just decided to ask online :s

Nick

ini_set('session.cache_limiter','public');
session_cache_limiter(false);

 

they give warning

Warning: ini_set(): A session is active. You cannot change the session module's ini settings at this time in C:\xampp\htdocs\aps\init.php on line 3

Warning: session_cache_limiter(): Cannot change cache limiter when session is active in C:\xampp\htdocs\aps\init.php on line 4

Edited April 5 by mahenda