Newsflash

Chephrenrepairs expands, yep we have now reached the exstent of our Web Space available on our web server, so we are buying up more space, a logical progression really... plus we are going to be writing a lot more dynamic Web pages and am going to be entering ourselves into a lot more on line directories.
One project we want to kick start today with real ver ver voom is a few web pages that tel you just exactly what Computer services  you can expect to get from this little company in the Heart of the Thames Valley.. we have some insane and ambitious plans and one part of that is writing pages that do not just sit there and remain static, but ones that change every time you load them....
intrigued ahhh .haaa.
How is this done well with PHP and MySQL Mainly, but we  reserve the right to use Ajax, no that’s not a toilet cleaner, Java Script, CSS and a few other web technologies
Oh yes and if you want to learn about this yourself ring us up and join Webspinners - your local web witting group!!!

Ohh gosh did not realize that Chephrenrepairs also runs a class for people wanting to Learn Web Design in the Centre or Reading Berkshire - a one Day intense SEO Course ring us to find out more

powered_by.png, 1 kB

uninstalling and reinstalling php
Written by The Processor   
Saturday, 27 December 2008
Lets say that for some reason you wish to uninstall your current version of php and install a different one.
There is not really recognizable way of uninstalling php, unlike a lot of programs you can not us the uninstall programs icon in the control panel, in stead you approach should be to delete the directory that php is in and then to look in the apache configuration file and either remove all the lines you put in yourself when you installed php or just make them all into comments.

You can edit the main configuration file of the Apache web server using notepad, which is on every windows computer. so here we tell you how to start note pad and where and what the main config  fle for apache is.
Where is the main configuration file for Apache to be found?

ans.  for Apache version 2 the main configuration file will be here;
c:/Program Files/Apache2/conf/http.conf

How to start notepad :
go to the start button, choose All Programs, Accessories, notepad

If you want to know where to go to get hold of some of the older versions of php for Windows, you can go here:
a link to a  page to get php downloads for windows computers

ok, so we are going to see if we can remove php version 5.2.5 and then afterwords, install and configure up php version 5.2.2.
Why would we want to do this you may ask? well the answer to that is that the version of php that we are running at


 
Last Updated ( Saturday, 27 December 2008 )
Basic Details Setting Up a Local Web Server
Written by The Processor   
Thursday, 20 November 2008
Look you do not have to set up a local Apache Web Server, But what if ypu want to test your PHP scripts that use a MySQL Database locally before you put your scripts up to the live server, well ... then you need a local Computer with Apache installed and with PHP instaled and with a MySQL Server and client installed. And finally you need to configure the Apache Server so that it reconises that PHP is avalable locally.

We have done this on a Fujitsu Siemens Laptop with 512 MB af memory with Centrino processor in it and it works just fine..

Look you really need to just get the Apache Server to recognise in its main configuration file that a version of PHP is runnning locally, Of Course PHPand MySQL versions move on fast, and not every version of PHP works with every version of Apache. This can unstick you really fast....

You should use IE (Internet Explorer )to download Apache server as Firefox sometimes fails to do this properly!!!???
Run Apache as a Service  and make sure that The Apache Monitor (you will see this as a little circle in the task bar with a little feather sticking out of it) says that Apache Services a\re running
You should dowload a program that allows you to run scripts and queries on the data base, stangely that program is provided free by MySQL themelves and is calle MySQL Query Browser. You can easely find it on  the web.
Last Updated ( Thursday, 20 November 2008 )
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\
Written by The Processor   
Saturday, 27 December 2008
So you are reading this because you wonder why when you write a line of php code to connect to a mysql database on your local machine that it causes a fatal error in php, that error is of course something like this:

Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\

OK so whats going on??? Well the error occurs when php encounters a line of code that is simply designed to connect to a local mysql  server, and it is very likely to be caused by two or so possible things: it is possible that the version of php you are running was installed correctly but never came bundled with the appropriate bits to handle mysql databases at all, and the second possible reason is that some how php is not configured correctly??


It would be so much easier wouldn't it if the various versions of php that you can get off the web simply stated right up front what features or functions they did not have or work with, then you might just know straight off.... so we go hunting on the web to see whether or not it is the case that our version of php we have currently installed is simply just not able to undertake any operations with mysql databases, we might start with a little googling!!

we fond quite a few things n the web suggesting that both php 5.2.5 and php 5.2.6 both do not have inbuilt mysql support, and you guessed it we are using php version 5.2.5.... mmmm so looks like this could be the problem we googled some more only to find that it is possible that although the standard install of php 5.2.5 has a php ini file that does not have the right lines in it to make it talk to mysql, it may be just a case of changing a couple of lines.....

inside php.ini, which you will probably find inside your php directory there are many lines, and you can edit this file using good old notepad..... the lines that you can try changing are simply these ones
;extension=php_mysql.dll
and
;extension=php_mysqli.dll

try removing the two colons at the front of each line then save the php.ini file, then stop and restart the apache web server...
we did and it appears to not have solved the problem!!??

so, we looked at our laptop to see which versions of php we had available to install, and we found that we have as well as php5.2.5 in a .zip file, we also have php5.2.2win32-installer.msi and php 4.4.7-win32.zip, so it looks like we have two choices of different php versions we could try to solve the problem.

so one question is this.... if php 5.2.5 can not handle dealing with Mysql then can either of the other two i mention above handle connecting to a mysql server better....../?


another question springs to mind, and that is: Just how do you configure either php 4 or 5 to work correctly with a local mysql server?

a simple question but ohhhh gosh the answer is complicated... why.... well for one thing php 4 and 5 both have quite different structures, and hence use different dll's and libraries to achieve certain jobs..... namely in this case to executeing php functions that relate to mysql !!

and here is another question:

How do you really know that any particular version of php does fully support communication with and running all related php functions that handle a mysql server??

This is a really important question, because you do not want to set up a new test environment with a version of php that can not work with a local Mysql server do you!!?? ok so we are going to attempt to answer all these question fully, no mean feet, and the answers will be found on our web site published by us as a result of actual research that we have done on a real lap top running xp sp3,

Ok, so if you have read all above, you will be thinking perhaps not every version of php5 comes with proper MySQL support bundeled in it, we are not completely sure that this is absolulely true!! and what we can say is having looked at our lap top that was not connecting to the Local MySQL Server when asked to: we have now gone and installed Apache, MySQL, PHP 5 and MySQL Query Browser and My SQL Administrator on to a Desk Top PC Running XP Home Service pack 3. and signs are that this is working properly.... we will be testing this much more over the next few days.

We are going to do several things, one we are going to write about installing Apache 2.2.11, MySQL 5.1 and PHP 5.2.8 on our Desk Top PC running Windows XP Home Service pack 3, and also running Kapersky Internet Security 7 also.

Secondly we are going to completely rebuild the laptop which is a Fujitzu Amilo Pro and around 3 Years old from scratch, what this means is starting from the very begining with formatting the disk and using the DVDs that came with the machine when it is new, So installing the OS then all the Hardware Drivers , then Bit Defender, then otrher software that was there before and finishing with Apache, MySQL and PHP and some Nice MySQL Gui programs mention directly above.

"It looks like it is possible that the php Version currently on the lap top  5.2.5 may be misbehaving not because it is bust or not capable of supporting MySQL, but may be miss behaving because there is some other software problem on the laptop that is simply making it unable to work as we would like and we have not identified what that is,!!!"

By rebuilding the entire laptop Software Wise we should eliminate any problems for the time being!!! What we are attempting to do it so set up a New Web Development Environment Locally, so we can test all php scripts that interact with a MySQL Server locally before puting up to a live Web Server...




 




Last Updated ( Sunday, 04 January 2009 )
<< Start < Prev 1 2 3 4 Next > End >>

Results 1 - 4 of 13
Polls
Which BroadBand Do You Have at Home
  
What Problems Have I had with my Computer in the Last Year
  
Who's Online
We have 1 guest online
Copyright 2000 - 2005 Miro International Pty Ltd. All rights reserved.
Mambo is Free Software released under the GNU/GPL License.