CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 CodeCharge 4 database mySQL connection & PHP

Print topic Send  topic

Author Message
Freespirit

Posts: 4
Posted: 05/22/2008, 12:30 AM

Hi,
Fantastic program you have here.
I am trying codecharge 4 trial and I have a serious problem.
I want to make this working on my server :

http://examples.codecharge.com/Store/Default.php

The store example, but any time I am trying to connect to MySQL I got the same code in Common.php

  
//Connection Settings @0-91A0449C  
$CCConnectionSettings = array (  
    "database" => array(  
        "Type" => "<b>MSAccess</b>",  
        "DBLib" => "ODBC",  
        "Database" => "CCSInternet",  
        "Host" => "",  
        "Port" => "",  
        "User" => "",  
        "Password" => "",  
        "UseODBCCursor" => "",  
        "Persistent" => false,  
        "DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),  
        "BooleanFormat" => array("true", "false", ""),  
        "Uppercase" => false  
    )  
);  
//End Connection Settings  

Is it supposed for me to complete these fields with mySQL relative data?
I've downloaded the mySQL ODBC connector but still nothing for making the connection.
The program say in server mode that the connection is ok but everytime I publish the code I get this

  
Fatal error: Class 'clsDBInternetDB' not found in Header_events.php on line 18  

Also I cannot find a way to find the database.sql data that I need to paste in phpMyAdmin.Is this an automated process from the program to upload in the database all the needed tables and classes?

Please help me with these questions because I am planning to buy codeCharge if this will work.
Give me a small tutorial if you can of how to make a php&mysql application to REALY be functional!

Thank you in advance
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/22/2008, 3:57 AM

The examples come in various flavors both language and Database.
An example is loaded into the designer by choosing, New Project, Solutions Tab, choose the example. Next when the example is loaded, go to Project Setting to set (all) the parameters You need.
Change the projects target language to the one you want, and the example will be reopened.
In Connections, check the settings for the Design AND the Server. The latter is the one giving you problems now, set it correctly.
The Example SQL is in [CC4]/Examples/Internet, pick your flavour and load it through PhPMyAdmin, after creating a database to hold it all.
Remember the Database name, the acces and the name of your server and use that info in Connections.


I would Suggest reading the HelpFile, at least GettingStarted and Deploying PHP applications.

Walter


_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/22/2008, 3:58 AM

Almost forgot........
If you need to change anything in Common.php (or any other of the basefiles)
you are doing something wrong.


_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/22/2008, 3:58 AM

Almost forgot........
If you need to change anything in Common.php (or any other of the basefiles)
you are doing something wrong.


_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
Freespirit

Posts: 4
Posted: 05/22/2008, 5:52 AM

Quote wkempees:
The examples come in various flavors both language and Database.
An example is loaded into the designer by choosing, New Project, Solutions Tab, choose the example. Next when the example is loaded, go to Project Setting to set (all) the parameters You need.
Change the projects target language to the one you want, and the example will be reopened.
In Connections, check the settings for the Design AND the Server. The latter is the one giving you problems now, set it correctly.
The Example SQL is in [CC4]/Examples/Internet, pick your flavour and load it through PhPMyAdmin, after creating a database to hold it all.
Remember the Database name, the acces and the name of your server and use that info in Connections.


I would Suggest reading the HelpFile, at least GettingStarted and Deploying PHP applications.

Walter


What do you mean the

The latter is the one giving you problems now, set it correctly.

I am doing all the connections with my database and login and password and host and I get the same in Common.php, all the time MSAccess.Is there an button to rebuild or to regenerate the files based with the new settings?

Thank you in advance
View profile  Send private message
wkempees


Posts: 1679
Posted: 05/22/2008, 7:52 AM

Project Settings->Connections
consists of three tabs, Design / Advanced / Server
Design is the Msaccess one,
Advanced,
Server, should be reflecting you target database.
Type MySQL
Database: Intranet (or whatever you called it)
Server/Host: Localhost (if you have a test environment on you local machine) or Ip or servername
rest is self explanatory.

[F9] is the regenerate/publish button
I strongly advice you to read the helpfile (from the Index)





_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.