=i hope this is in the right forum, i saw nothing for mysql or easyPHP
so hopefully this belongs in the general forum =
hi,
a little back ground:
I have been developing and coding pages sence before there was a www. I
recall such debates like 300 baud was fine and did we need to pay $12.50
a hour to access it at 1200 baud - which was too fast to read anyway.
for the last several years i have been using visual studio and the .net
frame work to develope my web sites. It's fast easy and while not cheap
it is also very simple to code exciting sites.
Well a month or so ago i was given the task to develope a new website.
We contracted with a host that promised us .net would be available on
the hosting site. Well i should have known better asp.net 2.0 on a
unix/linux system was probably unlikely.. frankly the hosting company
lied. (but that is for another forum). Based on the promises we purcased
a full year of services including our .com registration.
to make a long story short, i had to relearn how to code using notepad and learn
how to use php and something called mysql. I am use to the context
sensative nature of visual studio so learning to code again by hand
was a pain, but i am actually enjoying it. There is some what more
a sense of accomplishment doing it your self instead of just painting
a webpage with (essencially) predefined stuff.
I have however come upon a snag, and probably the baine of gpl software
no one to turn to for help. Using a package called easyPhP (version 1.8)
to test and to ultimately deploy (or we hop to) the inhouse version
of the website i have encountered a problem. I do not seem to be able
to get mysql to intilize. given this mysql configuration file...
Code:
#------------------------ IMPORTANT ! ----------------------
# This file is GENERATED by EasyPHP when needed so edit the
# file F:\EASYPH~1\conf_files\my.ini if you want to do
# modifications in this file
#-----------------------------------------------------------
; IMPORTANT
; F:/EASYPH~1 is used to specify EasyPHP installation path
[mysqld]
;datadir=F:/EASYPH~1/mysql/data
;basedir=F:/EASYPH~1/mysql
;bind-address=127.0.0.1
; Uncomment for use on USB key
; skip-innodb
datadir=F:/silvanet/mysql/data
basedir=${path)/mysql
bind-address=127.0.0.1
;bind-address=192.168.2.105
the following code segment:
Code:
<?php
/* Program: mysql_up.php
* Desc: Connects to MySQL Server and
* outputs settings.
*/
echo "<html>
<head><title>Test MySQL</title></head>
<body>";
$host="localhost";
$user="";
$password="";
$cxn = mysqli_connect($host,$user,$password);
$sql="SHOW STATUS";
$result = mysqli_query($cxn,$sql);
if($result == false)
{
echo "<h4>Error: ".mysqli_error($cxn)."</h4>";
}
else
{
/* Table that displays the results */
echo "<table border='1'>
<tr><th>Variable_name</th>
<th>Value</th></tr>";
for($i = 0; $i < mysqli_num_rows($result); $i++)
{
echo "<tr>";
$row_array = mysqli_fetch_row($result);
for($j = 0;$j < mysqli_num_fields($result);$j++)
{
echo "<td>".$row_array[$j]."</td>\n";
}
}
echo "</table>";
}
?>
</body></html>
returns
Code:
Fatal error: Call to undefined function: mysqli_connect() in f:\silvanet\public_html\mysql_up.php on line 13
comments,\
i hope the ';' were used to start comments
I commented out some of the orgional lines
and substuted what i hope are appropriate adjustments i want to
put the .sql data bases in f:\silvanet\mysql\data
and the easyPHP package was installed in f:\easyPHP etc...
questions? can mysql be 'bound' to more then one address? the second one
is the local intranet's machine address. i'd like to beable to access the database accross the intranet (so ultimately others can use the site) as well as on the machine itself (for testing).
help....
