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:
> 
> 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 <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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
> 
> 

-- 
View this message in context: 
http://www.nabble.com/PHP-MySQL-connection-for-particular-module-tp17915108p18005749.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

Reply via email to