james london
|
| Posted: 03/18/2004, 9:57 AM |
|
hi... i am a really new learner on this CCS 2.2.
i ve just looked at user manuals and tutorials then try to build a simple record form.
i followed all the steps on the record builder help guild here.
http://docs.codecharge.com/studio/html/
i created a customer form to enter his/her details into my table in MYSQL.(i m using apache+php+mysql on window xp)
but when i click the add button to insert data, the form does not change anything. sometime it displays my '{Action}' , under the form, does not found message.
sometimes it gives 500 internal server error.
so i changed the '{Action}' part under the form , you can see these code in 'HTML View' next to 'Design View', to file name(html or php) so that it can be linked to another page. then this time when i click the button it displays another linked page but the data are not stored in the table.
my main question is that how i can send the data from the form.
i changed connection and data sourse in the form property.
i am trying figure it out very hard.... but still couldnt get the solution yet.
could someone give me advice?
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 03/18/2004, 12:17 PM |
|
Hi,
One possible issue here may be that your server is configured to serve .html pages first, then .php.
Please try to open the page with the extension .php. For example if your browser shows www.something.com/page.html , please change it to www.something.com/page.php . Or if you do not see the page, just www.something.com , then append the page name manually: www.something.com/pagename.php
Also, is your page accessible somewhere on the Web?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
james london
|
| Posted: 03/19/2004, 4:12 AM |
|
hi..
i am currently working on my localhost. so it is not accessible on the web. but i think it is not a problem because i can run other php scripts which i created myself.
i created files using 'PHP4.0 with templets' and it creates three different files with same name. (html, php and ccs) and i can see all of those codes on my browser. however my php scripts, customer entry form, seem does not work. (do i need to type manually SQL insert command somewhere?)
where can i find the errors?
thanks for your reply,
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/19/2004, 11:05 AM |
|
OK. But what about my suggestions above?
I would need to know if your PHP scripts are executed or HTML.
The only way to check it is if you tell us what happens when you access your PHP program. Locally it could be http://localhost/folder/page.php
Or what is the URL that you are executing and doesn't work?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
james london
|
| Posted: 03/23/2004, 6:31 AM |
|
hi.
this is the same way i typed when i see the php file.
"http://localhost/folder/page.php"
i think now my php file works fine.
i will rephrase my question.
try to build simple category record form. (mysql+php)
table name: category ( cat_no, cat_name, description)
and i created the form using a record builder.
these are my category data property
Name: category
Connection: my_connection
Data Source Type: Table
Data Sourse: category ( where: cat_id = {cat_id} ) and on the "Table Parameter" i selected "Parameter" condition type,
"parameter source type" to URL which is default value.
Returen Page: category.ccp
Remove Parameter: blank
Convert URL to: None
Restricted: No
Allow Insert: yes
Allow Update: yes
Allow delete: yes
Preserve Parameters: Get
Custome Insert Type: table
Custome Insert: category ( parameters: field => cat_name (type - text), parameter source => cat_name(type - expression)
here i tried all different types of 'parameter source' and only expression type had worked. but on category table i can see 'cat_name' and 'description' which are column names as data not the data what i inserted. in other words, if i enter data ,for instance, digital camera (cat_name) and camera with a memory card(description) i see cat_name and description not 'digital camera' and 'cameral with a memory card' on thecategory table.
what have i done wrong? do i need to change others?
thanks for the help.
james ^^
|
|
|
|
|
