[PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-20 Thread balwantsingh
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP Da

Re: [PHP-DB] SQLite security

2004-08-20 Thread Adam Q
You can use Mcrypt, OpenSSL or any other crypographic provider to encrypt the information however for your application to be able to access the information you would also have to store the encryption key, reducing the protection offered. Any PHP MySQL connection script has the DB password in it s

[PHP-DB] retrieved data from mysql to be shown in spreadsheet

2004-08-20 Thread balwantsingh
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP Da

RE: [PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ford, Mike [LSS]
> -Original Message- > From: Ron Piggott > Sent: 21/08/04 01:53 [] > One of the problems I am now having is if the user types an ' into their > entry --- these ones do not get saved into the mySQL database. [] > I can look at this and understand that if an ' is keyed why it woul

RE: [PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
> -Original Message- > From: Ford, Mike [LSS] > Sent: 21/08/04 01:57 > foreach ($_POST['checkbox'] as $key=>$irrelevant): > // checkbox[$key] was checked > endif; OK, it's 2a.m. here and I'm about asleep, whioch is why that last line didn't read endforeach; !!!

RE: [PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
> -Original Message- > From: Jasper Howard > Sent: 21/08/04 00:49 > > just set the checked value of the check boxes to something like, > "true", and when you are going through the check boxes in the second > script do something like this: Urrr -- you script will only ever see checkboxes w

[PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ron Piggott
I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now having is if the user types an ' into their entry --- these ones do not get saved into the mySQL database. The l

[PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Jasper Howard
just set the checked value of the check boxes to something like, "true", and when you are going through the check boxes in the second script do something like this: $boxes = array(); $num = 0; foreach ($_POST['checkboxe'] as $box) { if ($box == 'true') { $boxes[$num] = 'checked'; } else { $b

[PHP-DB] Checkboxes in a table

2004-08-20 Thread 'Miguel Guirao'
Hi!! I'm dinamically building a table, within a while cycle a build each row with it's columns. One of these columns contains a checkbox, so I have as many checkboxes as many rows. So, after hitting Submit I wanna know which checkboxes has been selected, I'm naming each of them like this: chec

Re: [PHP-DB] Re: Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Miles Thompson
This ain't exactly db related, but if you do a "View Source" on your page what do you see for the button's submit? If it's PHP script then you have a configuration problem. You should not see PHP in the browser. Set up a file called phpinfo.php which contains one line: and call it from your b

Re: [PHP-DB] Re: Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Jasper Howard
ScriptAlias /php4/ "c:/php4/" AddType application/x-httpd-php .php Action application/x-httpd-php "/php4/php.exe" does it look something like this? <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks Peter and Jasper. I changed the httpd.conf to make sure they point to the prope

[PHP-DB] Re: Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Bestman4unowwa
Thanks Peter and Jasper. I changed the httpd.conf to make sure they point to the proper Load module and add type and PHPInidir but still no luck. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Jasper Howard
yeah, sounds like you aren't setting anything in the apache config to pharse the php script with the php engine. <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > When I have a html page with an embedded php method behind a button, when I click the button I can't run the PHP, instead my

Re: [PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Peter Ellis
This isn't really a database question, so I'm not sure why it went to a database-related list. Have you checked your Apache configuration to make sure it's set to handle the PHP extensions? Check the PHP manual on how to set this (I believe relevant instructions are under Installation). -- Peter

[PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Bestman4unowwa
When I have a html page with an embedded php method behind a button, when I click the button I can't run the PHP, instead my browser pops up a dialog box with a request a file download of my PHP script. Also, when I run a php in my browser either nothing happens or I get the file load. -- PHP

Re: [PHP-DB] IBM DB2

2004-08-20 Thread Gerard Samuel
Robert Twitty wrote: On Thu, 19 Aug 2004, Gerard Samuel wrote: Robert Twitty wrote: Hi Is anyone using PHP to connect to an IBM DB2 database? The reason why I am asking is becaouse I want to see if the odbtp extension can be used to successfully prepare and execute DB2 stored procedures. So far,

Re: [PHP-DB] IBM DB2

2004-08-20 Thread Robert Twitty
On Thu, 19 Aug 2004, Gerard Samuel wrote: > Robert Twitty wrote: > > Hi > > > > Is anyone using PHP to connect to an IBM DB2 database? The reason why I > > am asking is becaouse I want to see if the odbtp extension can be used to > > successfully prepare and execute DB2 stored procedures. So far