These are the tools i used for setup on my local machine;
Apache_1.3.35-win32-x86-no_src.msi
Mysql-5.0.37-win32
PHP-5.2.1-Win32
Phpmyadmin-2.10.0.2-all-languages
MySQL Connector/ODBC 3.51
(THESE ARE THE CHANGES THAT I'VE MADE TO httpd.conf file
ServerRoot "C:/Program Files/Apache Group/Apache"
LoadModule php5_module "C:/php/php5apache.dll" (I added this
line under Dynamic Shared Object (DSO) Support w-out the # sign)
"Where it says: # [WHENEVER YOU CHANGE THE LOADMODULE SECTION
ABOVE, UPDATE THIS TOO!]
i added (AddModule mod_php5.c) w-out the # sign
Port 80
ServerAdmin XXXXX@lycos.com
ServerName localhost
DocumentRoot "C:/Program Files/Apache Group/Apache/htdocs"
<Directory "C:/Program Files/Apache
Group/Apache/htdocs">
DirectoryIndex index.html index.php
AddType application/x-httpd-php .php
THESE ARE THE STEPS I USED TO INSTALL AND CONFIGURE PHP
first i extracted the files to a "php" folder on my C: drive
Using the php.ini-dist file, I configured some of the
settings as so;
error_reporting = E_ALL
display_errors = On
log_errors = Off
doc_root = "C:\Program Files\Apache Group\Apache"
extension_dir = "C:\php\ext\"
"C:\php\temp\uploads" (I created the temp\uploads folders)
extension=php_gd2.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_pdo.dll
extension=php_pdo_mysql.dll
SMTP = localhost
sendmail_from = XXXXXXX@lycos.com
session.save_path = C:\php\temp\sessions
"NOTE" AFTER CONFIGURING THE FILE, I SAVED IT AS "php.ini and
left it where it was.
THESE ARE THE STEPS I USED TO INSTALL AND CONFIGURE MYSQL
Here i used the wizard and used the following settings;
selected the detailed configuration option
under server type, i chose Developer machine
Non-transactional database only
Decision suppot (DSS) /OLAP
Enable TCP/IP Networking Port 3306
Selected Enable strict mode
Selected The Standard Character set
Selected Install as windows service
Selected include bin directory in windows path
Set a new root password
Then I clicked execute to finish the installation
THESE ARE THE CONFIGURED SETTINGS I USED TO INSTALL
PHPMYADMIN
oh, better yet, here's my config.inc
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.10.0.2 setup script by Michal
ÄŒihaÅ™ <michal@cihar.com>
* Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $
* Date: Sat, 10 Mar 2007 07:36:48 GMT
*/
/* Servers configuration */
$i = 0;
/* Server MyXXXXX (http) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['verbose'] = 'MyXXXXX';
/* End of servers configuration */
$cfg['TextareaCols'] = 40;
$cfg['TextareaRows'] = 7;
$cfg['LongtextDoubleTextarea'] = true;
$cfg['TextareaAutoSelect'] = true;
$cfg['CharEditing'] = 'input';
$cfg['CharTextareaCols'] = 40;
$cfg['CharTextareaRows'] = 2;
$cfg['CtrlArrowsMoving'] = true;
$cfg['DefaultPropDisplay'] = 'horizontal';
$cfg['InsertRows'] = 10;
?> (IMO, THIS IS MOST LIKELY WHERE MY CONFIGURATIONS
AREN'T RIGHT).
THESE ARE THE STEPS I USED TO SET UP A DREAMWEAVER SITE (8.0)
Local root folder C:\Documents and
Settings\Owner\Desktop\XXXXX\
Links relative to: Document
HTTP address:
http://localhost:80/XXXXX/
Remote info: Local/Network
Remote folder: C:\Documents and Settings\Owner\Desktop\XXXXX\
Testing Server: PHP MYSQL
ACCESS: Local/Network
Testing Server folder: C:\Program Files\Apache
Group\Apache\htdocs\XXXXX\
URL PREFIX:
http://localhost/xxxxxx/
Homepage: C:\Documents and
Settings\Owner\Desktop\XXXXX\index.php
In Mysql, i created a database, inserted a record, then,
Next i installed MySQL Connector/ODBC 3.51 and connected to
the database.
Going back to Dreamweaver, I created a Mysql connection,
selected the new database i created and connected it to
Dreamweaver. Then i went to file-new, and chose a dynamic php page.
I then saved the page. I then opened the bindings panel and chose
"recordset query". I named it, selected my connection, then i chose
all the records, Clicked on test to see it, then i clicked ok. I
can now see my recordset in the bindings panel. I dragged them into
the page, added a css stylesheet, and saved the page clicking
preview and at first I saw "NOTHING" This is what the page looks
like in code view;
<?php require_once('Connections/conndba.php'); ?>
<?php
mysql_select_db($database_conndba, $conndba);
$query_Recordset1 = "SELECT * FROM tbl_players";
$Recordset1 = mysql_query($query_Recordset1, $conndba) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<p><?php echo $row_Recordset1['Player_ID']; ?>
<?php echo $row_Recordset1['First']; ?> <?php echo
$row_Recordset1['Last']; ?> <?php echo
$row_Recordset1['Age']; ?> <?php echo $row_Recordset1['Ht'];
?> <?php echo $row_Recordset1['BP']; ?></p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
THIS IS WHAT SHOWED UP IN THE BROWSER;
Warning: require_once(Connections/conndba.php)
[function.require-once]: failed to open stream: No such file or
directory in C:\Program Files\Apache
Group\Apache\htdocs\XXXXXX\index.php on line 1
Fatal error: require_once() [function.require]: Failed
opening required 'Connections/conndba.php'
(include_path='.;C:\php5\pear') in C:\Program Files\Apache
Group\Apache\htdocs\XXXXXXX\index.php on line 1
But if i click on live data view i can see my recordset the
way it needs to appear on the web?
Plz help
3
Replies
AdChoices