PHP - Connection Between Classes

Hi Guys,

need a little help and drawn a blank. The code that is not working is below

$result = $conn->query("SELECT * FROM MK_migration_details WHERE mig_bid='".$_SESSION['bid']."'");

I can confirm the $_SESSION['bid'] is working as echo's out on another part of the page. and the above $result works when i manually type the search criteria like below.

$result = $conn->query("SELECT * FROM MK_migration_details WHERE mig_bid='300101'");

Basically no result turn up on the page. Any ideas or advise how I can diagnose?

HI fellow programmers,

Can i connect a textbox to a field in the MySql using the id of the text box? If yes, can u show me a small example.


Thanks
RAM

Hi All,

I have a landing page that I use, but often my sql database is too busy or gets overwhelmed and then the landing page just stalls and traffic is lost.  Here it is:

Code: [Select]
<?php
//ini_set("display_errors",1);
if(!$src) $src = $q;
define("__EXEC_", 1);
include("config.php");
include("custom.php");
function lsp_visit_find($__val, &$__uid) {
global $u;
global $db;
$l_campaign = array("campaign_id"=>"", "url"=>"", "cost"=>"0.00", "name"=>"-", "ad_keyword"=>"", "mapped_keyword"=>"");
$l_visit = array();
$q = $_GET['q'];
$src = $_GET['src'];
// for STAGE #1 (visit definition): get cost, ad keyword, mapped keyword.
$l_campaign['name'] = "info";
$l_campaign['mapped_keyword'] = "$q";
  $l_campaign['ad_keyword'] = "$src";
  $l_campaign['cost'] = ".02";

// get referer (campaign URL). if no campaign found, - create it!
if (!empty($l_campaign['name'])) {
$r = mysql_query("select campaign_id,name from campaign where name='$l_campaign[name]'");
if (!mysql_affected_rows($db)) {
$r = mysql_query("insert into campaign(name,cost, creation_date,last_update_date) values('$l_campaign[name]',$l_campaign[cost], unix_timestamp(),unix_timestamp())");
$l_campaign['campaign_id'] = mysql_insert_id($db);
}
else {

$w = mysql_fetch_assoc($r);
$l_campaign = array_merge($l_campaign,$w);
}
}
// check, whether we had visits from this IP for this keywords within 2 minutes.
// if we have one, get its ID, otherwise - create new!
$visit_id="";
if (!empty($l_campaign['ad_keyword']) && !empty($l_campaign['mapped_keyword']) ) {
$ip = get_real_ip();
$r = mysql_query("select visit_id,uid,campaign_id,ad_keyword,mapped_keyword from visit where ip='$ip' and ad_keyword='$l_campaign[ad_keyword]' and mapped_keyword='$l_campaign[mapped_keyword]' and currtime>=from_unixtime(".(time()-120).") limit 1");
if (!mysql_affected_rows()) {
$__uid = md5($ip.time().$l_campaign['campaign_id']);
$x = mysql_query("insert into visit(ip,uid,cost,currtime,campaign_id,ad_keyword,mapped_keyword)
values('$ip','$__uid',$l_campaign[cost],now(),$l_campaign[campaign_id],'$l_campaign[ad_keyword]','$l_campaign[mapped_keyword]')");
$visit_id = mysql_insert_id($db);
}
else {
$l_visit = mysql_fetch_assoc($r);
$visit_id = $l_visit['visit_id'];
$__uid = $l_visit['uid'];
}
return $visit_id;
}
}
$db = mysql_connect(__CFG_HOSTNAME, __CFG_USERNAME, __CFG_PASSWORD);
mysql_select_db(__CFG_DATABASE, $db);
$u = isset($_GET['u'])? $_GET['u'] : 2;

$uid = "";
$visit_id = lsp_visit_find($_REQUEST['l'], $uid);
if (!empty($visit_id)) {
setcookie("x_uid", base64_encode($visit_id."QQ".$uid), time() + 3600);
}
global $q;
mysql_close($db);
$q = $_GET['q'];
$src = $_GET['src'];
header("Location: http://www.mydomain.com/search/?q=$q");
exit();
?>
My question is how do I code it so that if after 5 seconds or so, or the connection can't be made, it just terminates the connection and auto loads the header redirect at the bottom of the page?

Thanks!

Hello All,

I am fairly new to PHP class development, and I was wondering if it is normal behaviour to see classes not being able to access global variables related to PHP-based requests ($_GET, $_SESSION, etc.)? I seem to either have to use "global <var>" inside of the class to access the data, or I am forced to change the methods so then such required data is passed in as parameters. Perhaps I am just doing something wrong?

Here is an example of what I mean:

class Something
{
       function aFunc()
       {
               if (isset($_SESSION['somedata'])) { return false; } // this always returns false whether I had set the value or not
       }
       function bFunc()
       {
              global $_SESSION; // figured this would already be in a global accessible scope
              if (isset($_SESSION['somedata'])) { return false; } // now this will return false only when the value is set
       }
}


Now the above example is commented to demonstrate what I was meaning above, and I was wondering if this was the 'norm' when developing classes for PHP (and thus such values should be passed as parameters)?

Thanks!

ini_set('display_errors', 1);
error_reporting(E_ALL);

class A
{
    private function operation1() //only be used inside this class
    {
        echo 'operation1 called';
    }
    protected function operation2() //only inside this class
    {
        echo 'operation2 called';
    }
    public function operation3() //public can be used in any class
    {    
        echo 'operation3 called';
    }
}
class B extends A
{
    function _construct()
    {
        //$this->operation1();
        //$this ->operation2();
        $this->operation3();
        
    }
}

$b = new B;


can someone please tell me why this code doesn't work ?

Hi.

I want to know how I access calsses in PHP. I mean how I search for class that I want and need. do I need to search in php.net? and what editors that provide access the the whole php classes and who they keep updated?

Cheers.

Take the following example:


<?php
class a {
var $things;
public function __construct($stuff) {
$this->things = $stuff;
}
}
class b {
var $morethings;
$this->morethings = "something";
}

$c = new a(new b);

echo $c->things->__PARENT__;
?>


The line "echo $c->things->__PARENT__;" (as you can probably imagine) does not work. How would I output what the 'b' object is stored in ('a')?

How can i get my class to be showed on the front page
here is the front page
<?php
require('ex2.php');
$start = new A();
$tart->Display();
?>
now here is ex2.php
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

class A
{
    public $title = "test1";
    public $end = "test2";
}   
function __set($name, $value)
    {
        $this->$name = $value;
    }
function Display()
{
    echo $title;
    echo $end;
}

?>
shoudn't this print test1 and test2 ?

If I have defined an instance of a class in one script how do I then use this same instance and the same variable in other scripts?  For example say I have this code in a file called "index.php"


include("myclass.class.php");

$myclass = new myClass;

$myclass->$variable = "hello world";


However if I then have this code in a file called "page1.php" when I try to access the same variable it is empty. 


include("myclass.class.php");

echo($myclass->$variable)


How can I use the same instance of this class across all files keep the variable values the same?

Thanks for any help. 

I have just start using PHP classes and was wondering how you continue an instance of a class in another file.  For example I have a folder called "includes" where I includes files that I send data to when I perform ajax request.  However how do I continue an instance of class in these files?  Hope that makes sense. 

Thanks for any help. 

Hi, I want to build a simple calculator class and one of the function is to calculate the factorial, but for some reason I cannot get this to work.

Here is class:
=========
Code: [Select]
<?php
class Calculator {

 function factorial($n) {
  if($n==1)
return 1;
  else 
return factorial($n-1)*$n;
 }
}//END CLASS Calculator

$calculator=new Calculator();
print $calculator->factorial(3);
?> 

But it doesn't work, I know this is simple but I am a little rusty with object oriented programming.

I'd appreciated any help!

Hello,

maybe back to basics, but

  [PHP] pobierz, plaintext

Hi there,    This might a newbie question but I need help understanding PHP classes which am currently learning.    I have an index page.    With this three included files.    database.php config.php account.php    on database.php, the class is declared using $connection new Database(...), on this page is also all the coding for this class.   In config.php is a declared class of $account new Account($user_id);   and on account.php is all the details for the account class.    on the index.php is echo $account->sayHello;    However, My page is throwing out an error because I'm trying to use $connection->query(..) in my account.php / Account class.    I have tried to extend the Account class with Database but still have no luck.    How can I make sure the I can use a class function from another page in my Account class?        Thanks for reading

im currently doing a large php project and i am confident i can do it. Its a basic forum like phpbb or mybb where users can download the files and instal. however i have looked through their code and i see they use classes. I have never learned to do classes since i havent had to use them yet. should i be using them now for this project? do i need to? and if so then what are the benefits?