wildteen88

This topic is over 2 years old.

Although not posted in the tutorial section. There are a couple of blog entries for installing/setting up the AMP stack on Ubuntu and CentOS (Part 1 and Part 2)

Yes. That is all you can do. You cannot override how browsers handle cookies. If you have set your cookie with an expired date the browser should not send the cookie on the next page request.

cookies cannot be deleted. You can only set invalid cookies. The browser will not send cookies which have been expired.

I agree, I will sticky it. I always use the cheat sheets at ilovejackdaniels.com

Completely uninstall MySQL. When MySQL is uninstalled go to where MySQL was installed and delete any leftover files/folders (delete the main mysql folder). Now reinstall MySQL. Mack sure you run the MySQL Server Instance Config Wizard to configure the MySQL server (this may not come with MySQL4).

Please attach the php.ini to your post. You can do this by doing the following: Click the Modify button for your post above this. Expand the Additional Options area. Now attahc your php.ini file to the post. Click Save button. php.ini should now be attached to your post. Also when you added PHP to the path you did restart your PC? You must restart your PC in order for the changes to the PATH to be made.

[quote author=Shears link=topic=87276.msg498622#msg498622 date=1168134461] I have this problem: [b]Cannot load mysql extension. Please check your PHP configuration. - Documentation[/b] The [b]extension_dir[/b] in phpinfo shows [b]c:\php5[/b], yet i definetely have [b]extension_dir[/b] set to [b]c:\php\ext[/b] in the [b]php.ini[/b] file. What am i doing wrong? Despite php.ini being in [b]c:\php[/b], in phpinfo() it says: [b]Configuration File (php.ini) Path C:\WINDOWS[/b] - I dont understand this either. Can someone help please... Thank you Shears :) [/quote] Its because PHP cannot find the php.ini PHP looks in the following places for the php.ini - C:/WINDOWS or C:/WINDOWS/SYSTEM32 - Or in the Windows PATH variable I would recommend you to add PHP to PATH.

You cannot do [i]extension = "C:\PHP\ext\php_mysqli.dll"[/i] to enable a PHP extension. What you need to do is uncomment the extension you want to enable in the php.ini. For example if you want to enable the mysql extension you'll need to find the following in the php.ini: [code];extension=php_mysql.dll[/code] Then you remove the semi-colon from the start of that line. Or if you want use the MySQL Improved Extension you need to add [b]extension=php_mysqli.dll[/b] to end of the extension list in the php.ini Now before you save the php.ini and restart the server you need to make sure the extension_dir directive is setup correctly. To setup the extension_dir scroll up and find this: [code]; Directory in which the loadable extensions (modules) reside.[/code] Below that line should be the extension_dir directive. By defualt it will be this: [code]extension_dir = "./"[/code] Change [B]./[/B] to [B]C:\php\ext[/B] PHP will use this directive to find the extensions. Now save the php.ini and restart your server. Note: make sure a file called libmysql.dll (with is found in the root of the PHP folder (C:\php)) is either in the C:\WINDOWS folder. Note if you are on Win2k or on Windows Server xxxx you put it in the C:\WINNT folder Also it doesnt matter which version of MySQL you have as you can use the php_mysql.dll extension on either version of MySQL. You dont need to enable the php_mysqli.dll function if you are using MySQL5. The thing that sepends on which extension you use is down to the type of mysql functions you are using For example if you are using the [b]mysql_connect[/b] function to connect to MySQL or any other mysql_*() function you use the [b]php_mysql.dll[/b] extension. But if you are using the [b]mysql[color=red]i[/color]_connect[/b] (note the i after mysql) function to connect to MySQL or any other mysql[b]i[/b]_*() function then you use the [b]php_mysqli.dll[/b] extension.

You cannot do this: [code]extension = "C:\PHP\ext\php_mysqli.dll"[/code] You need to setup the extension_dir to point to where your PHP extensions are loacted Then you scroll down and enable the php_mysql.dll extension. You enable this extension for the mysql_* functions. If you are using the mysqli_* functions then you enable the php_mysqli.dll function.

Does it connect fine to the database? Ie: [code=php:0]$conn = mysql_connect('localhost', 'user', 'pass') or die('Unable to connect to the MySQL server<br /><br />' . mysql_error()); mysql_select_db('db_name') or die('Unable to connect to the database<br /><br />' . mysql_error()); echo "Connected to MySQL and the database fine";[/code] If it does then it most probably an error withing your SQL Query. Add this - [code=php:0]or die(mysql_error());[/code] to end of the the mysql_query function when you perform your query. Also you might want to post a help topic in the PHP Help forum. If you query is failing.

I think your script requires the php_mysql.dll extension rather than the php_mysqli.dll extension. Also note PHP doesnt officially support Apache2.2.x.

No you dont you can select multiple records at any one time, by clicking the checkbox for each record you want to edit. The same applies for tables too.

Why you say that? FYI PHPMyAdmin is a web based client which allows you to manage your MySQ: databases/tables. It is free an opensouce however requires your server to have PHP setup. I use phpMyAdmin a lot. If you want a windows GUI, I've not seen many good free ones. However the good ones I have seen cost and can be expensive. I use MySQL Query Browser and MySQL Administrator from time to time but not alot, which are both free and are available from MySQL.com

[!--quoteo(post=380448:date=Jun 6 2006, 03:04 AM:name=skyblog)--][div class=\'quotetop\']QUOTE(skyblog @ Jun 6 2006, 03:04 AM) [snapback]380448[/snapback][/div][div class=\'quotemain\'][!--quotec--] Try for this iam also getting the same fatal error but finally i solved the problem firstly there is no php.ini file in c:\windows Go to php folder where you installed and rename php INI-DEST file to php.ini then copy and paste it to the c:/windows folder then made changes in that file as already mentioned Thank you very much to all giving me some idea ...., [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /] [/quote] Yeah prehaps I should of mentioned that, also you shoud use php.ini-recommended but either file will do.

When looking at your phpinfo details. MySQL and MySQLi support is enabled! If phpinof is showing the details about mysql/i then your mysql extensions have enabled and are working. Also when you make any chnages to both the php.ini or httpd.conf file you must restart the server for the new changes to be made available.

It is beacuse you had added C:\php to the WINDOWS Path variable so this is why it is working. Glad you got it sorted out.

Is php using the correct php.ini file, check with phpinfo to see that php is using the corret php.ini Also did restart Apache when you made any changes to your php.ini file?

Okay what did you use to install PHP? If you used the installer thenm you need to download the zipped binaries from php.net and overite the all the files that installer installed with whats contained in the zipped file. I ahve a feeling you may have incompatibal .dll files.

The post has been moved to the [url=http://www.phpfreaks.com/forums/index.php/board,41.0.html]FAQ/Code Snippet Repository[/url] forum. Click [url=http://www.phpfreaks.com/forums/index.php/topic,95378.0.html]here[/url] to continue. If you have any questions or problems please post  them in this thread.