Re: [PHP-DB] problem in connecting to mysql from php
create a file with phpinfo() and make sure mysqli is listed in the loaded modules On Tue, Jun 14, 2011 at 12:07 PM, Niel Archer n...@chance.now wrote: Hello everyone, I am in the process of learning php and I was trying to connect to a mysql database on my own computer(localhost). I have done the following as prerequisites: copied the dll files in system32 removed the semicolon(;) from extension=php_mysqli.dll You should NOT need to move the .dll at all. There is a setting in the ini which tells PHP where to look for extensions and that should have pointed to the original location. Hence, removing the semicolon should be the only part necessary. In spite of doing the above when I try to run the following : ?php $db = new MySQLi('localhost', 'root', 'Password123', 'test'); $sql = 'SELECT * FROM a123'; $result = $db-query($sql); while($row = $result-fetch_object()) { echo 'div' . $row-name . '/div'; } $db-close(); ? I get the error: *Fatal error*: Class 'MySQLi' not found in *C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on line *2 *Please guide me as to how can I get rid of this error? Regards, Kushal -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- *Share with free mind!* Join I.T professionals on http://www.tuwana.com For Web development and design http://abahjoseph.com Follow me on Twitter http://twitter.com/freefazee Mobile: *+2348066100671*
[PHP-DB] Module positioning
Sorry if i`m posting on the wrong list. i have used joomla and prestashop open source application and enjoy the way modules are position, prestashop uses HOOK to position modules inside the template while in joomla you define position name and place the module inside the position, in my own case, i just need the theory behind it. i can code it but i need the theory or some idea where to start from. i`m planning to use smarty as my template engine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Role Based Access Control and Role Based Security
Hi list, thank to the wonderful people on this list. I am planning a system that require access to the system based on Role, i love the implementation in SMF(www.simplemachines.org) that every modules can define there own role and but i don`t know how. Users will be in group like Administrator, Editor, Manager etc (i have seen such on Joomla) and each module can define the action each group can perform e.g An advertisement module will define something like 'Can add', 'Can edit own', 'can edit any', etc.. i am wondering what the database structure/PHP Class will look like. I found a database Schema on Access Control at http://www.databaseanswers.org/data_models/access_control/index.htm but i can`t figure out the implementation in PHP. Any idea will help. -- Share with free mind! Join the world largest open forum for hackers and programmers. http://www.tuwana.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Authenticating user using a web service
Well, I have asked this question before but it seems people don`t understood me, my intension is to have a second login option like, user may choose to login with they facebook/myspace/etc id or the local id (my site) on my site, I want a situation whereby anyone can choose to register or use an existing social network id and password to login, so I am thinking of using facebook, but i don`t really understand something about facebook application, the application always, first go to facebook then redirect back to the site (callback url), I want all this process done under the hood. Can someone give me another idea? I will just love any simple idea that will help.
[PHP-DB] Help with Web services (facebook, myspace)
Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using their facebook and myspace id. if this is not possible, can i find something closer like, user will be able to perform some activities from my site like inviting facebook/myspace friends, send IVs etc. Please very new in this. Thank you
Re: [PHP-DB] Help with Web services (facebook, myspace)
I just saw something on pear.net http://pear.php.net/package/Services_Facebookmaybe it will work. On Wed, Jan 21, 2009 at 10:27 PM, Chris dmag...@gmail.com wrote: Abah Joseph wrote: Hello PHP people, I`m looking for facebook and myspace API that will enable user to login on my site using their facebook and myspace id. if this is not possible, can i find something closer like, user will be able to perform some activities from my site like inviting facebook/myspace friends, send IVs etc. http://developers.facebook.com/?ref=pf I don't know if myspace has a developer area but ask in their forum: http://forums.myspace.com/?fuseaction=forums.home -- Postgresql php tutorials http://www.designmagick.com/ -- I develop dynamic website with PHP MySql, Let me know about your site
[PHP-DB] help me JOIN 3 tables.
I have this SQL SELECT e1.*, l1.* FROM e1 INNER JOIN l1 WHERE e1.entre_active = 'Y' AND l1.entreID = e1.entre_id The above query works but i want to add the one below SELECT SUM(a1.adp_amount) as amount FROM a1 WHERE a1.adp_loanID = e1.loanID; the last part of the query is to SUM the part payment made on table 'l1' and return total raised with the first query. the whole idea is three tables, (business, loan, raised), loan referenced ID from business, raised referenced ID from loan. loan maybe $300 and it can be raised over time till completed, so all the amount raised + the loanId will be stored inside the raised table. Thank you
[PHP-DB] Post/Read tutorial at Tuwana.com
Post your article/tutorial on www.tuwana.com, is a new forum that brings together world programmers and hackers.
[PHP-DB] Can MySql handle Large data?
I want to quickly ask if MySql can handle large data like 10 – 20 million rows in one database (e.g member table) The question came to my mind is, How did large website like Yahoo handle such data? Sure. Yahoo users may be more than 20 millions users or so. Users will have -permission table -profile table -page table and so on, so query will be perform on 2 or three tables same time, i`m trying to check the speed, performance and risk . I need your advice on how to handle such data and the best structure to use.
[PHP-DB] Win32 system administrator gpedit.msc
Hi everybody... i`m not a prof in english so please read and understand me.. Thank u. Using the win32 python module can we perform every tasks like *gpedit.msc?* i will like to automate tasks like enabling or disaple some of the windows functions. with my basic experince, you can perform important adminsitrative tasks using gpedit.msc. Like today, some virus hidded my start menu/program file and i have to use gpedit.msc to enable it. point me to some article that talk about this.