Author Topic: new to php mssql  (Read 2864 times)

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« on: May 16, 2010, 07:18:28 AM »
hi all
im new to php and im stuck...
i have installed ms sql 2008 express, works fine and remote login wokrs good.
i have installed apache 2.2
i have installed php 5.2.13
on os server 2008. all works ok on there own
now this is were im stuck...:eek::eek:

i cant get php to connect to mssql to get database info.

can anyone help please:confused::confused:

Offline toetag

  • Jr. Member
  • **
  • Posts: 65
new to php mssql
« Reply #1 on: May 16, 2010, 09:57:57 PM »
i can't offer any real assistance to your problem.  I spent a few days looking into PHP connectivity with MSSQL and the best solution I came up with was to dump MSSQL and load MySQL.

Unless it's changed since I looked I read something about PHP not supplying MSSQL dll files any longer and to use some alternative.  there's a few links in google that might help but honestly after 4 days of trying with MSSQL, i loaded MySQL and had MySQL and RoundCube running in about 15 minutes.

a quick and dirty way is to install XAMPP  apache, mysql, php (you can choose not to install filezilla and mercury mail transport).
<[ a desert to an irishman is an empty glass. ]>

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« Reply #2 on: May 17, 2010, 08:57:44 AM »
hi
i installed mysql and i like it. will have a play with it today to get me head around it.

how do i get php to work with mysql, ie edit apache config file and add some sort of mod for mysql:rolleyes:

Offline toetag

  • Jr. Member
  • **
  • Posts: 65
new to php mssql
« Reply #3 on: May 17, 2010, 09:10:16 AM »
if you used XAMPP, it automatically configures all of the products to work together.  If you didn't. You might have to edit your extensions in PHP.ini and make sure the mysql libs are uncommented.

Google is your friend here.
<[ a desert to an irishman is an empty glass. ]>

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« Reply #4 on: May 17, 2010, 11:13:24 AM »
hi
i seem tobe ok with basics on mysql now(very basics)..
i have installed phpmyadmin and phpmyadmin cant connect to mysql???
error message :-
Cannot load mysqli extension. Please check your PHP configuration. - Documentation
on web page


ive google but still cant get it to work. i just have this one step todo to get my web page working..
:eek::eek::eek:

Offline Julius Caesar

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 498
    • http://www.de-keizer.net/
new to php mssql
« Reply #5 on: May 18, 2010, 03:46:48 AM »
Did you install the PHP-MYSQLI extension?

Check here for more information installing extensions on Windows-based computers
Julius Caesar

You can download the Groupvice4 theme here.
Sie können Groupvice4 hier he

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« Reply #6 on: May 18, 2010, 06:15:17 AM »
hi thanks for your help
i still cant get it to work.

extension=php_bz2.dll done and dir path

Offline Julius Caesar

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 498
    • http://www.de-keizer.net/
new to php mssql
« Reply #7 on: May 18, 2010, 06:54:52 AM »
php_bz2.dll is an extension for bzip2.

The extension for mysql 5.x is php_mysqli.dll as you could have seen in the list.
Julius Caesar

You can download the Groupvice4 theme here.
Sie können Groupvice4 hier he

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« Reply #8 on: May 18, 2010, 08:37:19 AM »
hi
tryed it, still same problem??

Offline c_owl

  • Newbie
  • *
  • Posts: 6
new to php mssql
« Reply #9 on: May 18, 2010, 06:14:19 PM »
so after trying everything i got it working..
i used my programming pc to do a fresh install of xampp, and found were i went wrong
i didnt uninstall my old apache setup, just installed xampp on top and got config files mixed up.

so well happy its now working.

is there a program that alows import of ms access dbs to mysql

thanks again everyone:):)