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 > >