To Evert:
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".
To bateivan:
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 in
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...
And register_globals allows you to use short variables for super global
arrays. Ex: $name instead of $_POST['name'], etc.
On Wed, Jun 18, 2008 at 9:47 PM, Evert Lammerts <evert.lammerts@xxxxxxxxx>
wrote:
> 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 <ivanovivans@xxxxxxxx> wrote:
> >
> > Hello,
> >
> > To answer these qwestions:
> > 1. I am using "include" in my code.
> > 2. About the "$link = 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:
> > <?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 '<p align="center">Липсва информациятя от формата!</p>'.
> > '<p align="center">Моля, използвайте бутона'.
> > 'Назад и въведете данните отново!</p>';
> > footer();
> > exit();
> > }
> >
> > // Insert Query
> > $sql = mysql_query("INSERT INTO carmade
> > (car_descr)
> > VALUES('{$_POST['car_descr']}')");
> >
> > // Insert query results
> > if(!$sql){
> > echo "Грешка при въвеждане на данните:".mysql_error();
> > } else {
> >
> > echo '<p align="center">Марката "'.$_POST['car_descr'].
> > '"е въведена<br/>с номер:'.mysql_insert_id();
> > echo '<br /> /admin/carmade.php?req=new_carmade Искате ли да'.
> > 'въведете друга марка? ';
> > }
> > break;
> >
> > // Create car made form case
> > case "new_carmade":
> > myheader("Въвеждане на нова автомобилна марка");
> > include $_SERVER['DOCUMENT_ROOT'].
> > '/html/forms/carmade_insert.html';
> > footer();
> > break;
> >
> > default:
> > myheader("Администриране на списъка с автомобилните марки");
> > include $_SERVER['DOCUMENT_ROOT'].
> > '/html/carmade_admin.html';
> > footer();
> > break;
> >
> > }
> > ?>
> >
> > login.php:
> > <?php
> > 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']}')"
> > );
> >
> > $num_rows = mysql_num_rows($validate);
> >
> > if($num_rows == 1){
> > while($row = mysql_fetch_assoc($validate)){
> > $_SESSION['login'] = true;
> > $_SESSION['userid'] = $row['member_id'];
> > $_SESSION['first_name'] = $row['first_name'];
> > $_SESSION['last_name'] = $row['last_name'];
> > $_SESSION['email_address'] = $row['email_address'];
> >
> > if($row['admin_access'] == 1){
> > $_SESSION['admin_access'] = true;
> > }
> > $login_time = mysql_query("UPDATE members
> > SET last_login=now()
> > WHERE id='{$row['id']}'");
> > }
> > header("Location: /loggedin.php");
> > } else {
> > myheader("Входът в административната зона е неуспешен!");
> > echo '<p align="center">Входът в страницата не е успешен!</p>';
> > echo '<p align="center">Проверете потребителското си '.
> > 'име и паролата си и опитайте пак или се '.
> > 'обадете на администратора.</p>';
> > footer();
> > }
> > break;
> >
> > default:
> > myheader("Вход!");
> > include $_SERVER['DOCUMENT_ROOT'].
> > '/html/forms/login_form.html';
> > footer();
> > break;
> > }
> > ?>
> >
> > database.php:
> > <?php
> > $link = mysql_pconnect('localhost','root','testing');
> > $set = mysql_query('SET NAMES CP1251');
> > $set = mysql_query('SET_COLLATION=CP1251_GENERAL_CI');
> > mysql_select_db('samek_db', $link) or die(mysql_error());
> >
> > ?>
> >
> > common.php:
> > <?php
> >
> > // Include Meta Content Class
> > include $_SERVER['DOCUMENT_ROOT'].'/classes/clsMetaContent.php';
> >
> > // Include Email Class
> > include $_SERVER['DOCUMENT_ROOT'].'/classes/clsEmail.php';
> >
> > // Include Database Connection File
> > include $_SERVER['DOCUMENT_ROOT'].'/includes/database.php';
> >
> > // Include Session File
> > include $_SERVER['DOCUMENT_ROOT'].'/includes/session.php';
> >
> > ?>
> >
> > Thank you for your help
> >
> >
> > 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.
> >
> > --
> > View this message in context:
> http://www.nabble.com/PHP-MySQL-connection-for-particular-module-tp17915108p17990192.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
