Re: [PHP-DB] value error in PHP form

2004-06-25 Thread Rinku
Thanks Zak, Its really amazing. It worked Properly. Thanks once again. Rinku Zachary Krakov [EMAIL PROTECTED] wrote: Hi Rinku, The statement syntax that I believe will work you is the following: If (($VARIABLE1 !== '') ($VARIABLE2 !== '')) { print Rinku; } Let me know if this

Re: [PHP-DB] SSL with MySQL 4.0

2004-06-25 Thread Rinku
I dont know much abt SSL . But pls check the URL, I hope it wd be useful to you. http://support.microsoft.com/?kbid=314864 Edgar Hassler [EMAIL PROTECTED] wrote: Does PHP support SSL connections to MySQL? If no, does anyone have an idea how to make an SSL conncetion to MySQL using PHP? Thanks,

[PHP-DB] Date Select

2004-06-25 Thread Tom Chubb
How can I query a MySQL table to get the latest results from a date field? Basically, I am inserting several records at a time at the end of each week. I want to have a page that displays the results for the last week only. The date format in the field is -MM-DD

RE: [PHP-DB] [PHP]: session problem

2004-06-25 Thread Ford, Mike [LSS]
On 24 June 2004 16:44, H. J. Wils wrote: this is the code, but this code works on my hosting provider but not on my own server. I think i have to change settings in php.ini but dont know which... first page: session_start(); include connect.php; include functions.php;

Re: [PHP-DB] Date Select

2004-06-25 Thread jeffrey_n_Dyke
How can I query a MySQL table to get the latest results from a date field? Basically, I am inserting several records at a time at the end of each week. I want to have a page that displays the results for the last week only. The date format in the field is -MM-DD if you want the latest row

[PHP-DB] Re: Date Select

2004-06-25 Thread Torsten Roehr
Tom Chubb [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How can I query a MySQL table to get the latest results from a date field? Basically, I am inserting several records at a time at the end of each week. I want to have a page that displays the results for the last week only.

RE: [PHP-DB] Date Select

2004-06-25 Thread Tom Chubb
Jeffrey, Thanks for this, I've just realised that it's always the same no of inserts, so perhaps I should just order by date then my previous sort field and then limit the result to 20? (It's all 20 results that I need displayed) Thanks, Tom -Original Message- From: [EMAIL PROTECTED]

[PHP-DB] Re: Date Select

2004-06-25 Thread pete M
select * from table where week(date_field) = ( week(now()) -1 ) Tom Chubb wrote: How can I query a MySQL table to get the latest results from a date field? Basically, I am inserting several records at a time at the end of each week. I want to have a page that displays the results for the last week

[PHP-DB] SQL injection prepared statements

2004-06-25 Thread Gerard Samuel
Just looking for opinions on sql injection while using prepared statements. I've read at the oci8 extention that content should not be escaped --- Do not use magic_quotes_gpc or addslashes() and oci_bind_by_name() simultaneously as no quoting is needed and any magically applied quotes will be

Re: [PHP-DB] Date help needed

2004-06-25 Thread Neil Smith [MVP, Digital media]
No, it's actually very easy to do the autocomplete once you get the hang of it. Actually the way I've done it is to populate a multi-select box but you could also use a DIV and write out the values Dump the email addresses as an XML file (generate this dynamically) then use XSLT to read out

[PHP-DB] Re: Date help needed

2004-06-25 Thread Rui Cunha
Hope this helps: ?php $days_2_search = array ( 1 = Fri , 2=Sun , 3=Tue); $num_days = 365; $day = (int) date(d); $month = (int) date(n); $year = (int) date(Y); echo form action=\test.php\ method =\post\ select name=\days\; for ($i = 1 ; $i = $num_days; $i++) { $loop_day =

[PHP-DB] Re: SQL injection prepared statements

2004-06-25 Thread Hans_L
Gerard Samuel wrote: snip So Im guessing that this is how prepared statements are done on other databases. After being trained to do it one way (always escaping bad content), Im being shown to do it the other way, and Im looking for any suggestions you may have. Yes, the idea with prepared

[PHP-DB] Re: Date Select

2004-06-25 Thread Gerben
select * from table where TO_DAYS(date_field) ( TO_DAYS(NOW()) -7 ) this will give the entries of the last 7 days (and the ones that are in the future) Tom Chubb [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How can I query a MySQL table to get the latest results from a date field?

Re: [PHP-DB] Re: SQL injection prepared statements

2004-06-25 Thread Gerard Samuel
On Friday 25 June 2004 01:03 pm, Hans_L wrote: Gerard Samuel wrote: snip So Im guessing that this is how prepared statements are done on other databases. After being trained to do it one way (always escaping bad content), Im being shown to do it the other way, and Im looking for any

[PHP-DB] Re: Php form row delete problems

2004-06-25 Thread Torsten Roehr
Vincent Jordan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a table that display's a list of users in a mysql db. In the table I have a echo input type=checkbox name{$row[$user_id]} {$row[$username]}, {$row[$password}, {$row[$isactive]}; ( this is not the exact code but

[PHP-DB] PHP with Javascript tutorials?

2004-06-25 Thread Chris Payne
Hi there everyone, I've been looking on Google for PHP Javascript tutorials but I can't find any. I'm new to Javascript but can use PHP for what I need. I was hoping someone would know of a tutorial that would show how to use PHP to get 2-3 datasets which javascript can then use in forms.

Re: [PHP-DB] PHP with Javascript tutorials?

2004-06-25 Thread jeffrey_n_Dyke
Hi there everyone, Hello. I've been looking on Google for PHP Javascript tutorials but I can't find any. I'm new to Javascript but can use PHP for what I need. I was hoping someone would know of a tutorial that would show how to use PHP to get 2-3 datasets which javascript can then use

Re: [PHP-DB] Read a PDF file via PHP

2004-06-25 Thread Jeffrey Moss
Steve, You must turn the file to postscript before you can read anything out of it, and even then, a lot of the time words are broken up into different show statements. use pdf2ps (part of GNU GhostScript) to convert to PS and then search for patterns like this: (text) show that is the most

Re: [PHP-DB] Read a PDF file via PHP

2004-06-25 Thread Stut
On Fri, 25 Jun 2004 19:36:11 +, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Is there any way to get PHP to simply read the PDF file for text only--just the surface of it, just the words, as if it were a human reading the PDF itself--and not for the internal code of the file? I do this

Re: [PHP-DB] return array

2004-06-25 Thread Sam Chill
Instead of return $field[]; try return $field; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] return array

2004-06-25 Thread Sukanto Kho
Yeah I have try that... and when I : echo $field[1] appear error msg : Undefined offset: 1 - Original Message - From: Sam Chill [EMAIL PROTECTED] To: PHP DB Help [EMAIL PROTECTED] Sent: Saturday, June 26, 2004 11:21 AM Subject: Re: [PHP-DB] return array Instead of return