How to access MySQL through PHP in windows 2K.

How to access MySQL through PHP in windows 2K.

am 28.04.2009 13:42:58 von katiyar76

------=_NextPart_000_00E0_01C9C824.93F71070
Content-Type: multipart/related;
type="multipart/alternative";
boundary="----=_NextPart_001_00E1_01C9C824.93F71070"


------=_NextPart_001_00E1_01C9C824.93F71070
Content-Type: multipart/alternative;
boundary="----=_NextPart_002_00E2_01C9C824.93F71070"


------=_NextPart_002_00E2_01C9C824.93F71070
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Praveen's MailHi List,


I am new to PHP and as well as with MySQL,=20

a.. I have installed PHP 5.28, on win 2K (with IIS) and it is =
installed properly I suppose, as when I call phpinfo (), through a =
script, it shows the PHP Information.=20
b.. then I installed MySQL 5.1.30, and through MySQL command prompt I =
am able to do things (creating tables, making queries etc).=20
c.. Now I want to use MySQL with PHP, but seems that MySQLI is not =
installed properly. as when I write a following script in a php page I =
get the error, that 'MySQLi' is not installed properly,.
$si =3D function_exists ( 'mysqli_connect' ) ;
if ( $si )
{
echo ' MySQLi appears to be installed correctly ' ;
}
else
{
echo 'MySQLi does not appears to be installed. ' =
;
}
?>

I understand that it is a configuration error somewhere, as I am new =
here in this world I am unable to figure out what ?

I am attaching the php.ini for the reference.

Praveen K.=20


=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =
=3D-=3D-=3D-=3D-=3D-=3D-=
Praveen Katiyar=20

Site : http://praveenkatiyar.co.cc=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =
=3D-=3D-=3D-=3D-=3D-=3D-=


------=_NextPart_002_00E2_01C9C824.93F71070
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Praveen's Mail
charset=3Dwindows-1252"> href=3D"file://C:\Program Files\Common Files\Microsoft =
Shared\Stationery\">



background=3Dcid:00df01c9c7f6$7a353780$0100007f@pc1001>

Hi =
List,

size=3D2> 
face=3D"Comic Sans MS" color=3D#0000ff>


I am new to PHP and as well as with MySQL, =

 


  • I have installed PHP 5.28, on win 2K  (with =
    IIS) and it=20
    is installed properly I suppose, as when I call phpinfo (), through a =
    script,=20
    it shows the PHP Information.
    =20
  • then I installed MySQL 5.1.30, and through MySQL =
    command=20
    prompt I am  able to do things (creating tables, making =
    queries=20
    etc).
    =20
  • Now I want to use MySQL with PHP, but seems that =
    MySQLI is=20
    not installed properly. as when I write a following script in a php =
    page I get=20
    the error, that 'MySQLi' =
    is not=20
    installed properly,
    .

        =
   =20
size=3D2><?php 
       &nbs=
p; =20
$si =3D function_exists ( 'mysqli_connect' )=20
;
          if ( =
$si=20
)
          {
&nb=
sp;           &nbs=
p;=20
echo ' MySQLi appears to be installed correctly '=20
;
          }
&nb=
sp;         else
 &n=
bsp;        {
  &nbs=
p;          =20
echo 'MySQLi <B> does not </B> appears to be installed. '=20
;
          }
&nb=
sp;     ?>

 

I understand that it is a configuration error =
somewhere, as I=20
am new here in this world I am unable to figure out what ?

 

I am attaching the php.ini for the =
reference.

 

Praveen K.


size=3D2>=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D -=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D
Praveen=20
Katiyar


Site : http://praveenkatiyar.co.cc=20

=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =
=3D-=3D-=3D-=3D-=3D-=3D-=3D


size=3D2>



------=_NextPart_002_00E2_01C9C824.93F71070--

------=_NextPart_001_00E1_01C9C824.93F71070
Content-Type: image/jpeg;
name="back.jpg"
Content-Transfer-Encoding: base64
Content-ID: <00df01c9c7f6$7a353780$0100007f@pc1001>

/9j/4AAQSkZJRgABAQEAZABkAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQE BQoHBwYIDAoMDAsK
CwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkF BQkUDQsNFBQUFBQU
FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/ wAARCACpAJ8DASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcY GRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKT lJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP0 9fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQA AQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2 Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOk paanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMB AAIRAxEAPwD9QI/n
3uj+X89Mk++jv+7+Sn/Psd3T5P8AYpk+x2fd/Gm/fUFiSfc/4HU/lsERN7yV n30Gyzn+/H8j1Nps
n+gWvyf8sasC8/8An56gjj+T5N8f3Pkqf5/4P79QSb87H/39m+oAj8lHgdNg /wBz+P8A2Kkj+46f
3/7lEkm+meX9xH/ef9dKADzNiO+zy0/jp+zZ86bP/iKgk3+cjo/yJ9+j549j /wDourAtf6z7n9yi
Tfs+4n9zZ/fpiTpJ/vps+SjZ+5k/5affSoAN/wDAn7z5/wDviiOR/k/26H++ /wAn+3+7f79Qfff5
fuf7/wBygCff5m9P9XRv+++9/k++lQfO7ujf8Dpk/wDqX2ffT/npVgWvv/Iz 7H3/AH6jk+RP3X7v
5/8Ax+l8/wC4/wA//AKe6eZ/00/j8uoAH37PuU13jjP7zCW3fP8Afp3/AAP/ AHKcxeSP9ywL9nH9
2rAijk2J8++o49nzomz5Hqrd3SWmxE/eT/3I0p9pBcy22+4/cXXz7/LoAW+2 SW0/z/wfJ5dJafPp
tq+zY6Qp8n3/AL9SX2/7NPs+/sel0/59NgT+N0+R9n+xQBcfZ86PQ/X5f/H6 ZBJ8nyv8n8Cfx0Sf
Jvf/AG6AIPMeTZMm+P8A6Z1SvpLmeZLOL+P79XZESdKhsY/Pv7qb5JH+5QBN HYvBsdLl5Nn3/Moe
D5E/+Lqff/rH+f7/APq6ZJvTZ8//ANnUAVZ38vZMjvH/AAVofO/yJ/38rPu4 99tP87/Om+prS6+1
7N/39m+gCR/9z/tnUEb/AMb/APfynv8Af+//AB1DqrvHZzvv/g2J5dWBRtUu dRm+0yzPaQb/AJK1
EtZo0+d/M2fPvkqtp6JaWg/dqiJ8/wDv/wCd9aHyJCn/AC0/+IoAg/8AInyV Hbfu5pof7nzp5n+f
79Ls3u7/AD+Xs2fu6gkd4NSg/wCWiTI//AKANST959//AMh1WudmJ92/dhKm 8xPnTf5fz1Xk+SaX
/eqAFtdKtrRNiJ5b/wDPSnvJ+9dyuUR/++Kn+dHffsqF/vp8/l0AUZ/+PCdH 3/6l/nf79WrHelhB
vfzE+SobuXyLO6d0+4jv+7/uVatUf7JA+znYlWAif6+dWRYPnR9/9+lkkf59 /wD45Uyo0bu6/vE2
f36hnk8vy/k8ygCORPM3/wDLNP49lQ6d8/2r+/8AaX2Vaf8AeJ9z79VdKT/j 6TZ9+Z/3lAGh5ifx
Tfx1DJv30+OTzE/2Hpknz/I6eYn3HoAjf7n/ALJUOl7LrTrY7/v/AHHqbZ8n zu9VdGHl2Ft8/wDf
T/x96AJ97/f3v877Kg1FE/s2RF/uf+z1aTfvf5PL2f3KpaxvfSn37JHTZseO gDU8v5P3X36HR/J2
fIj/AMH+3SSHeEJ3P8/ybH+/TH2R79j/AH33vvoAZJ/wD59n8H3Kq33797Lc nl75tn+f++KtPvdP
3X/fuRKpXz/8er/PJ++T/fegDRg/5afO8fz1Sv7O61GcLHc+RGhPzf3q059m zZv8uq87vArH5Pma
gCTrGm1/v/On/odQxyfufv8AmfweXJU+zejpsT/c/v1B5n8Dv/20qAIb793Y T73/AIHqS0T/AEK1
TZ/yx/j/ANyo76f/AEOf5/n2PVrTin2CD+5sRKsBxRHTZv2Pv/74pZ95+/D8 lP6vsdEf56gnjR2T
/lm//of+xQAyP/f8x0/8fqDTfkuLqGX/AJ7VJ/G6f7FJbxhb+Tb9ybY6f8Ao At7E2fx/P89QT797
/wC38n36teZs2bv3aVD8j70qAIJ38uF3+/8A+hp/n5KNN3/YIPkf7n+5UOq/ vLZE2fv3dKuJD5cM
Y+byURPuVYDJ38hN+z7n/LSodSjT7HOifwVanj3pvf8AdvUEcHyOj/x/7dAE 6f6vej/f+ekeTy97
7H2ffpljJ+5Tf9/5Eonk+RP33/bSgBn+s/gf5P8Axx6gu/nvLLf/AH9+9Knk kSTem9I/nqCH/StZ
P/TH+5/HQBqSf6nZ/fSqt2++CTY//ff/AACp9j7E/wCAfP8A36ZH5cxhd9kg 3/K//AKABkcP/tun
9/ZR/q/79P3/APTF5Pn/AO+Kq3aXL/Pb7PL/ANuoAju/ks597/Oif6yp7HfH YQf7iVVntL+S2eF/
s/zpsrRgR4LZI9/mOibP+B1YD0dN/wDzz/uUz/0D/npvok3/AOxJ8n9/ZvpH fA/4H/f+egCGdHR0
/wCWmz56PL+f77/3PMjqd0Tydn+sT7lVZ0ufvrsu9n/AHoAnd3Hzt/wOo5/k hebYnyf8Aqr5+pbP
+PP59n9+mf2Vc3c++6m+Tf8A6tP8/wC/QBHayPqV4ly/+oTZs+T+OteTojxP vf8Ag3/x02CBEhTy
k8v+P5P46e8fKHzX2H7iUAQSJvhf5P8A4ujzPn+R02J/45U6QJGnyfu//QKg +y+ZsdH8h0/v/PQB
GmF2A/vNrp8/+3UkieZ/f+5/v1DNJeQdLZJH+5/rtlQSG/kT/UpBvfZ870AS alfJaojunz/weXTt
HtZrCz2XDp57/wB9/vvRaaMlvM9zcP582/fvetKT5Pvp5lQAkfzw/f37/wCP fVaT95atvR0fC1N9
xN/9+kkZ4ZMsjvuqwBI96BGbzPk/j+ffSxjy94Z/n+/vo+dP4PM+f/vimI/C Pvf/AH5KAJv9X8iJ
5afx0zemx97ps/2Kg3/Imz+BP9XUjz/P/sf+yVAEz7P+ulMj2Oux/wC+/wA9 M8z77/6upv8AWbH+
T56AGSb38z5Pn2U//L1DAibPuf8Ajn36ekCSQun8GygAk+f76ff+R6J/3kL/ ANzfRHvd/wCCT5/n
2USfc3/PH/1zSgCPy3kd+39z/Y+5T8eZv+fYd+/Y9Q+em/50SOn2k6TzTw/x w/fqwJ449n3H+T7m
ymb0g2J/uJViok++nzvUAM3v/H+8qNNzS/LuQfOmyT+OpP8AWJ9x9n/PN6JH Te/z/PVgPkf99sqN
AIPkXd8770prz+Xvd98dJv5dP9Z9x0oAkkTy4dn+rT+/SSw7kZd7/K1SIv39 r/I/9ygqkT7KAI5M
KPvsQj/f/uVDO7uzpv8AMf8A39lTvInyOlVXjSfY+/5P9v8Aj30AF3OkCb3m 8uiC+hn+S3mTfVLy
/wC0dYSF3d0hTf8A8D/y9aEcabER0+4m9NlADINib3T93vp/n7H8mX95/con /cI/yVBfPsTer/PC
++g1L3ybN/8Ayz+/Rv8Ak3snz7//AB+j5N/3KSR/uf7+z/7CoMhdkPnf+P1H Pv8AnRd/+w9M34d3
3+Z/7PTJ5/I+f/WbN/8A3xVgTfaKpWP/AB+ag6bvuf3KtPJ/Gn7zZv8A++6g sf8AkLXrb/M/1P8A
H/v0AaMciUx9mz7jb/8A0Okjfy96/c+f/gFSSfwI37xN9AEMn7v5P4PuUf6x P+elRyR/O+9/k2fP
VLUpNlm+xH3u+zZUAT/2rbb9nnfOlPTydmz5JINibPn/AO+KmsbRLGLyUT/f f+/SokKfIv3KsCA3
DRxed2/j/wDZ6uQv5k0bff5f/gFVpH8vZ/t1WtZAljcxb/MeFth/8coAuyTp I/3/AJ//AECoI5E+
5/6B/wCgVNP9+F/+Wez/AL4pse/Z9/zP+B1AFTTo3+0XUzb/APXfwfPWiu/e +zZ/Hsqlo0nmJev/
AH5nqz5kO9H+f53+/VgMf95/00R/+WlMvoPtdhOn8bo+ynvGgd32fx7/APgd M+5/H/8AZ/7dBqR2
N1vitX/4B/n/AD/fq1NsdN3yHY787/uVV0eN/wCzbX/Y+R/9r56tzxpdIkL/ ALxN9BkZ39q/akRL
WFp3dP8AfSn2Nj5Mz3LzPJM+9Pk/gq9BBDAmyJPLT/nnHT7r5/L3On36AIPM Tztifff56q2myPUb
3+D+58n+xVqSPe/3/wDYqGxj/wCJldP5Kb32f+gUAXZEfzt6Ikn/ALI9Pf50 /wCB1DJGnyfO6Oj/
ACU+eP5/ufc+eoAY7/Pv/g/9AqjcFHvrJP8AptV5/v8A+w9VZ3/4mtj8j/ff /wBAqwLsex9mz92m
z/Vv/BRJ86Pvp6ff+58/8dM+eRE37N+/+CoAg/8AIfyfcqBGcXdyiP8AwJU8 fyPsf/P+3WeyfaNQ
mh39bVH/APH6sDQ8jfs/vonzx0P/AK7+P/rpvp/303/P8j/PUKSbP3O//gf9 +g1INK+R7r+/5zv/
ALlaAZ41+R9/3/8Avuq1oHSe6TZv+dHq1Js+f995f8dBkRyD76b02P8AwSfx 1Cn7tHdP3f8AHsp8
nzvs3/I/8FQ30mba6f56AH6H/wAgqD5/M/66VaREkR9/+f8AbqDSv+PODZ/c Sp0O9H27H3/wf36A
D76I+zy3/wDQKN/l/IlCfc+55affqD/ls/3Puf5eoAH/ANz50T5PnqDTZFk1 W/8An+5s2f7lT7Pv
un36gsX/AOJle/Px8mzZVgXtibPJdHof94j7N/8Ac+/T0/d7Nv8AubKZJH+5 /jjf/pnUAQwb0R9/
+/VSf/j/ALJ/9+p/M+5Mn7z/AKaf7FQXez7Ta/7E2z/gFWBoyffT+5/f2fce mPs2fc/j2PU0e903
vs37P4Khn+dNj/8AfdQBH5nl/wB+R0/8fqCMb9WkX+7B/wCz1P8Ax/c8z56o 6Yc3Vw/8CRonz1YG
r/Gnz/P/AAVVT958/wDq/wD2enps379j7H+f5KJ/kR0/1iP/AMs9lABH/wAf m/8A2Pnj/uVJ5++2
R/8AV70+/wD3KgTZOiOn3H+en/303vvoAZ/BvRE8vf8APVK+f7VNDZp+7nd9 7p/sVNfajDB/G8k7
/c8v79Glac//AB83e7z/ALn+5QBo7E/9A+5RG/z/ADfvP9uhJHjf508v/gdP k+R9+/8A2KAIfM+T
f8//AH3RPsR9m/y/+ulPeNJEdN7/ANz/AHKHk2J829P79QBBJv8A4Nm+oNO/ 5CV6hRPn2f6up/8A
WTf7af8AoFQ6d8+pXu/926On/oFWBoH+Dd/f+/R/q02I9Mk3on3/AJE/550/ e8j7HSgCrMgI2fcH
/oD0x/38O998f8f+5Vr/AFibP4/+mlQJsj3p/c/g/uJQBNvSRP7/APsf3Hpr yP8A3PM/4HUcf7z5
H+//AOP0yeeG0+eV/koAfPOkCSTb9myoNITZaI7/APLb56pIn9q3Pyo/2JH3 /wC/W3BLhNgXcn9+
gAjk/v8Ayf7f8D0f6t99VZv+Pa6/7bU+P/j8oAfPp0Mm98eX/wBc/wCOqX9l Qx73lvLiT/gdXX/4
+6tfwR0AUrLTba1RHSH5/wC/9+p2KeciMjxv9xJKjj/49I6n/wCW09ADF379 hdvufwVH5ibHT/Vv
seltPvv/AL9Sw/fH+7QaDXf503Tf7dR7A8flS7pB9z/bpLD7sf8A1yf/ANDp sf8Ax/wf9caDMZHo
1tv/ANT/AOP1Na2kNj/qk2b/AL776nj/ANTQn3KAD+++z5/kpiLtdE2P/uU/ /l6kqT/lrUAQQfc+
dPM/4HvpjwJdffTzKm/jqrF/y3qwIJNERx8tzcfwfx76WPQ7bf8APvn/AOu/ z1bm/wCPeT/dm/8A
Q6uS/wCqegCknyJ/6BSl0+Wq5+5B/wBdqq+LP+QRqf0i/wDQ6AP/2Q==

------=_NextPart_001_00E1_01C9C824.93F71070--


------=_NextPart_000_00E0_01C9C824.93F71070
Content-Type: text/plain; charset=us-ascii

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
------=_NextPart_000_00E0_01C9C824.93F71070--