Re: [PHP-DB] PHP-MySQL connection for particular module
[email protected] (bateivan)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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.