PHP-MySQL connection for particular module

Hello,

First of all, please, have in mind that I am new in this business.

I have a problem connecting with data base in one particular module. That's
right. The rest of the modules can connect to db, update tables with new
info but this one is refusing giving me message like this:

"Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\login.php on line 17

Warning: mysql_query() [function.mysql-query]: A link to the server could
not be established in
D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on
line 17"


It is a authentication module and this is the fragment of the code which is
giving me a hard time:

************************************************************ *******************
include $_SERVER['DOCUMENT_ROOT'].
'/layout.php';

switch($_REQUEST['req']){

case "validate":

$validate = mysql_query("SELECT * FROM members
WHERE username = '{$_POST['username']}'
AND password = md5('{$_POST['password']}')"
);

etc....

************************************************************ *******************

My platform is WinXP on drive F:\ (I have Win'98 on C:\) and as you can see
my program files are on D:\. All this may not be important but I listed
anyway.
It is installed Apache 2.2.6 using windows installer, PHP 5.2.6 (I just
replaced 5.2.5 hoping to fix the problem), and MySQL 5.0.45.

I am using persisten connection which should be on until you restart the
server. I have a file included in every page for connection with MySQL and
data base.
PHP manual says that "mysql_query" reuses the existing connection or try to
create one if not present (I think, according to the warning is trying to
create one).
I had been checking after each step using phpinfo() if the connection is
there and it's there but for some reason the above fragment does not work.
As I mentioned above the rest of my modules are working fine with mysql.

I checked the "php.ini" file. I compared it to "php.ini.recomended" from the
..zip distribusion package and they are almost identical exept couple of
things for error reporting.
I, also checked FAQ, mail listings and other forums but it does not seem
anybody had a similar problem.

In one of my tests I included a line for connection just before the problem
lines, as described below, and it worked but my intention is to keep such
lines in a separate files and include them in every page instead.

************************************************************ *******************
........

$link = mysql_pconnect('localhost', 'root', 'testing');


$validate = mysql_query("SELECT * FROM members
WHERE username = '{$_POST['username']}'
AND password = md5('{$_POST['password']}')"
);
etc.
************************************************************ *******************

As I metioned, this is an authentication module and, may be, that's why is
behaving diferently from the rest or I need to do some setup changes in
"php.ini" which I am not familiar with.

If anyone has had simmilar problem I would appreciate his/her input. Please,
help me resolve this mistery.

--
View this message in context: http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17915108.html
Sent from the Php - Database mailing list archive at Nabble.com.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

------=_Part_23196_30571700.1213716696611
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

If you get an error of this kind:

"Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\login.php on line 17

Warning: mysql_query() [function.mysql-query]: A link to the server could
not be established in
D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on
line 17"

It means that either your mysql conenction details are not correctly set or
the connection resource isn't accessible for your mysql functions. I suggest
you first try by replacing:

$link = mysql_pconnect('localhost', 'root', 'testing');

into:

mysql_pconnect('localhost', 'root', 'testing');

On 6/17/08, bateivan wrote:
>
>
> Hello,
>
> First of all, please, have in mind that I am new in this business.
>
> I have a problem connecting with data base in one particular module. That's
> right. The rest of the modules can connect to db, update tables with new
> info but this one is refusing giving me message like this:
>
> "Warning: mysql_query() [function.mysql-query]: Access denied for user
> 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache
> Software
> Foundation\Apache2.2\htdocs\login.php on line 17
>
> Warning: mysql_query() [function.mysql-query]: A link to the server could
> not be established in
> D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on
> line 17"
>
>
> It is a authentication module and this is the fragment of the code which is
> giving me a hard time:
>
>
> ************************************************************ *******************
> > include $_SERVER['DOCUMENT_ROOT'].
> '/layout.php';
>
> switch($_REQUEST['req']){
>
> case "validate":
>
> $validate = mysql_query("SELECT * FROM members
> WHERE username = '{$_POST['username']}'
> AND password = md5('{$_POST['password']}')"
> );
>
> etc....
>
>
> ************************************************************ *******************
>
> My platform is WinXP on drive F:\ (I have Win'98 on C:\) and as you can see
> my program files are on D:\. All this may not be important but I listed
> anyway.
> It is installed Apache 2.2.6 using windows installer, PHP 5.2.6 (I just
> replaced 5.2.5 hoping to fix the problem), and MySQL 5.0.45.
>
> I am using persisten connection which should be on until you restart the
> server. I have a file included in every page for connection with MySQL and
> data base.
> PHP manual says that "mysql_query" reuses the existing connection or try to
> create one if not present (I think, according to the warning is trying to
> create one).
> I had been checking after each step using phpinfo() if the connection is
> there and it's there but for some reason the above fragment does not work.
> As I mentioned above the rest of my modules are working fine with mysql.
>
> I checked the "php.ini" file. I compared it to "php.ini.recomended" from
> the
> .zip distribusion package and they are almost identical exept couple of
> things for error reporting.
> I, also checked FAQ, mail listings and other forums but it does not seem
> anybody had a similar problem.
>
> In one of my tests I included a line for connection just before the problem
> lines, as described below, and it worked but my intention is to keep such
> lines in a separate files and include them in every page instead.
>
>
> ************************************************************ *******************
> .......
>
> $link = mysql_pconnect('localhost', 'root', 'testing');
>
>
> $validate = mysql_query("SELECT * FROM members
> WHERE username = '{$_POST['username']}'
> AND password = md5('{$_POST['password']}')"
> );
> etc.
>
> ************************************************************ *******************
>
> As I metioned, this is an authentication module and, may be, that's why is
> behaving diferently from the rest or I need to do some setup changes in
> "php.ini" which I am not familiar with.
>
> If anyone has had simmilar problem I would appreciate his/her input.
> Please,
> help me resolve this mistery.
>
> --
> View this message in context:
> http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17915108.html
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
Isaak Malik
Web Developer

------=_Part_23196_30571700.1213716696611--

Re: PHP-MySQL connection for particular module

----------------------------------------------------
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
----- Original Message -----=20
From: "bateivan"
To:
Sent: Tuesday, June 17, 2008 11:19 PM
Subject: [PHP-DB] PHP-MySQL connection for particular module


:=20
: Hello,
:=20
: First of all, please, have in mind that I am new in this business.
:=20
: I have a problem connecting with data base in one particular module. =
That's
: right. The rest of the modules can connect to db, update tables with =
new
: info but this one is refusing giving me message like this:
:=20
: "Warning: mysql_query() [function.mysql-query]: Access denied for user
: 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache =
Software
: Foundation\Apache2.2\htdocs\login.php on line 17
:=20

This error message state that you have provided a wrong username and / =
or password
use the die also to ensure the connection was created.

: Warning: mysql_query() [function.mysql-query]: A link to the server =
could
: not be established in
: D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php =
on
: line 17"
:=20
:=20
: It is a authentication module and this is the fragment of the code =
which is
: giving me a hard time:
:=20
: =
************************************************************ *************=
******
: : include $_SERVER['DOCUMENT_ROOT'].
: '/layout.php';
:=20

Let's your included page on the same directory. Say f:\webroot\docroot
As
f:\webroot\docroot\layout.php
f:\webroot\docroot\login.php

then try change the line from

include $_SERVER['DOCUMENT_ROOT'].
'/layout.php';

to

$app_root =3D './';
include ($app_root . 'layout.php');


: switch($_REQUEST['req']){=20
: =20
: case "validate":
:=20
: $validate =3D mysql_query("SELECT * FROM members
: WHERE username =3D '{$_POST['username']}'
: AND password =3D =
md5('{$_POST['password']}')"
: );
:=20
: etc....
:=20
: =
************************************************************ *************=
******
:=20
: My platform is WinXP on drive F:\ (I have Win'98 on C:\) and as you =
can see
: my program files are on D:\. All this may not be important but I =
listed
: anyway.
: It is installed Apache 2.2.6 using windows installer, PHP 5.2.6 (I =
just
: replaced 5.2.5 hoping to fix the problem), and MySQL 5.0.45.
:=20
: I am using persisten connection which should be on until you restart =
the
: server. I have a file included in every page for connection with MySQL =
and
: data base.
: PHP manual says that "mysql_query" reuses the existing connection or =
try to
: create one if not present (I think, according to the warning is trying =
to
: create one).
: I had been checking after each step using phpinfo() if the connection =
is
: there and it's there but for some reason the above fragment does not =
work.
: As I mentioned above the rest of my modules are working fine with =
mysql.
:=20
: I checked the "php.ini" file. I compared it to "php.ini.recomended" =
from the
: .zip distribusion package and they are almost identical exept couple =
of
: things for error reporting.
: I, also checked FAQ, mail listings and other forums but it does not =
seem
: anybody had a similar problem.
:=20
: In one of my tests I included a line for connection just before the =
problem
: lines, as described below, and it worked but my intention is to keep =
such
: lines in a separate files and include them in every page instead.
:=20
: =
************************************************************ *************=
******
: .......
:=20
: $link =3D mysql_pconnect('localhost', 'root', 'testing');
:=20
:=20
: $validate =3D mysql_query("SELECT * FROM members
: WHERE username =3D '{$_POST['username']}'
: AND password =3D =
md5('{$_POST['password']}')"
: );
: etc.
: =
************************************************************ *************=
******
:=20
: As I metioned, this is an authentication module and, may be, that's =
why is
: behaving diferently from the rest or I need to do some setup changes =
in
: "php.ini" which I am not familiar with.
:=20
: If anyone has had simmilar problem I would appreciate his/her input. =
Please,
: help me resolve this mistery.
:=20
: --=20
: View this message in context: =
http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp179151=
08p17915108.html
: Sent from the Php - Database mailing list archive at Nabble.com.
:=20
:=20
: --=20
: PHP Database Mailing List (http://www.php.net/)
: To unsubscribe, visit: http://www.php.net/unsub.php
:

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

> It means that either your mysql conenction details are not correctly set or
> the connection resource isn't accessible for your mysql functions. I suggest
> you first try by replacing:
>
> $link = mysql_pconnect('localhost', 'root', 'testing');
>
> into:
>
> mysql_pconnect('localhost', 'root', 'testing');

Why? How is that going to help fix the problem?

Personally I'd say to *not* use persistent connections as it will cause
you problems later.

Use a normal connection:

$link = mysql_connect($server, $user, $pass);

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

excuseme but, you can access by terminal? [shell]

ODBC is the user? or is a ODBC database?

Please answer me and i can help you.

**Excuse me my english is bad. :(

El 17/06/2008, a las 06:51 p.m., Chris escribi=F3:

>
>> It means that either your mysql conenction details are not =20
>> correctly set or
>> the connection resource isn't accessible for your mysql functions. =20=

>> I suggest
>> you first try by replacing:
>>
>> $link =3D mysql_pconnect('localhost', 'root', 'testing');
>>
>> into:
>>
>> mysql_pconnect('localhost', 'root', 'testing');
>
> Why? How is that going to help fix the problem?
>
> Personally I'd say to *not* use persistent connections as it will =20
> cause
> you problems later.
>
> Use a normal connection:
>
> $link =3D mysql_connect($server, $user, $pass);
>
> --=20
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

------=_Part_692_18641239.1213788210819
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Because then the connection resource isn't stored in the $link variable and
you will be able to use the mysql functions without passing that variable to
each function.

On Wed, Jun 18, 2008 at 1:51 AM, Chris wrote:

>
> > It means that either your mysql conenction details are not correctly set
> or
> > the connection resource isn't accessible for your mysql functions. I
> suggest
> > you first try by replacing:
> >
> > $link = mysql_pconnect('localhost', 'root', 'testing');
> >
> > into:
> >
> > mysql_pconnect('localhost', 'root', 'testing');
>
> Why? How is that going to help fix the problem?
>
> Personally I'd say to *not* use persistent connections as it will cause
> you problems later.
>
> Use a normal connection:
>
> $link = mysql_connect($server, $user, $pass);
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>



--
Isaak Malik
Web Developer

------=_Part_692_18641239.1213788210819--

Re: PHP-MySQL connection for particular module

------=_Part_723_16569272.1213788780284
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

You're very welcome, I understand that you need a solution which allows you
to keep using the connection this way.

I doubt that your php.ini is the cause so I'll suggest the following:

Try executing your MySQL queries by passing the $link variable to the
function as the connection resource:

mysql_query("SELECT...", $link);

Something that also might cause it is that you use (include|require)_once
and that this module doesn't have access to the connection resource, if this
is the case change it into include|require and see if that solves your
issue. If not then could you please post some example code of your module if
possible so we can be more helpful?

Also be sure that you global $link; it in functions (I don't know if this
required since I didn't use it this way for a long while).

Could you also please answer to the list instead of directly to me as this
might also be informative for others.

On Tue, Jun 17, 2008 at 10:49 PM, wrote:

> Thank you Isaak for interest in my subject.
>
> I have my connection set in a separate file which is included into the
> page. All my modules work except this one.
> When I use the following line
> $link = mysql_pconnect('localhost', 'root', 'testing');
> actually, my module starts working which is a redundant line as long as I
> have all this set in my include file.
> The thing is that I would like to keep this code in an included file for
> clearness and readability and make it work.
>
> Any idea why this is happening only to this module. May be, it requires
> change of some settings in php.ini or I am doing something wrong but the
> code is actually working when I introduce the line above.
> Tanx
>
> Isaak Malik-3 wrote:
> >
> > If you get an error of this kind:
> >
> > "Warning: mysql_query() [function.mysql-query]: Access denied for user
> > 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache
> > Software
> > Foundation\Apache2.2\htdocs\login.php on line 17
> >
> > Warning: mysql_query() [function.mysql-query]: A link to the server could
> > not be established in
> > D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on
> > line 17"
> >
> > It means that either your mysql conenction details are not correctly set
> > or
> > the connection resource isn't accessible for your mysql functions. I
> > suggest
> > you first try by replacing:
> >
> > $link = mysql_pconnect('localhost', 'root', 'testing');
> >
> > into:
> >
> > mysql_pconnect('localhost', 'root', 'testing');
> >
> > On 6/17/08, bateivan wrote:
> >>
> >>
> >> Hello,
> >>
> >> First of all, please, have in mind that I am new in this business.
> >>
> >> I have a problem connecting with data base in one particular module.
> >> That's
> >> right. The rest of the modules can connect to db, update tables with new
> >> info but this one is refusing giving me message like this:
> >>
> >> "Warning: mysql_query() [function.mysql-query]: Access denied for user
> >> 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache
> >> Software
> >> Foundation\Apache2.2\htdocs\login.php on line 17
> >>
> >> Warning: mysql_query() [function.mysql-query]: A link to the server
> could
> >> not be established in
> >> D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php
> on
> >> line 17"
> >>
> >>
> >> It is a authentication module and this is the fragment of the code which
> >> is
> >> giving me a hard time:
> >>
> >>
> >>
> ************************************************************ *******************
> >> > >> include $_SERVER['DOCUMENT_ROOT'].
> >> '/layout.php';
> >>
> >> switch($_REQUEST['req']){
> >>
> >> case "validate":
> >>
> >> $validate = mysql_query("SELECT * FROM members
> >> WHERE username = '{$_POST['username']}'
> >> AND password = md5('{$_POST['password']}')"
> >> );
> >>
> >> etc....
> >>
> >>
> >>
> ************************************************************ *******************
> >>
> >> My platform is WinXP on drive F:\ (I have Win'98 on C:\) and as you can
> >> see
> >> my program files are on D:\. All this may not be important but I listed
> >> anyway.
> >> It is installed Apache 2.2.6 using windows installer, PHP 5.2.6 (I just
> >> replaced 5.2.5 hoping to fix the problem), and MySQL 5.0.45.
> >>
> >> I am using persisten connection which should be on until you restart the
> >> server. I have a file included in every page for connection with MySQL
> >> and
> >> data base.
> >> PHP manual says that "mysql_query" reuses the existing connection or try
> >> to
> >> create one if not present (I think, according to the warning is trying
> to
> >> create one).
> >> I had been checking after each step using phpinfo() if the connection is
> >> there and it's there but for some reason the above fragment does not
> >> work.
> >> As I mentioned above the rest of my modules are working fine with mysql.
> >>
> >> I checked the "php.ini" file. I compared it to "php.ini.recomended" from
> >> the
> >> .zip distribusion package and they are almost identical exept couple of
> >> things for error reporting.
> >> I, also checked FAQ, mail listings and other forums but it does not seem
> >> anybody had a similar problem.
> >>
> >> In one of my tests I included a line for connection just before the
> >> problem
> >> lines, as described below, and it worked but my intention is to keep
> such
> >> lines in a separate files and include them in every page instead.
> >>
> >>
> >>
> ************************************************************ *******************
> >> .......
> >>
> >> $link = mysql_pconnect('localhost', 'root', 'testing');
> >>
> >>
> >> $validate = mysql_query("SELECT * FROM members
> >> WHERE username = '{$_POST['username']}'
> >> AND password = md5('{$_POST['password']}')"
> >> );
> >> etc.
> >>
> >>
> ************************************************************ *******************
> >>
> >> As I metioned, this is an authentication module and, may be, that's why
> >> is
> >> behaving diferently from the rest or I need to do some setup changes in
> >> "php.ini" which I am not familiar with.
> >>
> >> If anyone has had simmilar problem I would appreciate his/her input.
> >> Please,
> >> help me resolve this mistery.
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17915108.html
> >> Sent from the Php - Database mailing list archive at Nabble.com.
> >>
> >>
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >>
> >
> > --
> > Isaak Malik
> > Web Developer
> >
> >
> Quoted from:
>
> http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17916593.html
>
>
--
Isaak Malik
Web Developer

------=_Part_723_16569272.1213788780284--

Re: PHP-MySQL connection for particular module

Thank you, Chris,

I tried your suggestion using regular connection. Unfortunately, I got the
same result.
See my reply to Isaak,s reply where I am going to post portion of my code to
visualize what I am talking about.

Thanx again


chris smith-9 wrote:
>
>
>> It means that either your mysql conenction details are not correctly set
>> or
>> the connection resource isn't accessible for your mysql functions. I
>> suggest
>> you first try by replacing:
>>
>> $link = mysql_pconnect('localhost', 'root', 'testing');
>>
>> into:
>>
>> mysql_pconnect('localhost', 'root', 'testing');
>
> Why? How is that going to help fix the problem?
>
> Personally I'd say to *not* use persistent connections as it will cause
> you problems later.
>
> Use a normal connection:
>
> $link = mysql_connect($server, $user, $pass);
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

--
View this message in context: http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17989584.html
Sent from the Php - Database mailing list archive at Nabble.com.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

Hello,

To answer these qwestions:
1. I am using "include" in my code.
2. About the "$link =3D mysql_connect('localhost', 'root', 'testing');"
variable. I can just include this line before mysql_query function and it
works even without entering into mysql_query the "$link" variable. (Like th=
e
connection is waking up).
3.My php.ini register_globals is off as suggested for new versions of PHP
but include file should work instead according to the manual.
4. I am posting some of my code to compare. Module "carmade.php" works v.s.
"login.php" which does not. Also, I am posting my "database.php" which is
establishing the connection and is included in every page through
"layout.php"->"common.php"->"database.php".

carmade.php:
include $_SERVER['DOCUMENT_ROOT'].
'/layout.php';

// Quick Login session check =20
login_check();
=20
switch($_REQUEST['req']){
// Insert Case
case "create_carmade":
myheader("Добавяне н=D0=
° автомобилн и =D0=
¼Ð°Ñ€ÐºÐ=B8 в списък=D0=
°");
=20
// Double check form posted values are there
// before performing INSERT query
if(!$_POST['car_descr']){
echo '

Липсва =D0=
¸Ð½Ñ„Ð¾Ñ€Ð¼Ð°Ñ†Ð¸ÑÑ ‚Ñ=8F =D0=
¾Ñ=82 формата!

Моля, изп=D0=
¾Ð»Ð·Ð²Ð°Ð¹Ñ‚Ð=B5 буто=D0=
½Ð°'.
'Назад и въве=D0=
´ÐµÑ‚Ð=B5 данните о=D1=
‚новÐ=BE!

Маркат=D0=
° "'.$_POST['car_descr'].
'"е въведена
с=
номер:'.mysql_insert_id();
echo '
/admin/carmade.php?req=3Dnew_carmade Ис=D0=
ºÐ°Ñ‚Ð=B5 ли да'.
=09'въведете др=D1=
ƒÐ³Ð° марка? ';
}=20
break;
=20
// Create car made form case
case "new_carmade":
myheader("Въвеждан=D 0=B5 =D0=
½Ð° нова автомо=D0=
±Ð¸Ð»Ð½Ð° марка");
include $_SERVER['DOCUMENT_ROOT'].
'/html/forms/carmade_insert.html';
footer();
break;
=20
default:
myheader("Админист=D 1€Ð=
¸Ñ€Ð°Ð½Ð=B5 на списъ=D0=
ºÐ° с автомобил=D0=
½Ð¸Ñ‚Ð=B5 марки");
include $_SERVER['DOCUMENT_ROOT'].
'/html/carmade_admin.html';
footer();
break;
=20
}
?>

login.php:
include $_SERVER['DOCUMENT_ROOT'].
'/layout.php';


switch($_REQUEST['req']){=20
=20
case "validate":

$validate =3D mysql_query("SELECT * FROM members
WHERE username =3D '{$_POST['username']}'
AND password =3D md5('{$_POST['password']}')"
);

$num_rows =3D mysql_num_rows($validate);

if($num_rows == 1){
while($row =3D mysql_fetch_assoc($validate)){
$_SESSION['login'] =3D true;
$_SESSION['userid'] =3D $row['member_id'];
$_SESSION['first_name'] =3D $row['first_name'];
$_SESSION['last_name'] =3D $row['last_name'];
$_SESSION['email_address'] =3D $row['email_address'];
=20
if($row['admin_access'] == 1){
$_SESSION['admin_access'] =3D true;
}
$login_time =3D mysql_query("UPDATE members
SET last_login=3Dnow()
WHERE id=3D'{$row['id']}'");
}
header("Location: /loggedin.php");
} else {
myheader("Входът в ад=D0=
¼Ð¸Ð½Ð¸ÑÑ‚ратиР²Ð½Ð°=
та зона е неусп=
ешен!");
echo '

Входът в=
страницата не =
е успешен!

Провере=
те потребител =
ското си '.
'име и парола=
та си и опитайт=
е пак или се '.
'обадете на а=
дминистрат ор=D0=
°.

Re: PHP-MySQL connection for particular module

UGFzdGViaW4gd29ya3MgbG90cyBiZXR0ZXIgd2hlbiB5b3UncmUgcG9zdGlu ZyBjb2RlOiB3d3cu
cGFzdGViaW4uY29tCgpJIGRvbid0IHNlZSB5b3VyIGRhdGFiYXNlLnBocCBp bmNsdWRlZCBpbiBi
b3RoIG9mIHRoZXNlIG1vZHVsZXMuIFdoZXJlCmRvIHlvdSBpbmNsdWRlIGl0 PwoKRVZlcnQKCk9u
IFdlZCwgSnVuIDE4LCAyMDA4IGF0IDk6MzggUE0sIGJhdGVpdmFuIDxpdmFu b3ZpdmFuc0B5YWhv
by5jYT4gd3JvdGU6Cj4KPiBIZWxsbywKPgo+IFRvIGFuc3dlciB0aGVzZSBx d2VzdGlvbnM6Cj4g
MS4gSSBhbSB1c2luZyAiaW5jbHVkZSIgaW4gbXkgY29kZS4KPiAyLiBBYm91 dCB0aGUgIiRsaW5r
ID0gbXlzcWxfY29ubmVjdCgnbG9jYWxob3N0JywgJ3Jvb3QnLCAndGVzdGlu ZycpOyIKPiB2YXJp
YWJsZS4gSSBjYW4ganVzdCBpbmNsdWRlIHRoaXMgbGluZSBiZWZvcmUgbXlz cWxfcXVlcnkgZnVu
Y3Rpb24gYW5kIGl0Cj4gd29ya3MgZXZlbiB3aXRob3V0IGVudGVyaW5nIGlu dG8gbXlzcWxfcXVl
cnkgdGhlICIkbGluayIgdmFyaWFibGUuIChMaWtlIHRoZQo+IGNvbm5lY3Rp b24gaXMgd2FraW5n
IHVwKS4KPiAzLk15IHBocC5pbmkgcmVnaXN0ZXJfZ2xvYmFscyBpcyBvZmYg YXMgc3VnZ2VzdGVk
IGZvciBuZXcgdmVyc2lvbnMgb2YgUEhQCj4gYnV0IGluY2x1ZGUgZmlsZSBz aG91bGQgd29yayBp
bnN0ZWFkIGFjY29yZGluZyB0byB0aGUgbWFudWFsLgo+IDQuIEkgYW0gcG9z dGluZyBzb21lIG9m
IG15IGNvZGUgdG8gY29tcGFyZS4gTW9kdWxlICJjYXJtYWRlLnBocCIgd29y a3Mgdi5zLgo+ICJs
b2dpbi5waHAiIHdoaWNoIGRvZXMgbm90LiBBbHNvLCBJIGFtIHBvc3Rpbmcg bXkgImRhdGFiYXNl
LnBocCIgd2hpY2ggaXMKPiBlc3RhYmxpc2hpbmcgdGhlIGNvbm5lY3Rpb24g YW5kIGlzIGluY2x1
ZGVkIGluIGV2ZXJ5IHBhZ2UgdGhyb3VnaAo+ICJsYXlvdXQucGhwIi0+ImNv bW1vbi5waHAiLT4i
ZGF0YWJhc2UucGhwIi4KPgo+IGNhcm1hZGUucGhwOgo+IDw/cGhwCj4gaW5j bHVkZSAkX1NFUlZF
UlsnRE9DVU1FTlRfUk9PVCddLgo+ICAgICAgICAnL2xheW91dC5waHAnOwo+ Cj4gLy8gUXVpY2sg
TG9naW4gc2Vzc2lvbiBjaGVjawo+IGxvZ2luX2NoZWNrKCk7Cj4KPiBzd2l0 Y2goJF9SRVFVRVNU
WydyZXEnXSl7Cj4gICAvLyBJbnNlcnQgQ2FzZQo+ICAgY2FzZSAiY3JlYXRl X2Nhcm1hZGUiOgo+
ICAgICBteWhlYWRlcigi0JTQvtCx0LDQstGP0L3QtSDQvdCwINCw0LLRgtC+ 0LzQvtCx0LjQu9C9
0Lgg0LzQsNGA0LrQuCDQsiDRgdC/0LjRgdGK0LrQsCIpOwo+Cj4gICAgIC8v IERvdWJsZSBjaGVj
ayBmb3JtIHBvc3RlZCB2YWx1ZXMgYXJlIHRoZXJlCj4gICAgIC8vIGJlZm9y ZSBwZXJmb3JtaW5n
IElOU0VSVCBxdWVyeQo+ICAgICBpZighJF9QT1NUWydjYXJfZGVzY3InXSl7 Cj4gICAgICAgICBl
Y2hvICc8cCBhbGlnbj0iY2VudGVyIj7Qm9C40L/RgdCy0LAg0LjQvdGE0L7R gNC80LDRhtC40Y/R
gtGPINC+0YIg0YTQvtGA0LzQsNGC0LAhPC9wPicuCj4gICAgICAgICAgICAg ICAgICc8cCBhbGln
bj0iY2VudGVyIj7QnNC+0LvRjywg0LjQt9C/0L7Qu9C30LLQsNC50YLQtSDQ sdGD0YLQvtC90LAn
Lgo+ICAgICAgICAgICAgICAgICAn0J3QsNC30LDQtCDQuCDQstGK0LLQtdC0 0LXRgtC1INC00LDQ
vdC90LjRgtC1INC+0YLQvdC+0LLQviE8L3A+JzsKPiAgICAgICAgICAgICAg ICAgIGZvb3Rlcigp
Owo+ICAgICAgICAgZXhpdCgpOwo+ICAgICB9Cj4KPiAgICAgLy8gSW5zZXJ0 IFF1ZXJ5Cj4gICAg
ICRzcWwgPSBteXNxbF9xdWVyeSgiSU5TRVJUIElOVE8gY2FybWFkZQo+ICAg ICAgICAgICAgICAg
ICAoY2FyX2Rlc2NyKQo+ICAgICAgICAgICAgICAgICBWQUxVRVMoJ3skX1BP U1RbJ2Nhcl9kZXNj
ciddfScpIik7Cj4KPiAgICAgLy8gSW5zZXJ0IHF1ZXJ5IHJlc3VsdHMKPiAg ICAgaWYoISRzcWwp
ewo+ICAgICAgICAgZWNobyAi0JPRgNC10YjQutCwINC/0YDQuCDQstGK0LLQ tdC20LTQsNC90LUg
0L3QsCDQtNCw0L3QvdC40YLQtToiLm15c3FsX2Vycm9yKCk7Cj4gICAgIH0g ZWxzZSB7Cj4KPiAg
ICAgICAgIGVjaG8gJzxwIGFsaWduPSJjZW50ZXIiPtCc0LDRgNC60LDRgtCw ICInLiRfUE9TVFsn
Y2FyX2Rlc2NyJ10uCj4gICAgICAgICAgICAgICAgICci0LUg0LLRitCy0LXQ tNC10L3QsDxici8+
0YEg0L3QvtC80LXRgDonLm15c3FsX2luc2VydF9pZCgpOwo+ICAgICAgICAg ZWNobyAnPGJyIC8+
IC9hZG1pbi9jYXJtYWRlLnBocD9yZXE9bmV3X2Nhcm1hZGUg0JjRgdC60LDR gtC1INC70Lgg0LTQ
sCcuCj4gICAgICAgICAgICAgICAgICAgICAgICAn0LLRitCy0LXQtNC10YLQ tSDQtNGA0YPQs9Cw
INC80LDRgNC60LA/ICc7Cj4gICAgIH0KPiAgIGJyZWFrOwo+Cj4gICAvLyBD cmVhdGUgY2FyIG1h
ZGUgZm9ybSBjYXNlCj4gICBjYXNlICJuZXdfY2FybWFkZSI6Cj4gICAgICBt eWhlYWRlcigi0JLR
itCy0LXQttC00LDQvdC1INC90LAg0L3QvtCy0LAg0LDQstGC0L7QvNC+0LHQ uNC70L3QsCDQvNCw
0YDQutCwIik7Cj4gICAgICBpbmNsdWRlICRfU0VSVkVSWydET0NVTUVOVF9S T09UJ10uCj4gICAg
ICAgICAgICAgICcvaHRtbC9mb3Jtcy9jYXJtYWRlX2luc2VydC5odG1sJzsK PiAgICAgIGZvb3Rl
cigpOwo+ICAgYnJlYWs7Cj4KPiAgIGRlZmF1bHQ6Cj4gICAgICBteWhlYWRl cigi0JDQtNC80LjQ
vdC40YHRgtGA0LjRgNCw0L3QtSDQvdCwINGB0L/QuNGB0YrQutCwINGBINCw 0LLRgtC+0LzQvtCx
0LjQu9C90LjRgtC1INC80LDRgNC60LgiKTsKPiAgICAgIGluY2x1ZGUgJF9T RVJWRVJbJ0RPQ1VN
RU5UX1JPT1QnXS4KPiAgICAgICAgICAgICAgJy9odG1sL2Nhcm1hZGVfYWRt aW4uaHRtbCc7Cj4g
ICAgICBmb290ZXIoKTsKPiAgIGJyZWFrOwo+Cj4gfQo+ID8+Cj4KPiBsb2dp bi5waHA6Cj4gPD9w
aHAKPiBpbmNsdWRlICRfU0VSVkVSWydET0NVTUVOVF9ST09UJ10uCj4gICAg ICAgICcvbGF5b3V0
LnBocCc7Cj4KPgo+IHN3aXRjaCgkX1JFUVVFU1RbJ3JlcSddKXsKPgo+IGNh c2UgInZhbGlkYXRl
IjoKPgo+ICAgJHZhbGlkYXRlID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZS T00gbWVtYmVycwo+
ICAgICAgICAgICAgICAgICAgICAgICAgICAgV0hFUkUgdXNlcm5hbWUgPSAn eyRfUE9TVFsndXNl
cm5hbWUnXX0nCj4gICAgICAgICAgICAgICAgICAgICAgICAgICBBTkQgcGFz c3dvcmQgPSBtZDUo
J3skX1BPU1RbJ3Bhc3N3b3JkJ119JykiCj4gICAgICAgICAgICAgICAgICAg ICAgICAgICApOwo+
Cj4gICAkbnVtX3Jvd3MgPSBteXNxbF9udW1fcm93cygkdmFsaWRhdGUpOwo+ Cj4gICBpZigkbnVt
X3Jvd3MgPT0gMSl7Cj4gICAgICB3aGlsZSgkcm93ID0gbXlzcWxfZmV0Y2hf YXNzb2MoJHZhbGlk
YXRlKSl7Cj4gICAgICAgICAkX1NFU1NJT05bJ2xvZ2luJ10gPSB0cnVlOwo+ ICAgICAgICAgJF9T
RVNTSU9OWyd1c2VyaWQnXSA9ICRyb3dbJ21lbWJlcl9pZCddOwo+ICAgICAg ICAgJF9TRVNTSU9O
WydmaXJzdF9uYW1lJ10gPSAkcm93WydmaXJzdF9uYW1lJ107Cj4gICAgICAg ICAkX1NFU1NJT05b
J2xhc3RfbmFtZSddICA9ICRyb3dbJ2xhc3RfbmFtZSddOwo+ICAgICAgICAg JF9TRVNTSU9OWydl
bWFpbF9hZGRyZXNzJ10gPSAkcm93WydlbWFpbF9hZGRyZXNzJ107Cj4KPiAg ICAgICAgIGlmKCRy
b3dbJ2FkbWluX2FjY2VzcyddID09IDEpewo+ICAgICAgICAgICAgJF9TRVNT SU9OWydhZG1pbl9h
Y2Nlc3MnXSA9IHRydWU7Cj4gICAgICAgICB9Cj4gICAgICAgICAkbG9naW5f dGltZSA9IG15c3Fs
X3F1ZXJ5KCJVUERBVEUgbWVtYmVycwo+ICAgICAgICAgICAgICAgICAgICAg ICBTRVQgbGFzdF9s
b2dpbj1ub3coKQo+ICAgICAgICAgICAgICAgICAgICAgICBXSEVSRSBpZD0n eyRyb3dbJ2lkJ119
JyIpOwo+ICAgICAgIH0KPiAgICAgICBoZWFkZXIoIkxvY2F0aW9uOiAvbG9n Z2VkaW4ucGhwIik7
Cj4gICB9IGVsc2Ugewo+ICAgICAgbXloZWFkZXIoItCS0YXQvtC00YrRgiDQ siDQsNC00LzQuNC9
0LjRgdGC0YDQsNGC0LjQstC90LDRgtCwINC30L7QvdCwINC1INC90LXRg9GB 0L/QtdGI0LXQvSEi
KTsKPiAgICAgIGVjaG8gJzxwIGFsaWduPSJjZW50ZXIiPtCS0YXQvtC00YrR giDQsiDRgdGC0YDQ
sNC90LjRhtCw0YLQsCDQvdC1INC1INGD0YHQv9C10YjQtdC9ITwvcD4nOwo+ ICAgICAgZWNobyAn
PHAgYWxpZ249ImNlbnRlciI+0J/RgNC+0LLQtdGA0LXRgtC1INC/0L7RgtGA 0LXQsdC40YLQtdC7
0YHQutC+0YLQviDRgdC4ICcuCj4gICAgICAgICAgICfQuNC80LUg0Lgg0L/Q sNGA0L7Qu9Cw0YLQ
sCDRgdC4INC4INC+0L/QuNGC0LDQudGC0LUg0L/QsNC6INC40LvQuCDRgdC1 ICcuCj4gICAgICAg
ICAgICfQvtCx0LDQtNC10YLQtSDQvdCwINCw0LTQvNC40L3QuNGB0YLRgNCw 0YLQvtGA0LAuPC9w
Pic7Cj4gICAgICBmb290ZXIoKTsKPiAgIH0KPiBicmVhazsKPgo+IGRlZmF1 bHQ6Cj4gICBteWhl
YWRlcigi0JLRhdC+0LQhIik7Cj4gICAgICBpbmNsdWRlICRfU0VSVkVSWydE T0NVTUVOVF9ST09U
J10uCj4gICAgICAgICAgICAgICcvaHRtbC9mb3Jtcy9sb2dpbl9mb3JtLmh0 bWwnOwo+ICAgZm9v
dGVyKCk7Cj4gYnJlYWs7Cj4gfQo+ID8+Cj4KPiBkYXRhYmFzZS5waHA6Cj4g PD9waHAKPiAkbGlu
ayA9IG15c3FsX3Bjb25uZWN0KCdsb2NhbGhvc3QnLCdyb290JywndGVzdGlu ZycpOwo+ICRzZXQg
PSBteXNxbF9xdWVyeSgnU0VUIE5BTUVTIENQMTI1MScpOwo+ICRzZXQgPSBt eXNxbF9xdWVyeSgn
U0VUX0NPTExBVElPTj1DUDEyNTFfR0VORVJBTF9DSScpOwo+IG15c3FsX3Nl bGVjdF9kYignc2Ft
ZWtfZGInLCAkbGluaykgb3IgZGllKG15c3FsX2Vycm9yKCkpOwo+Cj4gPz4K Pgo+IGNvbW1vbi5w
aHA6Cj4gPD9waHAKPgo+IC8vIEluY2x1ZGUgTWV0YSBDb250ZW50IENsYXNz Cj4gaW5jbHVkZSAk
X1NFUlZFUlsnRE9DVU1FTlRfUk9PVCddLicvY2xhc3Nlcy9jbHNNZXRhQ29u dGVudC5waHAnOwo+
Cj4gLy8gSW5jbHVkZSBFbWFpbCBDbGFzcwo+IGluY2x1ZGUgJF9TRVJWRVJb J0RPQ1VNRU5UX1JP
T1QnXS4nL2NsYXNzZXMvY2xzRW1haWwucGhwJzsKPgo+IC8vIEluY2x1ZGUg RGF0YWJhc2UgQ29u
bmVjdGlvbiBGaWxlCj4gaW5jbHVkZSAkX1NFUlZFUlsnRE9DVU1FTlRfUk9P VCddLicvaW5jbHVk
ZXMvZGF0YWJhc2UucGhwJzsKPgo+IC8vIEluY2x1ZGUgU2Vzc2lvbiBGaWxl Cj4gaW5jbHVkZSAk
X1NFUlZFUlsnRE9DVU1FTlRfUk9PVCddLicvaW5jbHVkZXMvc2Vzc2lvbi5w aHAnOwo+Cj4gPz4K
Pgo+IFRoYW5rIHlvdSBmb3IgeW91ciBoZWxwCj4KPgo+IFlvdSdyZSB2ZXJ5 IHdlbGNvbWUsIEkg
dW5kZXJzdGFuZCB0aGF0IHlvdSBuZWVkIGEgc29sdXRpb24gd2hpY2ggYWxs b3dzIHlvdQo+IHRv
IGtlZXAgdXNpbmcgdGhlIGNvbm5lY3Rpb24gdGhpcyB3YXkuCj4KPiBJIGRv dWJ0IHRoYXQgeW91
ciBwaHAuaW5pIGlzIHRoZSBjYXVzZSBzbyBJJ2xsIHN1Z2dlc3QgdGhlIGZv bGxvd2luZzoKPgo+
IFRyeSBleGVjdXRpbmcgeW91ciBNeVNRTCBxdWVyaWVzIGJ5IHBhc3Npbmcg dGhlICRsaW5rIHZh
cmlhYmxlIHRvIHRoZQo+IGZ1bmN0aW9uIGFzIHRoZSBjb25uZWN0aW9uIHJl c291cmNlOgo+Cj4g
bXlzcWxfcXVlcnkoIlNFTEVDVC4uLiIsICRsaW5rKTsKPgo+IFNvbWV0aGlu ZyB0aGF0IGFsc28g
bWlnaHQgY2F1c2UgaXQgaXMgdGhhdCB5b3UgdXNlIChpbmNsdWRlfHJlcXVp cmUpX29uY2UKPiBh
bmQgdGhhdCB0aGlzIG1vZHVsZSBkb2Vzbid0IGhhdmUgYWNjZXNzIHRvIHRo ZSBjb25uZWN0aW9u
IHJlc291cmNlLCBpZiB0aGlzCj4gaXMgdGhlIGNhc2UgY2hhbmdlIGl0IGlu dG8gaW5jbHVkZXxy
ZXF1aXJlIGFuZCBzZWUgaWYgdGhhdCBzb2x2ZXMgeW91cgo+IGlzc3VlLiBJ ZiBub3QgdGhlbiBj
b3VsZCB5b3UgcGxlYXNlIHBvc3Qgc29tZSBleGFtcGxlIGNvZGUgb2YgeW91 ciBtb2R1bGUgaWYK
PiBwb3NzaWJsZSBzbyB3ZSBjYW4gYmUgbW9yZSBoZWxwZnVsPwo+Cj4gQWxz byBiZSBzdXJlIHRo
YXQgeW91IGdsb2JhbCAkbGluazsgaXQgaW4gZnVuY3Rpb25zIChJIGRvbid0 IGtub3cgaWYgdGhp
cwo+IHJlcXVpcmVkIHNpbmNlIEkgZGlkbid0IHVzZSBpdCB0aGlzIHdheSBm b3IgYSBsb25nIHdo
aWxlKS4KPgo+IENvdWxkIHlvdSBhbHNvIHBsZWFzZSBhbnN3ZXIgdG8gdGhl IGxpc3QgaW5zdGVh
ZCBvZiBkaXJlY3RseSB0byBtZSBhcyB0aGlzCj4gbWlnaHQgYWxzbyBiZSBp bmZvcm1hdGl2ZSBm
b3Igb3RoZXJzLgo+Cj4gLS0KPiBWaWV3IHRoaXMgbWVzc2FnZSBpbiBjb250 ZXh0OiBodHRwOi8v
d3d3Lm5hYmJsZS5jb20vUEhQLU15U1FMLWNvbm5lY3Rpb24tZm9yLXBhcnRp Y3VsYXItbW9kdWxl
LXRwMTc5MTUxMDhwMTc5OTAxOTIuaHRtbAo+IFNlbnQgZnJvbSB0aGUgUGhw IC0gRGF0YWJhc2Ug
bWFpbGluZyBsaXN0IGFyY2hpdmUgYXQgTmFiYmxlLmNvbS4KPgo+Cj4gLS0K PiBQSFAgRGF0YWJh
c2UgTWFpbGluZyBMaXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQo+IFRvIHVu c3Vic2NyaWJlLCB2
aXNpdDogaHR0cDovL3d3dy5waHAubmV0L3Vuc3ViLnBocAo+Cj4K

Re: PHP-MySQL connection for particular module

------=_Part_2716_4823382.1213820964859
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

VG8gRXZlcnQ6Cgo0LiBJIGFtIHBvc3Rpbmcgc29tZSBvZiBteSBjb2RlIHRv IGNvbXBhcmUuIE1v
ZHVsZSAiY2FybWFkZS5waHAiIHdvcmtzIHYucy4KImxvZ2luLnBocCIgd2hp Y2ggZG9lcyBub3Qu
IEFsc28sIEkgYW0gcG9zdGluZyBteSAiZGF0YWJhc2UucGhwIiB3aGljaCBp cwplc3RhYmxpc2hp
bmcgdGhlIGNvbm5lY3Rpb24gYW5kIGlzIGluY2x1ZGVkIGluIGV2ZXJ5IHBh Z2UgdGhyb3VnaAoi
bGF5b3V0LnBocCItPiJjb21tb24ucGhwIi0+ImRhdGFiYXNlLnBocCIuCgpU byBiYXRlaXZhbjoK
CkkgY2FuIG9ubHkgZ3Vlc3MgdGhhdCB0aGUgZGF0YWJhc2UucGhwIGZpbGUg aXNuJ3QgY29ycmVj
dGx5IGxvYWRlZCB2aWEKbGF5b3V0LnBocCwgZGlkIHlvdSBhbHJlYWR5IHRy eSB0byBpbmNsdWRl
IGRhdGFiYXNlLnBocCBpbnRvIHRoZSBtb2R1bGUgaW4Kd2hpY2ggaXQgd2Fz bid0IHdvcmtpbmc/
IElmIHNvIGFuZCBpdCB3b3JrcyB0aGVuIHRoZSBpc3N1ZSBpcyBwcm9iYWJs eQpjYXVzZWQgYnkg
aW5jb3JyZWN0bHkgaW5jbHVkaW5nIHRoYXQgZmlsZSwgb3RoZXJ3aXNlIGl0 IGhhcyB0byBiZSBz
b21ldGhpbmcKZWxzZS4uLgoKQW5kIHJlZ2lzdGVyX2dsb2JhbHMgYWxsb3dz IHlvdSB0byB1c2Ug
c2hvcnQgdmFyaWFibGVzIGZvciBzdXBlciBnbG9iYWwKYXJyYXlzLiBFeDog JG5hbWUgaW5zdGVh
ZCBvZiAkX1BPU1RbJ25hbWUnXSwgZXRjLgoKCk9uIFdlZCwgSnVuIDE4LCAy MDA4IGF0IDk6NDcg
UE0sIEV2ZXJ0IExhbW1lcnRzIDxldmVydC5sYW1tZXJ0c0BnbWFpbC5jb20+ Cndyb3RlOgoKPiBQ
YXN0ZWJpbiB3b3JrcyBsb3RzIGJldHRlciB3aGVuIHlvdSdyZSBwb3N0aW5n IGNvZGU6IHd3dy5w
YXN0ZWJpbi5jb20KPgo+IEkgZG9uJ3Qgc2VlIHlvdXIgZGF0YWJhc2UucGhw IGluY2x1ZGVkIGlu
IGJvdGggb2YgdGhlc2UgbW9kdWxlcy4gV2hlcmUKPiBkbyB5b3UgaW5jbHVk ZSBpdD8KPgo+IEVW
ZXJ0Cj4KPiBPbiBXZWQsIEp1biAxOCwgMjAwOCBhdCA5OjM4IFBNLCBiYXRl aXZhbiA8aXZhbm92
aXZhbnNAeWFob28uY2E+IHdyb3RlOgo+ID4KPiA+IEhlbGxvLAo+ID4KPiA+ IFRvIGFuc3dlciB0
aGVzZSBxd2VzdGlvbnM6Cj4gPiAxLiBJIGFtIHVzaW5nICJpbmNsdWRlIiBp biBteSBjb2RlLgo+
ID4gMi4gQWJvdXQgdGhlICIkbGluayA9IG15c3FsX2Nvbm5lY3QoJ2xvY2Fs aG9zdCcsICdyb290
JywgJ3Rlc3RpbmcnKTsiCj4gPiB2YXJpYWJsZS4gSSBjYW4ganVzdCBpbmNs dWRlIHRoaXMgbGlu
ZSBiZWZvcmUgbXlzcWxfcXVlcnkgZnVuY3Rpb24gYW5kIGl0Cj4gPiB3b3Jr cyBldmVuIHdpdGhv
dXQgZW50ZXJpbmcgaW50byBteXNxbF9xdWVyeSB0aGUgIiRsaW5rIiB2YXJp YWJsZS4gKExpa2UK
PiB0aGUKPiA+IGNvbm5lY3Rpb24gaXMgd2FraW5nIHVwKS4KPiA+IDMuTXkg cGhwLmluaSByZWdp
c3Rlcl9nbG9iYWxzIGlzIG9mZiBhcyBzdWdnZXN0ZWQgZm9yIG5ldyB2ZXJz aW9ucyBvZiBQSFAK
PiA+IGJ1dCBpbmNsdWRlIGZpbGUgc2hvdWxkIHdvcmsgaW5zdGVhZCBhY2Nv cmRpbmcgdG8gdGhl
IG1hbnVhbC4KPiA+IDQuIEkgYW0gcG9zdGluZyBzb21lIG9mIG15IGNvZGUg dG8gY29tcGFyZS4g
TW9kdWxlICJjYXJtYWRlLnBocCIgd29ya3MKPiB2LnMuCj4gPiAibG9naW4u cGhwIiB3aGljaCBk
b2VzIG5vdC4gQWxzbywgSSBhbSBwb3N0aW5nIG15ICJkYXRhYmFzZS5waHAi IHdoaWNoIGlzCj4g
PiBlc3RhYmxpc2hpbmcgdGhlIGNvbm5lY3Rpb24gYW5kIGlzIGluY2x1ZGVk IGluIGV2ZXJ5IHBh
Z2UgdGhyb3VnaAo+ID4gImxheW91dC5waHAiLT4iY29tbW9uLnBocCItPiJk YXRhYmFzZS5waHAi
Lgo+ID4KPiA+IGNhcm1hZGUucGhwOgo+ID4gPD9waHAKPiA+IGluY2x1ZGUg JF9TRVJWRVJbJ0RP
Q1VNRU5UX1JPT1QnXS4KPiA+ICAgICAgICAnL2xheW91dC5waHAnOwo+ID4K PiA+IC8vIFF1aWNr
IExvZ2luIHNlc3Npb24gY2hlY2sKPiA+IGxvZ2luX2NoZWNrKCk7Cj4gPgo+ ID4gc3dpdGNoKCRf
UkVRVUVTVFsncmVxJ10pewo+ID4gICAvLyBJbnNlcnQgQ2FzZQo+ID4gICBj YXNlICJjcmVhdGVf
Y2FybWFkZSI6Cj4gPiAgICAgbXloZWFkZXIoIuTPwsHX0c7FIM7BIMHX1M/N z8LJzM7JIM3B0svJ
INcg09DJ09/LwSIpOwo+ID4KPiA+ICAgICAvLyBEb3VibGUgY2hlY2sgZm9y bSBwb3N0ZWQgdmFs
dWVzIGFyZSB0aGVyZQo+ID4gICAgIC8vIGJlZm9yZSBwZXJmb3JtaW5nIElO U0VSVCBxdWVyeQo+
ID4gICAgIGlmKCEkX1BPU1RbJ2Nhcl9kZXNjciddKXsKPiA+ICAgICAgICAg ZWNobyAnPHAgYWxp
Z249ImNlbnRlciI+7MnQ09fBIMnOxs/SzcHDydHU0SDP1CDGz9LNwdTBITwv cD4nLgo+ID4gICAg
ICAgICAgICAgICAgICc8cCBhbGlnbj0iY2VudGVyIj7tz8zRLCDJ2tDPzNrX wcrUxSDC1dTPzsEn
Lgo+ID4gICAgICAgICAgICAgICAgICfuwdrBxCDJINff18XExdTFIMTBzs7J 1MUgz9TOz9fPITwv
cD4nOwo+ID4gICAgICAgICAgICAgICAgICBmb290ZXIoKTsKPiA+ICAgICAg ICAgZXhpdCgpOwo+
ID4gICAgIH0KPiA+Cj4gPiAgICAgLy8gSW5zZXJ0IFF1ZXJ5Cj4gPiAgICAg JHNxbCA9IG15c3Fs
X3F1ZXJ5KCJJTlNFUlQgSU5UTyBjYXJtYWRlCj4gPiAgICAgICAgICAgICAg ICAgKGNhcl9kZXNj
cikKPiA+ICAgICAgICAgICAgICAgICBWQUxVRVMoJ3skX1BPU1RbJ2Nhcl9k ZXNjciddfScpIik7
Cj4gPgo+ID4gICAgIC8vIEluc2VydCBxdWVyeSByZXN1bHRzCj4gPiAgICAg aWYoISRzcWwpewo+
ID4gICAgICAgICBlY2hvICLn0sXby8Eg0NLJINff18XWxMHOxSDOwSDEwc7O ydTFOiIubXlzcWxf
ZXJyb3IoKTsKPiA+ICAgICB9IGVsc2Ugewo+ID4KPiA+ICAgICAgICAgZWNo byAnPHAgYWxpZ249
ImNlbnRlciI+7cHSy8HUwSAiJy4kX1BPU1RbJ2Nhcl9kZXNjciddLgo+ID4g ICAgICAgICAgICAg
ICAgICcixSDX39fFxMXOwTxici8+0yDOz83F0jonLm15c3FsX2luc2VydF9p ZCgpOwo+ID4gICAg
ICAgICBlY2hvICc8YnIgLz4gL2FkbWluL2Nhcm1hZGUucGhwP3JlcT1uZXdf Y2FybWFkZSDp08vB
1MUgzMkgxMEnLgo+ID4gICAgICAgICAgICAgICAgICAgICAgICAn19/XxcTF 1MUgxNLVx8EgzcHS
y8E/ICc7Cj4gPiAgICAgfQo+ID4gICBicmVhazsKPiA+Cj4gPiAgIC8vIENy ZWF0ZSBjYXIgbWFk
ZSBmb3JtIGNhc2UKPiA+ICAgY2FzZSAibmV3X2Nhcm1hZGUiOgo+ID4gICAg ICBteWhlYWRlcigi
99/XxdbEwc7FIM7BIM7P18EgwdfUz83PwsnMzsEgzcHSy8EiKTsKPiA+ICAg ICAgaW5jbHVkZSAk
X1NFUlZFUlsnRE9DVU1FTlRfUk9PVCddLgo+ID4gICAgICAgICAgICAgICcv aHRtbC9mb3Jtcy9j
YXJtYWRlX2luc2VydC5odG1sJzsKPiA+ICAgICAgZm9vdGVyKCk7Cj4gPiAg IGJyZWFrOwo+ID4K
PiA+ICAgZGVmYXVsdDoKPiA+ICAgICAgbXloZWFkZXIoIuHEzcnOydPU0snS wc7FIM7BINPQydPf
y8Eg0yDB19TPzc/CyczOydTFIM3B0svJIik7Cj4gPiAgICAgIGluY2x1ZGUg JF9TRVJWRVJbJ0RP
Q1VNRU5UX1JPT1QnXS4KPiA+ICAgICAgICAgICAgICAnL2h0bWwvY2FybWFk ZV9hZG1pbi5odG1s
JzsKPiA+ICAgICAgZm9vdGVyKCk7Cj4gPiAgIGJyZWFrOwo+ID4KPiA+IH0K PiA+ID8+Cj4gPgo+
ID4gbG9naW4ucGhwOgo+ID4gPD9waHAKPiA+IGluY2x1ZGUgJF9TRVJWRVJb J0RPQ1VNRU5UX1JP
T1QnXS4KPiA+ICAgICAgICAnL2xheW91dC5waHAnOwo+ID4KPiA+Cj4gPiBz d2l0Y2goJF9SRVFV
RVNUWydyZXEnXSl7Cj4gPgo+ID4gY2FzZSAidmFsaWRhdGUiOgo+ID4KPiA+ ICAgJHZhbGlkYXRl
ID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZST00gbWVtYmVycwo+ID4gICAg ICAgICAgICAgICAg
ICAgICAgICAgICBXSEVSRSB1c2VybmFtZSA9ICd7JF9QT1NUWyd1c2VybmFt ZSddfScKPiA+ICAg
ICAgICAgICAgICAgICAgICAgICAgICAgQU5EIHBhc3N3b3JkID0gbWQ1KCd7 JF9QT1NUWydwYXNz
d29yZCddfScpIgo+ID4gICAgICAgICAgICAgICAgICAgICAgICAgICApOwo+ ID4KPiA+ICAgJG51
bV9yb3dzID0gbXlzcWxfbnVtX3Jvd3MoJHZhbGlkYXRlKTsKPiA+Cj4gPiAg IGlmKCRudW1fcm93
cyA9PSAxKXsKPiA+ICAgICAgd2hpbGUoJHJvdyA9IG15c3FsX2ZldGNoX2Fz c29jKCR2YWxpZGF0
ZSkpewo+ID4gICAgICAgICAkX1NFU1NJT05bJ2xvZ2luJ10gPSB0cnVlOwo+ ID4gICAgICAgICAk
X1NFU1NJT05bJ3VzZXJpZCddID0gJHJvd1snbWVtYmVyX2lkJ107Cj4gPiAg ICAgICAgICRfU0VT
U0lPTlsnZmlyc3RfbmFtZSddID0gJHJvd1snZmlyc3RfbmFtZSddOwo+ID4g ICAgICAgICAkX1NF
U1NJT05bJ2xhc3RfbmFtZSddICA9ICRyb3dbJ2xhc3RfbmFtZSddOwo+ID4g ICAgICAgICAkX1NF
U1NJT05bJ2VtYWlsX2FkZHJlc3MnXSA9ICRyb3dbJ2VtYWlsX2FkZHJlc3Mn XTsKPiA+Cj4gPiAg
ICAgICAgIGlmKCRyb3dbJ2FkbWluX2FjY2VzcyddID09IDEpewo+ID4gICAg ICAgICAgICAkX1NF
U1NJT05bJ2FkbWluX2FjY2VzcyddID0gdHJ1ZTsKPiA+ICAgICAgICAgfQo+ ID4gICAgICAgICAk
bG9naW5fdGltZSA9IG15c3FsX3F1ZXJ5KCJVUERBVEUgbWVtYmVycwo+ID4g ICAgICAgICAgICAg
ICAgICAgICAgIFNFVCBsYXN0X2xvZ2luPW5vdygpCj4gPiAgICAgICAgICAg ICAgICAgICAgICAg
V0hFUkUgaWQ9J3skcm93WydpZCddfSciKTsKPiA+ICAgICAgIH0KPiA+ICAg ICAgIGhlYWRlcigi
TG9jYXRpb246IC9sb2dnZWRpbi5waHAiKTsKPiA+ICAgfSBlbHNlIHsKPiA+ ICAgICAgbXloZWFk
ZXIoIvfIz8Tf1CDXIMHEzcnOydPU0sHUydfOwdTBINrPzsEgxSDOxdXT0MXb xc4hIik7Cj4gPiAg
ICAgIGVjaG8gJzxwIGFsaWduPSJjZW50ZXIiPvfIz8Tf1CDXINPU0sHOycPB 1MEgzsUgxSDV09DF
28XOITwvcD4nOwo+ID4gICAgICBlY2hvICc8cCBhbGlnbj0iY2VudGVyIj7w 0s/XxdLF1MUg0M/U
0sXCydTFzNPLz9TPINPJICcuCj4gPiAgICAgICAgICAgJ8nNxSDJINDB0s/M wdTBINPJIMkgz9DJ
1MHK1MUg0MHLIMnMySDTxSAnLgo+ID4gICAgICAgICAgICfPwsHExdTFIM7B IMHEzcnOydPU0sHU
z9LBLjwvcD4nOwo+ID4gICAgICBmb290ZXIoKTsKPiA+ICAgfQo+ID4gYnJl YWs7Cj4gPgo+ID4g
ZGVmYXVsdDoKPiA+ICAgbXloZWFkZXIoIvfIz8QhIik7Cj4gPiAgICAgIGlu Y2x1ZGUgJF9TRVJW
RVJbJ0RPQ1VNRU5UX1JPT1QnXS4KPiA+ICAgICAgICAgICAgICAnL2h0bWwv Zm9ybXMvbG9naW5f
Zm9ybS5odG1sJzsKPiA+ICAgZm9vdGVyKCk7Cj4gPiBicmVhazsKPiA+IH0K PiA+ID8+Cj4gPgo+
ID4gZGF0YWJhc2UucGhwOgo+ID4gPD9waHAKPiA+ICRsaW5rID0gbXlzcWxf cGNvbm5lY3QoJ2xv
Y2FsaG9zdCcsJ3Jvb3QnLCd0ZXN0aW5nJyk7Cj4gPiAkc2V0ID0gbXlzcWxf cXVlcnkoJ1NFVCBO
QU1FUyBDUDEyNTEnKTsKPiA+ICRzZXQgPSBteXNxbF9xdWVyeSgnU0VUX0NP TExBVElPTj1DUDEy
NTFfR0VORVJBTF9DSScpOwo+ID4gbXlzcWxfc2VsZWN0X2RiKCdzYW1la19k YicsICRsaW5rKSBv
ciBkaWUobXlzcWxfZXJyb3IoKSk7Cj4gPgo+ID4gPz4KPiA+Cj4gPiBjb21t b24ucGhwOgo+ID4g
PD9waHAKPiA+Cj4gPiAvLyBJbmNsdWRlIE1ldGEgQ29udGVudCBDbGFzcwo+ ID4gaW5jbHVkZSAk
X1NFUlZFUlsnRE9DVU1FTlRfUk9PVCddLicvY2xhc3Nlcy9jbHNNZXRhQ29u dGVudC5waHAnOwo+
ID4KPiA+IC8vIEluY2x1ZGUgRW1haWwgQ2xhc3MKPiA+IGluY2x1ZGUgJF9T RVJWRVJbJ0RPQ1VN
RU5UX1JPT1QnXS4nL2NsYXNzZXMvY2xzRW1haWwucGhwJzsKPiA+Cj4gPiAv LyBJbmNsdWRlIERh
dGFiYXNlIENvbm5lY3Rpb24gRmlsZQo+ID4gaW5jbHVkZSAkX1NFUlZFUlsn RE9DVU1FTlRfUk9P
VCddLicvaW5jbHVkZXMvZGF0YWJhc2UucGhwJzsKPiA+Cj4gPiAvLyBJbmNs dWRlIFNlc3Npb24g
RmlsZQo+ID4gaW5jbHVkZSAkX1NFUlZFUlsnRE9DVU1FTlRfUk9PVCddLicv aW5jbHVkZXMvc2Vz
c2lvbi5waHAnOwo+ID4KPiA+ID8+Cj4gPgo+ID4gVGhhbmsgeW91IGZvciB5 b3VyIGhlbHAKPiA+
Cj4gPgo+ID4gWW91J3JlIHZlcnkgd2VsY29tZSwgSSB1bmRlcnN0YW5kIHRo YXQgeW91IG5lZWQg
YSBzb2x1dGlvbiB3aGljaCBhbGxvd3MKPiB5b3UKPiA+IHRvIGtlZXAgdXNp bmcgdGhlIGNvbm5l
Y3Rpb24gdGhpcyB3YXkuCj4gPgo+ID4gSSBkb3VidCB0aGF0IHlvdXIgcGhw LmluaSBpcyB0aGUg
Y2F1c2Ugc28gSSdsbCBzdWdnZXN0IHRoZSBmb2xsb3dpbmc6Cj4gPgo+ID4g VHJ5IGV4ZWN1dGlu
ZyB5b3VyIE15U1FMIHF1ZXJpZXMgYnkgcGFzc2luZyB0aGUgJGxpbmsgdmFy aWFibGUgdG8gdGhl
Cj4gPiBmdW5jdGlvbiBhcyB0aGUgY29ubmVjdGlvbiByZXNvdXJjZToKPiA+ Cj4gPiBteXNxbF9x
dWVyeSgiU0VMRUNULi4uIiwgJGxpbmspOwo+ID4KPiA+IFNvbWV0aGluZyB0 aGF0IGFsc28gbWln
aHQgY2F1c2UgaXQgaXMgdGhhdCB5b3UgdXNlIChpbmNsdWRlfHJlcXVpcmUp X29uY2UKPiA+IGFu
ZCB0aGF0IHRoaXMgbW9kdWxlIGRvZXNuJ3QgaGF2ZSBhY2Nlc3MgdG8gdGhl IGNvbm5lY3Rpb24g
cmVzb3VyY2UsIGlmCj4gdGhpcwo+ID4gaXMgdGhlIGNhc2UgY2hhbmdlIGl0 IGludG8gaW5jbHVk
ZXxyZXF1aXJlIGFuZCBzZWUgaWYgdGhhdCBzb2x2ZXMgeW91cgo+ID4gaXNz dWUuIElmIG5vdCB0
aGVuIGNvdWxkIHlvdSBwbGVhc2UgcG9zdCBzb21lIGV4YW1wbGUgY29kZSBv ZiB5b3VyIG1vZHVs
ZQo+IGlmCj4gPiBwb3NzaWJsZSBzbyB3ZSBjYW4gYmUgbW9yZSBoZWxwZnVs Pwo+ID4KPiA+IEFs
c28gYmUgc3VyZSB0aGF0IHlvdSBnbG9iYWwgJGxpbms7IGl0IGluIGZ1bmN0 aW9ucyAoSSBkb24n
dCBrbm93IGlmIHRoaXMKPiA+IHJlcXVpcmVkIHNpbmNlIEkgZGlkbid0IHVz ZSBpdCB0aGlzIHdh
eSBmb3IgYSBsb25nIHdoaWxlKS4KPiA+Cj4gPiBDb3VsZCB5b3UgYWxzbyBw bGVhc2UgYW5zd2Vy
IHRvIHRoZSBsaXN0IGluc3RlYWQgb2YgZGlyZWN0bHkgdG8gbWUgYXMKPiB0 aGlzCj4gPiBtaWdo
dCBhbHNvIGJlIGluZm9ybWF0aXZlIGZvciBvdGhlcnMuCj4gPgo+ID4gLS0K PiA+IFZpZXcgdGhp
cyBtZXNzYWdlIGluIGNvbnRleHQ6Cj4gaHR0cDovL3d3dy5uYWJibGUuY29t L1BIUC1NeVNRTC1j
b25uZWN0aW9uLWZvci1wYXJ0aWN1bGFyLW1vZHVsZS10cDE3OTE1MTA4cDE3 OTkwMTkyLmh0bWwK
PiA+IFNlbnQgZnJvbSB0aGUgUGhwIC0gRGF0YWJhc2UgbWFpbGluZyBsaXN0 IGFyY2hpdmUgYXQg
TmFiYmxlLmNvbS4KPiA+Cj4gPgo+ID4gLS0KPiA+IFBIUCBEYXRhYmFzZSBN YWlsaW5nIExpc3Qg
KGh0dHA6Ly93d3cucGhwLm5ldC8pCj4gPiBUbyB1bnN1YnNjcmliZSwgdmlz aXQ6IGh0dHA6Ly93
d3cucGhwLm5ldC91bnN1Yi5waHAKPiA+Cj4gPgo+CgoKCi0tIApJc2FhayBN YWxpawpXZWIgRGV2
ZWxvcGVyCg==
------=_Part_2716_4823382.1213820964859--

Re: PHP-MySQL connection for particular module

Isaak Malik wrote:
> Because then the connection resource isn't stored in the $link variable
> and you will be able to use the mysql functions without passing that
> variable to each function.

RTM again.

The link parameter is completely optional.

If you don't specify it, it uses the last connection created.

I can do this and it's perfectly valid:

$link = mysql_connect($server, $user, $pass);
if (!$link) {
die ("Unable to connect to the database server");
}

$db_selected = mysql_select_db($databasename);
if (!$db_selected) {
die("Unable to connect to the database $databasename");
}

$result = mysql_query("select 1");

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

------=_Part_3874_5293697.1213859574336
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

My mistake then, it's been a while that I used it that way so some things do
fade away from my mind.

On Thu, Jun 19, 2008 at 1:57 AM, Chris wrote:

> Isaak Malik wrote:
> > Because then the connection resource isn't stored in the $link variable
> > and you will be able to use the mysql functions without passing that
> > variable to each function.
>
> RTM again.
>
> The link parameter is completely optional.
>
> If you don't specify it, it uses the last connection created.
>
> I can do this and it's perfectly valid:
>
> $link = mysql_connect($server, $user, $pass);
> if (!$link) {
> die ("Unable to connect to the database server");
> }
>
> $db_selected = mysql_select_db($databasename);
> if (!$db_selected) {
> die("Unable to connect to the database $databasename");
> }
>
> $result = mysql_query("select 1");
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>



--
Isaak Malik
Web Developer

------=_Part_3874_5293697.1213859574336--

Re: PHP-MySQL connection for particular module

What you said wasn't wrong - you'd just produce a couple of warnings.
By taking away the assignment of the $link variable you're unsetting
it, meaning it will have a value equal to NULL. All of the following
should work.

[old code]
if (!($link = mysql_connect($a, $b, $c))) return;

if (!mysql_select_db($dbname)) return;

$res = mysql_query("SELECT * FROM manual;", $link);
[/old code]

[new code]
if (!mysql_connect($a, $b, $c)) return;

if (!mysql_select_db($dbname)) return;

$res = mysql_query("SELECT * FROM manual;", $link);
[/new code]

OR, optionally, to surpress the warnings:

[new code]
if (!mysql_connect($a, $b, $c)) return;

$link = null;

if (!mysql_select_db($dbname)) return;

$res = mysql_query("SELECT * FROM manual;", $link);
[/new code]

Evert

On Thu, Jun 19, 2008 at 9:12 AM, Isaak Malik wrote:
> My mistake then, it's been a while that I used it that way so some things do
> fade away from my mind.
>
> On Thu, Jun 19, 2008 at 1:57 AM, Chris wrote:
>
>> Isaak Malik wrote:
>> > Because then the connection resource isn't stored in the $link variable
>> > and you will be able to use the mysql functions without passing that
>> > variable to each function.
>>
>> RTM again.
>>
>> The link parameter is completely optional.
>>
>> If you don't specify it, it uses the last connection created.
>>
>> I can do this and it's perfectly valid:
>>
>> $link = mysql_connect($server, $user, $pass);
>> if (!$link) {
>> die ("Unable to connect to the database server");
>> }
>>
>> $db_selected = mysql_select_db($databasename);
>> if (!$db_selected) {
>> die("Unable to connect to the database $databasename");
>> }
>>
>> $result = mysql_query("select 1");
>>
>> --
>> Postgresql & php tutorials
>> http://www.designmagick.com/
>>
>
>
>
> --
> Isaak Malik
> Web Developer
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

Hello Isaak,

You've scored the bulleye! It works!
Also, I tested by including "common.php" instead of "database.php" and it
worked too.
This solution is perfect for me as I can keep my code compact and tidy.

I would, definetely, recommend this site to my fellow developers.

Thank you very much, Isaak and all the rest of the guys who took interst in
my problem.
Best regards.


Isaak Malik-3 wrote:
>=20
> To Evert:
>=20
> 4. I am posting some of my code to compare. Module "carmade.php" works
> v.s.
> "login.php" which does not. Also, I am posting my "database.php" which is
> establishing the connection and is included in every page through
> "layout.php"->"common.php"->"database.php".
>=20
> To bateivan:
>=20
> I can only guess that the database.php file isn't correctly loaded via
> layout.php, did you already try to include database.php into the module i=
n
> which it wasn't working? If so and it works then the issue is probably
> caused by incorrectly including that file, otherwise it has to be
> something
> else...
>=20
> And register_globals allows you to use short variables for super global
> arrays. Ex: $name instead of $_POST['name'], etc.
>=20
>=20
> On Wed, Jun 18, 2008 at 9:47 PM, Evert Lammerts >
> wrote:
>=20
>> Pastebin works lots better when you're posting code: www.pastebin.com
>>
>> I don't see your database.php included in both of these modules. Where
>> do you include it?
>>
>> EVert
>>
>> On Wed, Jun 18, 2008 at 9:38 PM, bateivan wrote:
>> >
>> > Hello,
>> >
>> > To answer these qwestions:
>> > 1. I am using "include" in my code.
>> > 2. About the "$link =3D mysql_connect('localhost', 'root', 'testing');=
"
>> > variable. I can just include this line before mysql_query function and
>> it
>> > works even without entering into mysql_query the "$link" variable.
>> (Like
>> the
>> > connection is waking up).
>> > 3.My php.ini register_globals is off as suggested for new versions of
>> PHP
>> > but include file should work instead according to the manual.
>> > 4. I am posting some of my code to compare. Module "carmade.php" works
>> v.s.
>> > "login.php" which does not. Also, I am posting my "database.php" which
>> is
>> > establishing the connection and is included in every page through
>> > "layout.php"->"common.php"->"database.php".
>> >
>> > carmade.php:
>> > >> > include $_SERVER['DOCUMENT_ROOT'].
>> > '/layout.php';
>> >
>> > // Quick Login session check
>> > login_check();
>> >
>> > switch($_REQUEST['req']){
>> > // Insert Case
>> > case "create_carmade":
>> > myheader("Добавяне н=
а автомобилн и =
марки в списък=
а");
>> >
>> > // Double check form posted values are there
>> > // before performing INSERT query
>> > if(!$_POST['car_descr']){
>> > echo '

Липсва=
информация тя =
от формата!

Моля, и=
зползвайте бу=
тона'.
>> > 'Назад и въ=D0=
²ÐµÐ´ÐµÑ‚Ð=B5 даннит=D0=
=B5 отново!

Маркат=
а "'.$_POST['car_descr'].
>> > '"е въведен=D0=
°
с номер:'.mysql_insert_id();
>> > echo '
/admin/carmade.php?req=3Dnew_carmade Ис=
кате ли да'.
>> > 'въведет=D0=
=B5 друга марка? ';
>> > }
>> > break;
>> >
>> > // Create car made form case
>> > case "new_carmade":
>> > myheader("Въвеждан=D 0=B5 =
на нова автомо=
билна марка");
>> > include $_SERVER['DOCUMENT_ROOT'].
>> > '/html/forms/carmade_insert.html';
>> > footer();
>> > break;
>> >
>> > default:
>> > myheader("Админист=D 1=80=
иране на списъ=
ка с автомобил=
ните марки");
>> > include $_SERVER['DOCUMENT_ROOT'].
>> > '/html/carmade_admin.html';
>> > footer();
>> > break;
>> >
>> > }
>> > ?>
>> >
>> > login.php:
>> > >> > include $_SERVER['DOCUMENT_ROOT'].
>> > '/layout.php';
>> >
>> >
>> > switch($_REQUEST['req']){
>> >
>> > case "validate":
>> >
>> > $validate =3D mysql_query("SELECT * FROM members
>> > WHERE username =3D '{$_POST['username']}'
>> > AND password =3D md5('{$_POST['password']}')=
"
>> > );
>> >
>> > $num_rows =3D mysql_num_rows($validate);
>> >
>> > if($num_rows == 1){
>> > while($row =3D mysql_fetch_assoc($validate)){
>> > $_SESSION['login'] =3D true;
>> > $_SESSION['userid'] =3D $row['member_id'];
>> > $_SESSION['first_name'] =3D $row['first_name'];
>> > $_SESSION['last_name'] =3D $row['last_name'];
>> > $_SESSION['email_address'] =3D $row['email_address'];
>> >
>> > if($row['admin_access'] == 1){
>> > $_SESSION['admin_access'] =3D true;
>> > }
>> > $login_time =3D mysql_query("UPDATE members
>> > SET last_login=3Dnow()
>> > WHERE id=3D'{$row['id']}'");
>> > }
>> > header("Location: /loggedin.php");
>> > } else {
>> > myheader("Входът в а=D0=
´Ð¼Ð¸Ð½Ð¸ÑÑ‚ратР¸Ð²Ð=BD=
ата зона е неус=
пешен!");
>> > echo '

Входът =
в страницата н=
е е успешен!

Провер=D0=
µÑ‚Ð=B5 потребите=D0=
»ÑÐºÐ¾Ñ‚Ð=BE си '.
>> > 'име и парол=D0=
°Ñ‚а си и опитай=D1=
‚Ð=B5 пак или се '.
>> > 'обадете на =D0=
°Ð´Ð¼Ð¸Ð½Ð¸ÑÑ‚Ñ€Ð°Ñ ‚оÑ=80=
а.

Re: PHP-MySQL connection for particular module

------=_Part_4324_15293309.1213871805504
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: base64
Content-Disposition: inline

SXQncyBncmVhdCB0aGF0IHlvdSBnb3QgeW91ciBwcm9ibGVtIHNvbHZlZCA6 KS4KCk9uIFRodSwg
SnVuIDE5LCAyMDA4IGF0IDEyOjMwIFBNLCBiYXRlaXZhbiA8aXZhbm92aXZh bnNAeWFob28uY2E+
IHdyb3RlOgoKPgo+IEhlbGxvIElzYWFrLAo+Cj4gWW91J3ZlIHNjb3JlZCB0 aGUgYnVsbGV5ZSEg
SXQgd29ya3MhCj4gQWxzbywgSSB0ZXN0ZWQgYnkgaW5jbHVkaW5nICJjb21t b24ucGhwIiBpbnN0
ZWFkIG9mICJkYXRhYmFzZS5waHAiIGFuZCBpdAo+IHdvcmtlZCB0b28uCj4g VGhpcyBzb2x1dGlv
biBpcyBwZXJmZWN0IGZvciBtZSBhcyBJIGNhbiBrZWVwIG15IGNvZGUgY29t cGFjdCBhbmQgdGlk
eS4KPgo+IEkgd291bGQsIGRlZmluZXRlbHksIHJlY29tbWVuZCB0aGlzIHNp dGUgdG8gbXkgZmVs
bG93IGRldmVsb3BlcnMuCj4KPiBUaGFuayB5b3UgdmVyeSBtdWNoLCBJc2Fh ayBhbmQgYWxsIHRo
ZSByZXN0IG9mIHRoZSBndXlzIHdobyB0b29rIGludGVyc3QgaW4KPiBteSBw cm9ibGVtLgo+IEJl
c3QgcmVnYXJkcy4KPgo+Cj4gSXNhYWsgTWFsaWstMyB3cm90ZToKPiA+Cj4g PiBUbyBFdmVydDoK
PiA+Cj4gPiA0LiBJIGFtIHBvc3Rpbmcgc29tZSBvZiBteSBjb2RlIHRvIGNv bXBhcmUuIE1vZHVs
ZSAiY2FybWFkZS5waHAiIHdvcmtzCj4gPiB2LnMuCj4gPiAibG9naW4ucGhw IiB3aGljaCBkb2Vz
IG5vdC4gQWxzbywgSSBhbSBwb3N0aW5nIG15ICJkYXRhYmFzZS5waHAiIHdo aWNoIGlzCj4gPiBl
c3RhYmxpc2hpbmcgdGhlIGNvbm5lY3Rpb24gYW5kIGlzIGluY2x1ZGVkIGlu IGV2ZXJ5IHBhZ2Ug
dGhyb3VnaAo+ID4gImxheW91dC5waHAiLT4iY29tbW9uLnBocCItPiJkYXRh YmFzZS5waHAiLgo+
ID4KPiA+IFRvIGJhdGVpdmFuOgo+ID4KPiA+IEkgY2FuIG9ubHkgZ3Vlc3Mg dGhhdCB0aGUgZGF0
YWJhc2UucGhwIGZpbGUgaXNuJ3QgY29ycmVjdGx5IGxvYWRlZCB2aWEKPiA+ IGxheW91dC5waHAs
IGRpZCB5b3UgYWxyZWFkeSB0cnkgdG8gaW5jbHVkZSBkYXRhYmFzZS5waHAg aW50byB0aGUgbW9k
dWxlCj4gaW4KPiA+IHdoaWNoIGl0IHdhc24ndCB3b3JraW5nPyBJZiBzbyBh bmQgaXQgd29ya3Mg
dGhlbiB0aGUgaXNzdWUgaXMgcHJvYmFibHkKPiA+IGNhdXNlZCBieSBpbmNv cnJlY3RseSBpbmNs
dWRpbmcgdGhhdCBmaWxlLCBvdGhlcndpc2UgaXQgaGFzIHRvIGJlCj4gPiBz b21ldGhpbmcKPiA+
IGVsc2UuLi4KPiA+Cj4gPiBBbmQgcmVnaXN0ZXJfZ2xvYmFscyBhbGxvd3Mg eW91IHRvIHVzZSBz
aG9ydCB2YXJpYWJsZXMgZm9yIHN1cGVyIGdsb2JhbAo+ID4gYXJyYXlzLiBF eDogJG5hbWUgaW5z
dGVhZCBvZiAkX1BPU1RbJ25hbWUnXSwgZXRjLgo+ID4KPiA+Cj4gPiBPbiBX ZWQsIEp1biAxOCwg
MjAwOCBhdCA5OjQ3IFBNLCBFdmVydCBMYW1tZXJ0cyA8Cj4gZXZlcnQubGFt bWVydHNAZ21haWwu
Y29tPgo+ID4gd3JvdGU6Cj4gPgo+ID4+IFBhc3RlYmluIHdvcmtzIGxvdHMg YmV0dGVyIHdoZW4g
eW91J3JlIHBvc3RpbmcgY29kZTogd3d3LnBhc3RlYmluLmNvbQo+ID4+Cj4g Pj4gSSBkb24ndCBz
ZWUgeW91ciBkYXRhYmFzZS5waHAgaW5jbHVkZWQgaW4gYm90aCBvZiB0aGVz ZSBtb2R1bGVzLiBX
aGVyZQo+ID4+IGRvIHlvdSBpbmNsdWRlIGl0Pwo+ID4+Cj4gPj4gRVZlcnQK PiA+Pgo+ID4+IE9u
IFdlZCwgSnVuIDE4LCAyMDA4IGF0IDk6MzggUE0sIGJhdGVpdmFuIDxpdmFu b3ZpdmFuc0B5YWhv
by5jYT4gd3JvdGU6Cj4gPj4gPgo+ID4+ID4gSGVsbG8sCj4gPj4gPgo+ID4+ ID4gVG8gYW5zd2Vy
IHRoZXNlIHF3ZXN0aW9uczoKPiA+PiA+IDEuIEkgYW0gdXNpbmcgImluY2x1 ZGUiIGluIG15IGNv
ZGUuCj4gPj4gPiAyLiBBYm91dCB0aGUgIiRsaW5rID0gbXlzcWxfY29ubmVj dCgnbG9jYWxob3N0
JywgJ3Jvb3QnLCAndGVzdGluZycpOyIKPiA+PiA+IHZhcmlhYmxlLiBJIGNh biBqdXN0IGluY2x1
ZGUgdGhpcyBsaW5lIGJlZm9yZSBteXNxbF9xdWVyeSBmdW5jdGlvbiBhbmQK PiA+PiBpdAo+ID4+
ID4gd29ya3MgZXZlbiB3aXRob3V0IGVudGVyaW5nIGludG8gbXlzcWxfcXVl cnkgdGhlICIkbGlu
ayIgdmFyaWFibGUuCj4gPj4gKExpa2UKPiA+PiB0aGUKPiA+PiA+IGNvbm5l Y3Rpb24gaXMgd2Fr
aW5nIHVwKS4KPiA+PiA+IDMuTXkgcGhwLmluaSByZWdpc3Rlcl9nbG9iYWxz IGlzIG9mZiBhcyBz
dWdnZXN0ZWQgZm9yIG5ldyB2ZXJzaW9ucyBvZgo+ID4+IFBIUAo+ID4+ID4g YnV0IGluY2x1ZGUg
ZmlsZSBzaG91bGQgd29yayBpbnN0ZWFkIGFjY29yZGluZyB0byB0aGUgbWFu dWFsLgo+ID4+ID4g
NC4gSSBhbSBwb3N0aW5nIHNvbWUgb2YgbXkgY29kZSB0byBjb21wYXJlLiBN b2R1bGUgImNhcm1h
ZGUucGhwIiB3b3Jrcwo+ID4+IHYucy4KPiA+PiA+ICJsb2dpbi5waHAiIHdo aWNoIGRvZXMgbm90
LiBBbHNvLCBJIGFtIHBvc3RpbmcgbXkgImRhdGFiYXNlLnBocCIgd2hpY2gK PiA+PiBpcwo+ID4+
ID4gZXN0YWJsaXNoaW5nIHRoZSBjb25uZWN0aW9uIGFuZCBpcyBpbmNsdWRl ZCBpbiBldmVyeSBw
YWdlIHRocm91Z2gKPiA+PiA+ICJsYXlvdXQucGhwIi0+ImNvbW1vbi5waHAi LT4iZGF0YWJhc2Uu
cGhwIi4KPiA+PiA+Cj4gPj4gPiBjYXJtYWRlLnBocDoKPiA+PiA+IDw/cGhw Cj4gPj4gPiBpbmNs
dWRlICRfU0VSVkVSWydET0NVTUVOVF9ST09UJ10uCj4gPj4gPiAgICAgICAg Jy9sYXlvdXQucGhw
JzsKPiA+PiA+Cj4gPj4gPiAvLyBRdWljayBMb2dpbiBzZXNzaW9uIGNoZWNr Cj4gPj4gPiBsb2dp
bl9jaGVjaygpOwo+ID4+ID4KPiA+PiA+IHN3aXRjaCgkX1JFUVVFU1RbJ3Jl cSddKXsKPiA+PiA+
ICAgLy8gSW5zZXJ0IENhc2UKPiA+PiA+ICAgY2FzZSAiY3JlYXRlX2Nhcm1h ZGUiOgo+ID4+ID4g
ICAgIG15aGVhZGVyKCLkz8LB19HOxSDOwSDB19TPzc/CyczOySDNwdLLySDX INPQydPfy8EiKTsK
PiA+PiA+Cj4gPj4gPiAgICAgLy8gRG91YmxlIGNoZWNrIGZvcm0gcG9zdGVk IHZhbHVlcyBhcmUg
dGhlcmUKPiA+PiA+ICAgICAvLyBiZWZvcmUgcGVyZm9ybWluZyBJTlNFUlQg cXVlcnkKPiA+PiA+
ICAgICBpZighJF9QT1NUWydjYXJfZGVzY3InXSl7Cj4gPj4gPiAgICAgICAg IGVjaG8gJzxwIGFs
aWduPSJjZW50ZXIiPuzJ0NPXwSDJzsbP0s3Bw8nR1NEgz9Qgxs/SzcHUwSE8 L3A+Jy4KPiA+PiA+
ICAgICAgICAgICAgICAgICAnPHAgYWxpZ249ImNlbnRlciI+7c/M0SwgydrQ z8za18HK1MUgwtXU
z87BJy4KPiA+PiA+ICAgICAgICAgICAgICAgICAn7sHawcQgySDX39fFxMXU xSDEwc7OydTFIM/U
zs/XzyE8L3A+JzsKPiA+PiA+ICAgICAgICAgICAgICAgICAgZm9vdGVyKCk7 Cj4gPj4gPiAgICAg
ICAgIGV4aXQoKTsKPiA+PiA+ICAgICB9Cj4gPj4gPgo+ID4+ID4gICAgIC8v IEluc2VydCBRdWVy
eQo+ID4+ID4gICAgICRzcWwgPSBteXNxbF9xdWVyeSgiSU5TRVJUIElOVE8g Y2FybWFkZQo+ID4+
ID4gICAgICAgICAgICAgICAgIChjYXJfZGVzY3IpCj4gPj4gPiAgICAgICAg ICAgICAgICAgVkFM
VUVTKCd7JF9QT1NUWydjYXJfZGVzY3InXX0nKSIpOwo+ID4+ID4KPiA+PiA+ ICAgICAvLyBJbnNl
cnQgcXVlcnkgcmVzdWx0cwo+ID4+ID4gICAgIGlmKCEkc3FsKXsKPiA+PiA+ ICAgICAgICAgZWNo
byAi59LF28vBINDSySDX39fF1sTBzsUgzsEgxMHOzsnUxToiLm15c3FsX2Vy cm9yKCk7Cj4gPj4g
PiAgICAgfSBlbHNlIHsKPiA+PiA+Cj4gPj4gPiAgICAgICAgIGVjaG8gJzxw IGFsaWduPSJjZW50
ZXIiPu3B0svB1MEgIicuJF9QT1NUWydjYXJfZGVzY3InXS4KPiA+PiA+ICAg ICAgICAgICAgICAg
ICAnIsUg19/XxcTFzsE8YnIvPtMgzs/NxdI6Jy5teXNxbF9pbnNlcnRfaWQo KTsKPiA+PiA+ICAg
ICAgICAgZWNobyAnPGJyIC8+IC9hZG1pbi9jYXJtYWRlLnBocD9yZXE9bmV3 X2Nhcm1hZGUg6dPL
wdTFIMzJIMTBJy4KPiA+PiA+ICAgICAgICAgICAgICAgICAgICAgICAgJ9ff 18XExdTFIMTS1cfB
IM3B0svBPyAnOwo+ID4+ID4gICAgIH0KPiA+PiA+ICAgYnJlYWs7Cj4gPj4g Pgo+ID4+ID4gICAv
LyBDcmVhdGUgY2FyIG1hZGUgZm9ybSBjYXNlCj4gPj4gPiAgIGNhc2UgIm5l d19jYXJtYWRlIjoK
PiA+PiA+ICAgICAgbXloZWFkZXIoIvff18XWxMHOxSDOwSDOz9fBIMHX1M/N z8LJzM7BIM3B0svB
Iik7Cj4gPj4gPiAgICAgIGluY2x1ZGUgJF9TRVJWRVJbJ0RPQ1VNRU5UX1JP T1QnXS4KPiA+PiA+
ICAgICAgICAgICAgICAnL2h0bWwvZm9ybXMvY2FybWFkZV9pbnNlcnQuaHRt bCc7Cj4gPj4gPiAg
ICAgIGZvb3RlcigpOwo+ID4+ID4gICBicmVhazsKPiA+PiA+Cj4gPj4gPiAg IGRlZmF1bHQ6Cj4g
Pj4gPiAgICAgIG15aGVhZGVyKCLhxM3JzsnT1NLJ0sHOxSDOwSDT0MnT38vB INMgwdfUz83PwsnM
zsnUxSDNwdLLySIpOwo+ID4+ID4gICAgICBpbmNsdWRlICRfU0VSVkVSWydE T0NVTUVOVF9ST09U
J10uCj4gPj4gPiAgICAgICAgICAgICAgJy9odG1sL2Nhcm1hZGVfYWRtaW4u aHRtbCc7Cj4gPj4g
PiAgICAgIGZvb3RlcigpOwo+ID4+ID4gICBicmVhazsKPiA+PiA+Cj4gPj4g PiB9Cj4gPj4gPiA/
Pgo+ID4+ID4KPiA+PiA+IGxvZ2luLnBocDoKPiA+PiA+IDw/cGhwCj4gPj4g PiBpbmNsdWRlICRf
U0VSVkVSWydET0NVTUVOVF9ST09UJ10uCj4gPj4gPiAgICAgICAgJy9sYXlv dXQucGhwJzsKPiA+
PiA+Cj4gPj4gPgo+ID4+ID4gc3dpdGNoKCRfUkVRVUVTVFsncmVxJ10pewo+ ID4+ID4KPiA+PiA+
IGNhc2UgInZhbGlkYXRlIjoKPiA+PiA+Cj4gPj4gPiAgICR2YWxpZGF0ZSA9 IG15c3FsX3F1ZXJ5
KCJTRUxFQ1QgKiBGUk9NIG1lbWJlcnMKPiA+PiA+ICAgICAgICAgICAgICAg ICAgICAgICAgICAg
V0hFUkUgdXNlcm5hbWUgPSAneyRfUE9TVFsndXNlcm5hbWUnXX0nCj4gPj4g PiAgICAgICAgICAg
ICAgICAgICAgICAgICAgIEFORCBwYXNzd29yZCA9IG1kNSgneyRfUE9TVFsn cGFzc3dvcmQnXX0n
KSIKPiA+PiA+ICAgICAgICAgICAgICAgICAgICAgICAgICAgKTsKPiA+PiA+ Cj4gPj4gPiAgICRu
dW1fcm93cyA9IG15c3FsX251bV9yb3dzKCR2YWxpZGF0ZSk7Cj4gPj4gPgo+ ID4+ID4gICBpZigk
bnVtX3Jvd3MgPT0gMSl7Cj4gPj4gPiAgICAgIHdoaWxlKCRyb3cgPSBteXNx bF9mZXRjaF9hc3Nv
YygkdmFsaWRhdGUpKXsKPiA+PiA+ICAgICAgICAgJF9TRVNTSU9OWydsb2dp biddID0gdHJ1ZTsK
PiA+PiA+ICAgICAgICAgJF9TRVNTSU9OWyd1c2VyaWQnXSA9ICRyb3dbJ21l bWJlcl9pZCddOwo+
ID4+ID4gICAgICAgICAkX1NFU1NJT05bJ2ZpcnN0X25hbWUnXSA9ICRyb3db J2ZpcnN0X25hbWUn
XTsKPiA+PiA+ICAgICAgICAgJF9TRVNTSU9OWydsYXN0X25hbWUnXSAgPSAk cm93WydsYXN0X25h
bWUnXTsKPiA+PiA+ICAgICAgICAgJF9TRVNTSU9OWydlbWFpbF9hZGRyZXNz J10gPSAkcm93Wydl
bWFpbF9hZGRyZXNzJ107Cj4gPj4gPgo+ID4+ID4gICAgICAgICBpZigkcm93 WydhZG1pbl9hY2Nl
c3MnXSA9PSAxKXsKPiA+PiA+ICAgICAgICAgICAgJF9TRVNTSU9OWydhZG1p bl9hY2Nlc3MnXSA9
IHRydWU7Cj4gPj4gPiAgICAgICAgIH0KPiA+PiA+ICAgICAgICAgJGxvZ2lu X3RpbWUgPSBteXNx
bF9xdWVyeSgiVVBEQVRFIG1lbWJlcnMKPiA+PiA+ICAgICAgICAgICAgICAg ICAgICAgICBTRVQg
bGFzdF9sb2dpbj1ub3coKQo+ID4+ID4gICAgICAgICAgICAgICAgICAgICAg IFdIRVJFIGlkPSd7
JHJvd1snaWQnXX0nIik7Cj4gPj4gPiAgICAgICB9Cj4gPj4gPiAgICAgICBo ZWFkZXIoIkxvY2F0
aW9uOiAvbG9nZ2VkaW4ucGhwIik7Cj4gPj4gPiAgIH0gZWxzZSB7Cj4gPj4g PiAgICAgIG15aGVh
ZGVyKCL3yM/E39Qg1yDBxM3JzsnT1NLB1MnXzsHUwSDaz87BIMUgzsXV09DF 28XOISIpOwo+ID4+
ID4gICAgICBlY2hvICc8cCBhbGlnbj0iY2VudGVyIj73yM/E39Qg1yDT1NLB zsnDwdTBIM7FIMUg
1dPQxdvFziE8L3A+JzsKPiA+PiA+ICAgICAgZWNobyAnPHAgYWxpZ249ImNl bnRlciI+8NLP18XS
xdTFINDP1NLFwsnUxczTy8/UzyDTySAnLgo+ID4+ID4gICAgICAgICAgICfJ zcUgySDQwdLPzMHU
wSDTySDJIM/QydTBytTFINDByyDJzMkg08UgJy4KPiA+PiA+ICAgICAgICAg ICAnz8LBxMXUxSDO
wSDBxM3JzsnT1NLB1M/SwS48L3A+JzsKPiA+PiA+ICAgICAgZm9vdGVyKCk7 Cj4gPj4gPiAgIH0K
PiA+PiA+IGJyZWFrOwo+ID4+ID4KPiA+PiA+IGRlZmF1bHQ6Cj4gPj4gPiAg IG15aGVhZGVyKCL3
yM/EISIpOwo+ID4+ID4gICAgICBpbmNsdWRlICRfU0VSVkVSWydET0NVTUVO VF9ST09UJ10uCj4g
Pj4gPiAgICAgICAgICAgICAgJy9odG1sL2Zvcm1zL2xvZ2luX2Zvcm0uaHRt bCc7Cj4gPj4gPiAg
IGZvb3RlcigpOwo+ID4+ID4gYnJlYWs7Cj4gPj4gPiB9Cj4gPj4gPiA/Pgo+ ID4+ID4KPiA+PiA+
IGRhdGFiYXNlLnBocDoKPiA+PiA+IDw/cGhwCj4gPj4gPiAkbGluayA9IG15 c3FsX3Bjb25uZWN0
KCdsb2NhbGhvc3QnLCdyb290JywndGVzdGluZycpOwo+ID4+ID4gJHNldCA9 IG15c3FsX3F1ZXJ5
KCdTRVQgTkFNRVMgQ1AxMjUxJyk7Cj4gPj4gPiAkc2V0ID0gbXlzcWxfcXVl cnkoJ1NFVF9DT0xM
QVRJT049Q1AxMjUxX0dFTkVSQUxfQ0knKTsKPiA+PiA+IG15c3FsX3NlbGVj dF9kYignc2FtZWtf
ZGInLCAkbGluaykgb3IgZGllKG15c3FsX2Vycm9yKCkpOwo+ID4+ID4KPiA+ PiA+ID8+Cj4gPj4g
Pgo+ID4+ID4gY29tbW9uLnBocDoKPiA+PiA+IDw/cGhwCj4gPj4gPgo+ID4+ ID4gLy8gSW5jbHVk
ZSBNZXRhIENvbnRlbnQgQ2xhc3MKPiA+PiA+IGluY2x1ZGUgJF9TRVJWRVJb J0RPQ1VNRU5UX1JP
T1QnXS4nL2NsYXNzZXMvY2xzTWV0YUNvbnRlbnQucGhwJzsKPiA+PiA+Cj4g Pj4gPiAvLyBJbmNs
dWRlIEVtYWlsIENsYXNzCj4gPj4gPiBpbmNsdWRlICRfU0VSVkVSWydET0NV TUVOVF9ST09UJ10u
Jy9jbGFzc2VzL2Nsc0VtYWlsLnBocCc7Cj4gPj4gPgo+ID4+ID4gLy8gSW5j bHVkZSBEYXRhYmFz
ZSBDb25uZWN0aW9uIEZpbGUKPiA+PiA+IGluY2x1ZGUgJF9TRVJWRVJbJ0RP Q1VNRU5UX1JPT1Qn
XS4nL2luY2x1ZGVzL2RhdGFiYXNlLnBocCc7Cj4gPj4gPgo+ID4+ID4gLy8g SW5jbHVkZSBTZXNz
aW9uIEZpbGUKPiA+PiA+IGluY2x1ZGUgJF9TRVJWRVJbJ0RPQ1VNRU5UX1JP T1QnXS4nL2luY2x1
ZGVzL3Nlc3Npb24ucGhwJzsKPiA+PiA+Cj4gPj4gPiA/Pgo+ID4+ID4KPiA+ PiA+IFRoYW5rIHlv
dSBmb3IgeW91ciBoZWxwCj4gPj4gPgo+ID4+ID4KPiA+PiA+IFlvdSdyZSB2 ZXJ5IHdlbGNvbWUs
IEkgdW5kZXJzdGFuZCB0aGF0IHlvdSBuZWVkIGEgc29sdXRpb24gd2hpY2gK PiBhbGxvd3MKPiA+
PiB5b3UKPiA+PiA+IHRvIGtlZXAgdXNpbmcgdGhlIGNvbm5lY3Rpb24gdGhp cyB3YXkuCj4gPj4g
Pgo+ID4+ID4gSSBkb3VidCB0aGF0IHlvdXIgcGhwLmluaSBpcyB0aGUgY2F1 c2Ugc28gSSdsbCBz
dWdnZXN0IHRoZSBmb2xsb3dpbmc6Cj4gPj4gPgo+ID4+ID4gVHJ5IGV4ZWN1 dGluZyB5b3VyIE15
U1FMIHF1ZXJpZXMgYnkgcGFzc2luZyB0aGUgJGxpbmsgdmFyaWFibGUgdG8g dGhlCj4gPj4gPiBm
dW5jdGlvbiBhcyB0aGUgY29ubmVjdGlvbiByZXNvdXJjZToKPiA+PiA+Cj4g Pj4gPiBteXNxbF9x
dWVyeSgiU0VMRUNULi4uIiwgJGxpbmspOwo+ID4+ID4KPiA+PiA+IFNvbWV0 aGluZyB0aGF0IGFs
c28gbWlnaHQgY2F1c2UgaXQgaXMgdGhhdCB5b3UgdXNlCj4gPj4gKGluY2x1 ZGV8cmVxdWlyZSlf
b25jZQo+ID4+ID4gYW5kIHRoYXQgdGhpcyBtb2R1bGUgZG9lc24ndCBoYXZl IGFjY2VzcyB0byB0
aGUgY29ubmVjdGlvbiByZXNvdXJjZSwKPiBpZgo+ID4+IHRoaXMKPiA+PiA+ IGlzIHRoZSBjYXNl
IGNoYW5nZSBpdCBpbnRvIGluY2x1ZGV8cmVxdWlyZSBhbmQgc2VlIGlmIHRo YXQgc29sdmVzIHlv
dXIKPiA+PiA+IGlzc3VlLiBJZiBub3QgdGhlbiBjb3VsZCB5b3UgcGxlYXNl IHBvc3Qgc29tZSBl
eGFtcGxlIGNvZGUgb2YgeW91cgo+ID4+IG1vZHVsZQo+ID4+IGlmCj4gPj4g PiBwb3NzaWJsZSBz
byB3ZSBjYW4gYmUgbW9yZSBoZWxwZnVsPwo+ID4+ID4KPiA+PiA+IEFsc28g YmUgc3VyZSB0aGF0
IHlvdSBnbG9iYWwgJGxpbms7IGl0IGluIGZ1bmN0aW9ucyAoSSBkb24ndCBr bm93IGlmCj4gPj4g
dGhpcwo+ID4+ID4gcmVxdWlyZWQgc2luY2UgSSBkaWRuJ3QgdXNlIGl0IHRo aXMgd2F5IGZvciBh
IGxvbmcgd2hpbGUpLgo+ID4+ID4KPiA+PiA+IENvdWxkIHlvdSBhbHNvIHBs ZWFzZSBhbnN3ZXIg
dG8gdGhlIGxpc3QgaW5zdGVhZCBvZiBkaXJlY3RseSB0byBtZSBhcwo+ID4+ IHRoaXMKPiA+PiA+
IG1pZ2h0IGFsc28gYmUgaW5mb3JtYXRpdmUgZm9yIG90aGVycy4KPiA+PiA+ Cj4gPj4gPiAtLQo+
ID4+ID4gVmlldyB0aGlzIG1lc3NhZ2UgaW4gY29udGV4dDoKPiA+Pgo+IGh0 dHA6Ly93d3cubmFi
YmxlLmNvbS9QSFAtTXlTUUwtY29ubmVjdGlvbi1mb3ItcGFydGljdWxhci1t b2R1bGUtdHAxNzkx
NTEwOHAxNzk5MDE5Mi5odG1sCj4gPj4gPiBTZW50IGZyb20gdGhlIFBocCAt IERhdGFiYXNlIG1h
aWxpbmcgbGlzdCBhcmNoaXZlIGF0IE5hYmJsZS5jb20uCj4gPj4gPgo+ID4+ ID4KPiA+PiA+IC0t
Cj4gPj4gPiBQSFAgRGF0YWJhc2UgTWFpbGluZyBMaXN0IChodHRwOi8vd3d3 LnBocC5uZXQvKQo+
ID4+ID4gVG8gdW5zdWJzY3JpYmUsIHZpc2l0OiBodHRwOi8vd3d3LnBocC5u ZXQvdW5zdWIucGhw
Cj4gPj4gPgo+ID4+ID4KPiA+Pgo+ID4KPiA+Cj4gPgo+ID4gLS0KPiA+IElz YWFrIE1hbGlrCj4g
PiBXZWIgRGV2ZWxvcGVyCj4gPgo+ID4KPgo+IC0tCj4gVmlldyB0aGlzIG1l c3NhZ2UgaW4gY29u
dGV4dDoKPiBodHRwOi8vd3d3Lm5hYmJsZS5jb20vUEhQLU15U1FMLWNvbm5l Y3Rpb24tZm9yLXBh
cnRpY3VsYXItbW9kdWxlLXRwMTc5MTUxMDhwMTgwMDU3NDkuaHRtbAo+IFNl bnQgZnJvbSB0aGUg
UGhwIC0gRGF0YWJhc2UgbWFpbGluZyBsaXN0IGFyY2hpdmUgYXQgTmFiYmxl LmNvbS4KPgo+Cj4g
LS0KPiBQSFAgRGF0YWJhc2UgTWFpbGluZyBMaXN0IChodHRwOi8vd3d3LnBo cC5uZXQvKQo+IFRv
IHVuc3Vic2NyaWJlLCB2aXNpdDogaHR0cDovL3d3dy5waHAubmV0L3Vuc3Vi LnBocAo+Cj4KCgot
LSAKSXNhYWsgTWFsaWsKV2ViIERldmVsb3Blcgo=
------=_Part_4324_15293309.1213871805504--

Re: PHP-MySQL connection for particular module

Eric,

You gessed right. Both of the files are in my "docroot" directory.
I tried this. Unfortunely, it did not work ( perhaps, I did not use it
right), although, I followed your instructions.

Isaak gave me an idea which solved my problem (see his replies).

Thank you


Eric-275 wrote:
>
>
> ----------------------------------------------------
> http://myprojects.srhost.info
> eric{at}myprojects{dot}srhost{dot}info
> ----- Original Message -----
> From: "bateivan"
> To:
> Sent: Tuesday, June 17, 2008 11:19 PM
> Subject: [PHP-DB] PHP-MySQL connection for particular module
>
>
> :
> : Hello,
> :
> : First of all, please, have in mind that I am new in this business.
> :
> : I have a problem connecting with data base in one particular module.
> That's
> : right. The rest of the modules can connect to db, update tables with new
> : info but this one is refusing giving me message like this:
> :
> : "Warning: mysql_query() [function.mysql-query]: Access denied for user
> : 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache
> Software
> : Foundation\Apache2.2\htdocs\login.php on line 17
> :
>
> This error message state that you have provided a wrong username and / or
> password
> use the die also to ensure the connection was created.
>
> : Warning: mysql_query() [function.mysql-query]: A link to the server
> could
> : not be established in
> : D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php
> on
> : line 17"
> :
> :
> : It is a authentication module and this is the fragment of the code which
> is
> : giving me a hard time:
> :
> :
> ************************************************************ *******************
> : > : include $_SERVER['DOCUMENT_ROOT'].
> : '/layout.php';
> :
>
> Let's your included page on the same directory. Say f:\webroot\docroot
> As
> f:\webroot\docroot\layout.php
> f:\webroot\docroot\login.php
>
> then try change the line from
>
> include $_SERVER['DOCUMENT_ROOT'].
> '/layout.php';
>
> to
>
> $app_root = './';
> include ($app_root . 'layout.php');
>
>
> : switch($_REQUEST['req']){
> :
> : case "validate":
> :
> : $validate = mysql_query("SELECT * FROM members
> : WHERE username = '{$_POST['username']}'
> : AND password = md5('{$_POST['password']}')"
> : );
> :
> : etc....
> :
> :
> ************************************************************ *******************
> :
> : My platform is WinXP on drive F:\ (I have Win'98 on C:\) and as you can
> see
> : my program files are on D:\. All this may not be important but I listed
> : anyway.
> : It is installed Apache 2.2.6 using windows installer, PHP 5.2.6 (I just
> : replaced 5.2.5 hoping to fix the problem), and MySQL 5.0.45.
> :
> : I am using persisten connection which should be on until you restart the
> : server. I have a file included in every page for connection with MySQL
> and
> : data base.
> : PHP manual says that "mysql_query" reuses the existing connection or try
> to
> : create one if not present (I think, according to the warning is trying
> to
> : create one).
> : I had been checking after each step using phpinfo() if the connection is
> : there and it's there but for some reason the above fragment does not
> work.
> : As I mentioned above the rest of my modules are working fine with mysql.
> :
> : I checked the "php.ini" file. I compared it to "php.ini.recomended" from
> the
> : .zip distribusion package and they are almost identical exept couple of
> : things for error reporting.
> : I, also checked FAQ, mail listings and other forums but it does not seem
> : anybody had a similar problem.
> :
> : In one of my tests I included a line for connection just before the
> problem
> : lines, as described below, and it worked but my intention is to keep
> such
> : lines in a separate files and include them in every page instead.
> :
> :
> ************************************************************ *******************
> : .......
> :
> : $link = mysql_pconnect('localhost', 'root', 'testing');
> :
> :
> : $validate = mysql_query("SELECT * FROM members
> : WHERE username = '{$_POST['username']}'
> : AND password = md5('{$_POST['password']}')"
> : );
> : etc.
> :
> ************************************************************ *******************
> :
> : As I metioned, this is an authentication module and, may be, that's why
> is
> : behaving diferently from the rest or I need to do some setup changes in
> : "php.ini" which I am not familiar with.
> :
> : If anyone has had simmilar problem I would appreciate his/her input.
> Please,
> : help me resolve this mistery.
> :
> : --
> : View this message in context:
> http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p17915108.html
> : Sent from the Php - Database mailing list archive at Nabble.com.
> :
> :
> : --
> : PHP Database Mailing List (http://www.php.net/)
> : To unsubscribe, visit: http://www.php.net/unsub.php
> :
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

--
View this message in context: http://www.nabble.com/PHP-MySQL-connection-for-particular-mo dule-tp17915108p18005755.html
Sent from the Php - Database mailing list archive at Nabble.com.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

> [new code]
> if (!mysql_connect($a, $b, $c)) return;
>
> if (!mysql_select_db($dbname)) return;
>
> $res = mysql_query("SELECT * FROM manual;", $link);
> [/new code]


Isn't going to work because $link is not defined and definitely not a
resource like mysql_query expects.

> OR, optionally, to surpress the warnings:
>
> [new code]
> if (!mysql_connect($a, $b, $c)) return;
>
> $link = null;
>
> if (!mysql_select_db($dbname)) return;
>
> $res = mysql_query("SELECT * FROM manual;", $link);
> [/new code]

Isn't going to work because mysql_query needs a resource to connect to.
You've defined $link as null.

$ cat test.php
$user = 'my_db_user';
$pass = 'my_pass';
$host = 'localhost';
$db = 'my_db';

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

if (!mysql_connect($host, $user, $pass)) {
die("unable to connect");
}

if (!mysql_select_db($db)) {
die("unable to choose db");
}

$link = null;
$res = mysql_query('select version() as version', $link);
while ($row = mysql_fetch_assoc($res)) {
print_r($row);
}


$ php test.php

Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /path/to/test.php on line 19

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in /path/to/test.php on line 20


--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP-MySQL connection for particular module

I should've checked the assumption.

A little strange though for a scripting language. I'd say, since
default behaviour of mysql_* functions is to assume the last opened
link when a parameter is not passed, and since default behaviour is to
evaluate null, false and 0 the same, mysql_* functions should issue a
warning when a not valid link is passed but still use the last opened
link (in that logic, null should also generate a warning though). I'm
guessing the reason is that mysql_connect returns false when it fails,
but i can't see a reason why an undefined variable cannot be used.

All that and I don't remember what it was for.

On Fri, Jun 20, 2008 at 1:57 AM, Chris wrote:
>
>> [new code]
>> if (!mysql_connect($a, $b, $c)) return;
>>
>> if (!mysql_select_db($dbname)) return;
>>
>> $res = mysql_query("SELECT * FROM manual;", $link);
>> [/new code]
>
>
> Isn't going to work because $link is not defined and definitely not a
> resource like mysql_query expects.
>
>> OR, optionally, to surpress the warnings:
>>
>> [new code]
>> if (!mysql_connect($a, $b, $c)) return;
>>
>> $link = null;
>>
>> if (!mysql_select_db($dbname)) return;
>>
>> $res = mysql_query("SELECT * FROM manual;", $link);
>> [/new code]
>
> Isn't going to work because mysql_query needs a resource to connect to.
> You've defined $link as null.
>
> $ cat test.php
> > $user = 'my_db_user';
> $pass = 'my_pass';
> $host = 'localhost';
> $db = 'my_db';
>
> error_reporting(E_ALL);
> ini_set('display_errors', true);
>
> if (!mysql_connect($host, $user, $pass)) {
> die("unable to connect");
> }
>
> if (!mysql_select_db($db)) {
> die("unable to choose db");
> }
>
> $link = null;
> $res = mysql_query('select version() as version', $link);
> while ($row = mysql_fetch_assoc($res)) {
> print_r($row);
> }
>
>
> $ php test.php
>
> Warning: mysql_query(): supplied argument is not a valid MySQL-Link
> resource in /path/to/test.php on line 19
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in /path/to/test.php on line 20
>
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php