tatong
|
| Posted: 08/28/2002, 4:45 PM |
|
Guys do I need myodbc in Winxp Apache Mysql Php setup?
Im moving an application from IIS to apache, but its not working in apache.
Im not getting error but I cant login.
|
|
|
 |
mrvanjohnson
|
| Posted: 08/28/2002, 6:23 PM |
|
From you statement "Winxp Apache Mysql Php setup" I am assuming you are referring to the set up of the server you are trying to run on and that you are trying to run a PHP application talking to a MySQL database on a Windose box. OK not a problem. Do you have the ability to create a quick page that would make a call to the database to see if you are able to pull out data without needing to LogIn? Are you sure you created the correct username and passwords within MySQL for the application. They need to match what you have configured in Code Charge or things won't work. Are you using Code Charge or Code Charge Studio? In either case, can you connect to your database through either CC or CCS to create new pages. You can also load up a little PHPMyAdmin into your site and see if you can connect to MySQL that way. If you installed PHPTriad or FoxServ then PHPMyAdmin installs by default I believe, check you document root folder for a fodler named PHPMyAdmin.
To answer you question, you do need a MySQL ODBC driver to develop from a Windows box to a MySQL server but I don't believe you need anything special to serve the page up, that what the MySQL Server does.
Hope this helps.
|
|
|
|
tatong
|
| Posted: 08/29/2002, 12:59 AM |
|
Yes i'm running a PHP application with Apache 2.02 and PHP4.3(isapi version) with WINXP and MySql.
I check the Login and Password on the database and what I've inputed is right. The session path is existing, theres no Error that appears. But all that happens is I go back to the login page when i login.
I'm trying CCS1.07 employee directory sample in Apache. It worked fine when im testing it in IIS5 . So my quess is that my php and mysql has something not right going on between them. Cant figure it out though.
So I though maybe the MYODBC is the culprit.
|
|
|
|
Tatong Steele
|
| Posted: 08/29/2002, 1:15 AM |
|
I tested this code in my WAMP setup and it worked!!! So my guess is mysql is fine. So it must be the codes that CCS generates that is compatible with PHP4.3????
----------------
<h3>Press RELOAD to add a record to the MySQL database:</h3>
<?
//establish user connection
mysql_connect("localhost");
//open up database
mysql_create_db("testdatabase");
mysql_select_db("testdatabase");
//create table
mysql_query("CREATE TABLE newone(firstName VARCHAR(25),
lastName VARCHAR(25))");
mysql_query ("INSERT INTO newone (firstName, lastName) VALUES
('John', 'Tester')");
//display the information
$result = mysql_query ("SELECT * FROM newone");
while($row = mysql_fetch_array($result))
{
print ("Added record: " . $row["firstName"]."
".$row["lastName"]."<br>\n");
}
//close user connection
mysql_close();
?>
----------------
Apache2.0.2 works with the common Php pages which does not require login.
But once the phpcode from CCS1.07 is executed to login in the sample EmplDirectory, I just go back to the Login Page. No error or anything but an empty username box and password box.
CodeCharge people can anyone explains whats happening here??
I'm Stuck!!
|
|
|
|
|
