Re: mysqli connections and oop



On Jan 24, 9:17 am, Jerry Stuckle <jstuck...@xxxxxxxxxxxxx> wrote:
Schmidtywrote:
On Jan 24, 8:23 am, "Schmidty" <schmi...@xxxxxxxxxxxxxxxx> wrote:
On Jan 24, 1:26 am, Erwin Moller

<since_humans_read_this_I_am_spammed_too_m...@xxxxxxxxxxxxxxxx> wrote:
Schmidtywrote:
So if I do a $_SERVER['PHP_SELF'] in a function within a class that
will end the execution of that class and restart the same script? Do I
need to do all processing in a script before I display a page that will
have a $_SERVER['PHP_SELF'] action? Thanks for the help...
SchmidtyHi,
Please don't toppost. It destroys the order of the conversation.
$_SERVER['PHP_SELF'] is just a string that contains the script that is being
executed.
I do not understand what 'doing a $_SERVER['PHP_SELF'] in a function' means.
But it will most probably NOT terminated the execution of the script.
exit(); does.
You must clearly see the difference between the server and the client
(browser).
Your script produces a form that will be send back to the client (=browser).
Then your script ends.
The form action in your example posts back to the same script (because you
used the target for the action $_SERVER['PHP_SELF']), so if anybody presses
submit, that form will be posted, and hence the same script will be
executed as before.
But the server or PHP couldn't care less, and thinks of it as just another
call to that script.
http-protocol is stateless, this means that NO lasting connection is build
between the client and the server. To overcome this you must use sessions.
And as Jerry said: connections to a database are NOT fit to store in a
session because PHP destroys all existing connections when the script ends.
So you'll have to rebuild your connection each invocation of a script that
needs a database.
Hope this helps.
Regards,
Erwin Moller
On Jan 23, 4:54 pm, Jerry Stuckle <jstuck...@xxxxxxxxxxxxx> wrote:
Schmidtywrote:
If you do a page reload with $_SERVER['PHP_SELF'] will your program
lose a mysqli connection upon the reload of the page? Would this code
work? I need to know how to carry over a connection between methods as
I am new to OOP? Thanks...
Example; ========================================
<?php
// webpage
$newsignon = new newuser();
logon();
if (isset($_POST['submit'])){
$newsignon = query("SELECT name, password FROM
database");
}
?>
<?php
// class newuser
class newuser {
public $name;
private $passwd;
private $mysqli;
function __construct(){
include('dbconn.php');
$mysqli = new mysqli($dbnet, $dbuser, $dbpass, $dbname);
if (mysqli_connect_errno()){ printf("Can't connect to MySQL
Server. Errorcode: %s\n", mysqli_connect_error());
exit;
}
$this->mysqli = $mysqli; // is this right?
} //end constructor
function query($query){
if ($result = $this->mysqli->real_query($query)){
$result = $this->mysqli->store_result();
if($this->mysqli->error) { echo "ERROR with mysqli stored
procedure";}
} // end if
} // end function
function logon(){
echo "<form action='".$_POST['PHP_SELF']."' method='post' >";
// Would this work?
echo "<input type='text' name='user' /><br /><input
type='password' name='passwd' />";
echo "<input type='submit' value='submit' />";
} // end function
} //end classSchmidty,
As I explained in comp.database.mysql, you can't. Once a page's
processing is completed, all connections (and objects) are released.
You can keep information like user ids, etc. in the $_SESSION variable,
but not the connection. Even if you could keep the connection info in
there, the connection itself will be closed.
Each page is it's own little program. Any external resources opened by
it are closed at the end of the page processing.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@xxxxxxxxxxxxx
==================- Hide quoted text -- Show quoted text -Thanks Erwin
The Google Groups editor places your reponse at the top when making a
reply. I went ahead posted at the bottom for you...

I understand that HTTP is stateless and I have been using sessions
variables and understand that you can't carry a database connection
through either one. I was confused on what happens with an
$_SERVER['HTTP_SELF'] in a script. What I meant by "doing a
$_SERVER['PHP_SELF'] in a function" is having a page echoed in a
function and having the 'action' of that page execute a
$_SERVER['HTTP_SELF']. Does it end a mysqli connection even though you
have not exited the script? Your explanation that $_SERVER['PHP_SELF']
is just a string that contains the script that is being executed makes
sense. I wasn't sure if the connection was being terminated by the
$_SERVER['HTTP_SELF'] variable. Thanks for the help in understanding
this. :)

Schmidty- Hide quoted text -- Show quoted text - > Why is this not working? I keep getting this error;
> Fatal error: Using $this when not in object context in
> c:\Inetpub\glendale\network\admin.class.php on line 68
>
> Here is the code class code;
> ================================================================
>
> <?php
>
> // admin.class.php
>
> class admin{
> public $file_path;
> public $user;
> private $pass;
> public $mysqli;
>
> function __construct($user, $pass){
> $this->user = $user;
> $this->pass = $pass;
> $this->dbConnect();
>
> }
>
> function showNewInfo(){
>
> $query1 = "SELECT userID, fname, minit, lname, address, city, state,
> zip, phone, useremail, ctype, cnumb, exp, recdate FROM personalinfo
> WHERE checked = FALSE";
>
> if ($result = $this->mysqli->real_query($query1)){
> $result = $this->mysqli->store_result();
> if($this->mysqli->error) { echo "ERROR with mysqli stored procedure";}
> } // end if
>
> // Show info of users not updated
> echo "<form action='".$_SERVER['PHP_SELF']."' method='post'><table
> style=\"font: 14px solid #000000; border: 2px solid #CCC000;\">";
> echo "<tr><td colspan='2' style=\"background: #C0C0C5; text-align:
> center; font: 16px solid #000000;\">Credit Card
> Applications</td></tr>";
> echo "<tr><td colspan='2' style=\"background: #FFFFE0; text-align:
> left; font: 11px solid #000000;\">Current info in database:</td></tr>";
> echo "<tr><tr><td colspan='2' style=\"border: 2px solid #000000;
> width: 100%;\">";
>
>
> while($row = $result->fetch_assoc()){
> echo "<input type='checkbox' name='perinfo[]'
> value='".$row['userID']."' >".$row['userID']." : ".$row['lname']." -
> ".$row['recdate']."<br />";
> } // end while
> echo "</td></tr><tr>";
> echo "<td align=\"center\"><input style=\"font: 10px solid #000000;\"
> type=\"submit\" value=\"UPDATE INFO\" name='updatedb' /></td><td
> style=\"text-align: center;\"><input type=\"reset\" style=\"font: 10px
> solid #000000;\" value=\"RESET CHOICES\" /></td></tr></form></table>";
>
> $result->free();
> } // end function
>
>
> function dbConnect(){
> include('dbconn.php');
> $mysqli = new mysqli($dbnet, $dbuser, $dbpass, $dbname) or die("ERROR:
> Cannot connect to database server");
>
> if (mysqli_connect_errno()){ printf("Can't connect to MySQL Server.
> Errorcode: %s\n", mysqli_connect_error());
> exit;
> }
> $this->mysqli = $mysqli;
>
>
> } // end function dbConnect
>
> function dbClose(){
> $this->mysqli->close();
> } // end function dbClose
>
>
> function updateDB($perinfo){
> foreach($perinfo as $info);
> $query3= "UPDATE personalinfo SET checked = 'TRUE' WHERE userID =
> $info";
>
> if (isset($this->mysqli)) {echo "ERROR on mysqli";
> exit;}
>
> $result = $this->mysqli->query($query3);
> echo "QUERY DONE";
> $result->free();
> return true;
> } // end function updateDB
> } // end class
> ?>
>
> And here is the script that execute this
>
---------------------------------------------------------------------------­-----------------
> <?php
> print "<br />Hello <b>'$user'</b>.<br />";
> print "You are ";
> if ($type =='administrator'){
> $file_path = $_POST['file_path'] = '';
>
> // Administrators
> echo "an <b style='color: #FF0000;'>$type</b> and have full
> administration rights.<br />";
> $user = new admin($user, $pass);
> $user->showNewInfo();
> if (isset($_POST['updatedb'])){ admin::updateDB($_POST['perinfo']); }
> }
> End example
> ===============================================================
>
> Thanks for the help.
>
>Schmidty
>

(Top posting fixed)

Off hand, I would say your problem is in the line:

admin::updateDB($_POST['perinfo']);

This is calling the function as a class member, not as an object member.
The '::' syntax doesn't pass a $this variable.

Try $user->updateDB($_POST['perinfo']); instead.

If that isn't it, which line gets the error?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@xxxxxxxxxxxxx
==================- Hide quoted text -- Show quoted text -


Jerry,

I went ahead and rewrote these two scripts and actually did what you
suggested before I saw your reply (I'm learning slowly but surely) and
it did work but now I am up against a problem with the mysqli
connection. I am getting the error (per my validation) "ERROR: Could
not execute query." from the third line in the function;

Code Example ===================================================

public function updatedb($userID){
if (!$this->mysqli){ echo "ERROR: Database connection lost.";
$query2 = "UPDATE personalinfo SET checked = 'TRUE' WHERE userID =
'$userID'";
$this->mysqli->query($query2) or die("ERROR: Could not execute
query.");
} // end function

End Example ====================================================

I had constructed the dbConnect() function when the 'admin' class was
executed. Why does it not carry the mysqli connection? I had assigned a
property with the connection variable in the dbConnect() method. What
happened?

Code Example ===================================================

public function dbConnect(){
include('dbconn.php');
$mysqli = new mysqli($dbnet, $dbuser, $dbpass, $dbname);

if (mysqli_connect_errno()){ printf("Can't connect to MySQL Server.
Errorcode: %s\n", mysqli_connect_error());
exit;
} // end if
return $this->mysqli=$mysqli;
} // end function

End Example =====================================================

Did I do right with the line 'return $this->mysqli=$mysqli;' to set the
connection variable to be used later in the function 'updatedb()'?

Hope the examples above help and thanks for any suggestions you might
provide. :)

Schmidty

.

Relevant Pages

  • Re: dialup solution (as seconary connection / iptables )
    ... ip-down is launched by pppd only after the PPP link no longer available ... first with MINICOM or is PAP and script not mutualy exclusive? ... do have to "make the connection first with MINICOM." ... If you use the Linux box and route the news IP address to it on each ...
    (comp.os.linux.networking)
  • Re: mysqli connections and oop
    ... need to do all processing in a script before I display a page that will ... But it will most probably NOT terminated the execution of the script. ... this means that NO lasting connection is build ... Why does it not carry the mysqli connection? ...
    (comp.lang.php)
  • Re: mysqli connections and oop
    ... And here is the script that execute this ... lose a mysqli connection upon the reload of the page? ...
    (comp.lang.php)
  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... How does it relate to e.g. a script performing a large mysql query? ... 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)
  • Re: Keeping pppd alive--how?
    ... >>wrote a script to dial up my ISP, wait 40 seconds, then start up Jay's ... Perhaps using the netstat command to do ... >options tab is an option to redial is connection is lost. ... My Linux machine is text only--no GUIs. ...
    (alt.os.linux.redhat)