[PHP-DB] Re: [PHP] PHP Database Problems -- Code Snippets

2012-05-02 Thread Duken Marga
It is a good habbit to write the core code just for inserting/retrieving data from database. It will reduce much of your code complexity. When you see your code is working, you can continue to embed it with your visual front-end or with your filter. On Thu, May 3, 2012 at 4:43 AM, Ethan Rosenberg

Re: [PHP-DB] School timetable in php

2012-04-22 Thread tamouse mailing lists
On Fri, Apr 20, 2012 at 7:00 AM, Vinay Kannan viny...@gmail.com wrote: I am trying to develop a school time table system in php mysql, anybody has any headsup on the same, i was thinking about some existing scripts to take a look at. Not entirely clear what is meant by time table -- do you

[PHP-DB] School timetable in php

2012-04-20 Thread Vinay Kannan
hey, I am trying to develop a school time table system in php mysql, anybody has any headsup on the same, i was thinking about some existing scripts to take a look at. Thanks, Vinay

Re: [PHP-DB] School timetable in php

2012-04-20 Thread Karl DeSaulniers
No example to give, but I would search the term below in your search engine of choice. I think you'll find something useful at least to start with. If not a working example. php mysql time table example or php mysql timesheet example (I'm thinking you can go from here and customize if no

[PHP-DB] Invitation from Multiply

2012-04-18 Thread MA PROPOSISION ELMAZI (via Multiply)
Check out my Multiply site I set up a Multiply site with my pictures, videos and blog and I want to add you as my friend so you can see it. First, you need to join Multiply! Once you join, you can also create your own site and share anything you want, with anyone you want. Here's the link:

Re: [PHP-DB] Invitation from Multiply

2012-04-18 Thread tamouse mailing lists
2012/4/18 MA PROPOSISION ELMAZI (via Multiply) multi...@multiply.com: Check out my Multiply site oh i can hardly wait to see this... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Engine?

2012-04-16 Thread Karl DeSaulniers
On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etcbut haven't actually been able to decide. I wanted to know whats the storage engine used on

Re: [PHP-DB] Engine?

2012-04-16 Thread Bastien
Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles

Re: [PHP-DB] Engine?

2012-04-16 Thread Matijn Woudt
On Mon, Apr 16, 2012 at 1:09 PM, Bastien phps...@gmail.com wrote: Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've

Re: [PHP-DB] Engine?

2012-04-16 Thread Vinay Kannan
Awesome Thank You Guys! A better scalable DB was on my mind, looks like I might have to go for much before I thought I might have to go ahead with :) Going through the resources provided, Thank You for the headsup!! Vinay Kannan. On Mon, Apr 16, 2012 at 4:44 PM, Matijn Woudt tijn...@gmail.com

[PHP-DB] Engine?

2012-04-15 Thread Vinay Kannan
Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etcbut haven't actually been able to decide. I wanted to know whats the storage engine used on MySQL on big web application, the application i am

[PHP-DB] Need help with SQL Query

2012-04-13 Thread Rikin Parekh
Suppose I have a *BOOKS* table like the one given below: ISBN | Book Title | Author Name 1 Jungle bookSam 2 Princess Diary Joe 3 Titanic Sam 4 House Joe 5 Scary Movie Rick

[PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
why don't you try it and see? (altho I suspect that using 'count' as the result field name might not work, and that having column names with spaces in them will require quotes around them.) Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax errors in question table. Can someone please guide or help? Thanks, Rikin On Apr 13, 2012, at 9:12,

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh riki...@gmail.com wrote in message news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin On Fri, Apr 13, 2012 at 10:28 AM, Jim Giner jim.gi...@albanyhandball.comwrote: Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh rpare...@umd.edu wrote in message news:CALbBjtctPawe=qyuvqWZvG3nq_Tw7PwKoe-hhi5fkYGec=6...@mail.gmail.com... I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin No thanks necessary.

[PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread Ken Keefe
I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling with this for some time now. I have created a short example test script that demonstrates the problem. The script can be found here:

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe kjke...@illinois.edu wrote: I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling with this for some time now. I have created a short example test script that demonstrates

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 2:02 PM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe kjke...@illinois.edu wrote: I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling with

[PHP-DB] foreach

2012-04-05 Thread Ethan Rosenberg
Dear Lists - I know I am missing something fundamental - but I have no idea where to start to look. Here are code snippets: I have truncated the allowed_fields to make it easier to debug. $allowed_fields = array( 'Site' ='POST[Site]', 'MedRec' = '$_POST[MedRec]', 'Fname' =

[PHP-DB] Re: foreach

2012-04-05 Thread Jim Giner
I don't know about others, but I can't make sense of this - way too much presented with no idea of what I am looking at - code or output. One thing: $_Request is not the same var as $_REQUEST. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Re: foreach

2012-04-05 Thread Karl DeSaulniers
And POST[] is not the same as $_POST[] Karl Sent from losPhone On Apr 5, 2012, at 3:24 PM, Jim Giner jim.gi...@albanyhandball.com wrote: I don't know about others, but I can't make sense of this - way too much presented with no idea of what I am looking at - code or output. One thing:

[PHP-DB] Re: foreach

2012-04-05 Thread Al
On 4/5/2012 4:15 PM, Ethan Rosenberg wrote: Dear Lists - I know I am missing something fundamental - but I have no idea where to start to look. Here are code snippets: I have truncated the allowed_fields to make it easier to debug. $allowed_fields = array( 'Site' ='POST[Site]', 'MedRec' =

Re: [PHP-DB] Re: foreach

2012-04-05 Thread Kris Carlson
Send the code around line 198, say 170 to 210. On Apr 5, 2012, at 8:42 PM, Al wrote: On 4/5/2012 4:15 PM, Ethan Rosenberg wrote: Dear Lists - I know I am missing something fundamental - but I have no idea where to start to look. Here are code snippets: I have truncated the

Re: [PHP-DB] search of data base - again

2012-03-31 Thread Gonzalo
Why don´t you echo the $sql2 to see the query. That´s would be very helpful. Also, are you closing the ')' in the 'values'? Greetings On Fri, Mar 30, 2012 at 3:55 PM, Gavin gavin.chalk...@gmail.com wrote: |DATE|

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I agree with Martin's assessment. Took me awhile to always remember to have the date in the correct format. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
At 07:15 PM 3/29/2012, Matijn Woudt wrote: On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote: Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I think MySQL wants the date in -M-D format, did you try changing $Date = date('M d Y'); to $Date = date('Y-m-d'); - Matijn Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
See below- - Original Message - From: Ethan Rosenberg eth...@earthlink.net Newsgroups: php.db To: Matijn Woudt tijn...@gmail.com Cc: php-db-lists.php.net php-db@lists.php.net; jim.gi...@albanyhandball.com Sent: Friday, March 30, 2012 1:00 PM Subject: Re: [PHP-DB] search of data base

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
=== Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's what I am doing. No luck. Ethan * You're using a format with just Ymd in it (no dashes)? Can you post

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat.  But mySql

[PHP-DB] Session and Access Privilages.

2012-03-29 Thread Vinay Kannan
Hey, I am working on the application, thought its not OOP currently, I plan to take it further in a year or so. Right now, I have 4 access levels which define what the users can do on the application. Based on the access levels defined, a session varialble is set called $_SESSION['authtype'], and

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Trinath Somanchi
Hi- Since you are checking the authtype variable in the environmental variable for each page which is requested, There cannot be any chance for a intruder to get access to the page. But then, for an enhanced security, do maintain a table in db with relation between authtype and access to page and

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Govinda
Hey, I am working on the application, thought its not OOP currently, I plan to take it further in a year or so. Right now, I have 4 access levels which define what the users can do on the application. Based on the access levels defined, a session varialble is set called

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Vinay Kannan
Yup, With some help from Jey earlier today, I was able to figure it out.. I only realized it later, how easy it was since all the auth types were being set already, the same piece of code at the beginning of every page should have been good ! Thanks, Vinay On Thu, Mar 29, 2012 at 7:28 PM,

[PHP-DB] Flow of PHP testClass

2012-03-29 Thread Rikin Parekh
Hi Guys, Given below is a PHP script. Can someone help me with the output of the code. According to my understanding the output should be 3, 50, 20, 10. Can someone elaborate on the same and provide me an explanation on the flow? Thanks a lot in advance. ?php class TestClass { var $a =20; var

[PHP-DB] RE: [PHP-WIN] Flow of PHP testClass

2012-03-29 Thread Jim MacDiarmid
-­‐printAB(); -Original Message- From: Rikin Parekh [mailto:riki...@gmail.com] Sent: Thursday, March 29, 2012 10:57 AM To: PHP DB; php-wind...@lists.php.net; phpexperts-subscr...@yahoogroups.com Subject: [PHP-WIN] Flow of PHP testClass Hi Guys, Given below is a PHP script. Can someone help

[PHP-DB] search of data base - again

2012-03-29 Thread Ethan Rosenberg
Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql describe Visit3; ++--+--+-+-++ | Field | Type | Null | Key | Default

Re: [PHP-DB] search of data base - again

2012-03-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote: Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql describe Visit3;

[PHP-DB] Excel to HTML table using PHP

2012-03-21 Thread Gu®u
Hi All, I have searched all around the net and unable to find excel to html table using php. What I want is, say I have an excel sheet and I want to export the excel data to HTML table *without* *opening it*. Then I can use the HTML table for later function. Please help me with this. -- *Best,

Re: [PHP-DB] Excel to HTML table using PHP

2012-03-21 Thread Amit Tandon
Try this linkhttp://devzone.zend.com/27/reading-and-writing-spreadsheets-with-php/. What i understand is that u do not want the end user to open the excel sheet. However, u have to read the data part and display in HTML using PHP/Javascript regds amit The difference between fiction

Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 17:33:43 +0530, Gu®u nagendra802...@gmail.com sent: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. ?php if($search-plugin-ListViewValue()==)

Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 21:23:57 +0530, Gu®u nagendra802...@gmail.com sent: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook

[PHP-DB] Re: confirm subscribe to php-db@lists.php.net

2012-03-17 Thread nathhuan
On 03/17/2012 04:30 PM, php-db-h...@lists.php.net wrote: Hi! This is the ezmlm program. I'm managing the php-db@lists.php.net mailing list. I'm working for my owner, who can be reached at php-db-ow...@lists.php.net. To confirm that you would like nathh...@cisco.com added to the php-db

Re: [PHP-DB] Re: confirm subscribe to php-db@lists.php.net

2012-03-17 Thread Gu®u
On Sat, Mar 17, 2012 at 1:37 AM, nathhuan nathh...@cisco.com wrote: On 03/17/2012 04:30 PM, php-db-h...@lists.php.net wrote: Hi! This is the ezmlm program. I'm managing the php-db@lists.php.net mailing list. I'm working for my owner, who can be reached at php-db-ow...@lists.php.net

[PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. ?php if($search-plugin-ListViewValue()==) { echo 'a

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. I have looked at it. Maybe you should tell what is

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
The issue is both the images are echoing and no if else statement is working. On Tue, Mar 13, 2012 at 7:22 PM, Matijn Woudt tijn...@gmail.com wrote: On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote: Hi, Please help me with this code. I have 2 different fields in mysql

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u nagendra802...@gmail.com wrote: The issue is both the images are echoing and no if else statement is working. First of all, please bottom post on this (and probably any) mailing list. You should perhaps provide what the contents of

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
From looking at your code, the issue is that your if statements are checking for the same criteria as your else statements, meaning that if the string is empty () the if statements will be triggered, and since the if statements are true, the elseif statement will not be. Or if the string isn't

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook is empty echo out only twitter, if variable twitter has no value and

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
Hmm, what happens with the code I sent you? Just tested it on my end and worked exactly as expected. Try doing a var_dump($search-plugin-ListViewValue(), $search-facebook-ListViewValue()); to make sure the data being returned is what's expected... you should be getting string(0) returned for

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u nagendra802...@gmail.com wrote: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
I tried the below code too considering may be the localhost is really dumb and we need to tell each and every condition. But still its not working :( $tweet = $search-plugin-ListViewValue(); $fb = $search-facebook-ListViewValue(); if($tweet== $fb==) {

Fwd: [PHP-DB] Select from multiple tables

2012-03-01 Thread Carl Michael Skog
-- Vidarebefordrat meddelande -- Från: Carl Michael Skog cms...@gmail.com Datum: 1 mars 2012 17:12 Ämne: Re: [PHP-DB] Select from multiple tables Till: Kranthi Krishna kranthi...@gmail.com It seems to me that you are mixing two semantically different things(board_entries

Re: [PHP-DB] Select from multiple tables

2012-03-01 Thread Kranthi Krishna
Kranthi. http://goo.gl/e6t3 On 1 March 2012 21:47, Carl Michael Skog cms...@gmail.com wrote: -- Vidarebefordrat meddelande -- Från: Carl Michael Skog cms...@gmail.com Datum: 1 mars 2012 17:12 Ämne: Re: [PHP-DB] Select from multiple tables Till: Kranthi Krishna kranthi

[PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi all, Say I have an object like array schoolName = string board = array string string I generally create two MySql tables schools: id PRIMARY KEY, SchoolName boards: id FOREGIN KEY refers Table A(id), board and then do two selects. The problem is that, the number

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Matijn Woudt
On Wed, Feb 29, 2012 at 3:01 PM, Kranthi Krishna kranthi...@gmail.com wrote: Hi all, Say I have an object like array    schoolName = string    board = array         string         string I generally create  two MySql tables schools: id PRIMARY KEY, SchoolName boards: id FOREGIN KEY

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi, Thanks for the input. I have seen some tutorials on joins, they all suggest that MySql returns multiple rows For example -- School | Board 1 -- School | Board 1 - Now if I have another one-to-many relation

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi, The examples I saw were regarding cartesian join not inner join. I will read about inner joins. Also, the example i mentioned seems to be a mistake. Both school and type will not be similar at the same time Kranthi. http://goo.gl/e6t3 On 1 March 2012 09:26, Kranthi Krishna

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Amit Tandon
Dear Kranthi You have to be clear what you decide especially when you are getting multiple rows. To get just a single row you can use LIMIT clause. But it would return only one row. Now you have to decide which row. So i think you decide on what you require and see how can you uniquely

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Karl DeSaulniers
Try DISTINCT On Feb 29, 2012, at 10:28 PM, Amit Tandon wrote: Dear Kranthi You have to be clear what you decide especially when you are getting multiple rows. To get just a single row you can use LIMIT clause. But it would return only one row. Now you have to decide which row. So i think

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi all, SELECT DISTINCT s.Title, b.Board_id, t.type FROM school s, board_entries b, schooltypeentries t WHERE s.School_id = 1698 AND b.School_id = 1698 AND t.schoolid = 1698 this SQL query gives me Kendriya Vidyalaya 15 Kick Boxing Kendriya Vidyalaya 15 Karate Kendriya

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Karl DeSaulniers
This is just a stab in the dark and may be in the wrong order. If it does not work I apologize. SELECT s.Title, (SELECT DISTINCT b.Board_id), (SELECT DISTINCT t.type), (SELECT s.School_id AND b.School_id AND t.schoolid AS id ) FROM school s, board_entries b, schooltypeentries t WHERE id =

Re: [PHP-DB] PDO Vs MySQLi Vs SQL Queries.

2012-02-28 Thread Donahue Trevor
Hi Vinay, No, using native mysql_* statement isn't always faster. Advantages are obvious, as mentioned in the article you shared (object mapping, security, performance), there's always things like caching and other stuff you don't want to reinvent the wheel for and on big projects tend to be

Re: [PHP-DB] PDO Vs MySQLi Vs SQL Queries.

2012-02-28 Thread Vinay Kannan
Hi Trevor, Thank You for your suggestion, yeah i think caching is something i definitely want to look at and something thats important, and there is a big project coming up, its pretty much the biggest i've taken up so far, theres also a mobile app for android which needs to be done, so caching

[PHP-DB] PDO Vs MySQLi Vs SQL Queries.

2012-02-27 Thread Vinay Kannan
Hey Guys, I came across this article. http://net.tutsplus.com/tutorials/php/pdo-vs-mysqli-which-should-you-use/ Though I've been working with PHP for over 2 yrs, i never bothered to use the techniques mentioned in the articles like this. What i do for DB connections and queries..is just simple

[PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
Dear list - This did not seem to post, so I am sending it again. If it did post, and I missed it, my apologies. Ethan Dear list - I have the following code: $query = select * from Intake3 where 1; $allowed_fields = array('Site', 'MedRec', 'Fname', 'Lname',

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This would convert the variable field to value.

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line if ( ! empty( $_POST['field'] ) ) change it to if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field New line : The Program is seacging for varable

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Problem w/query - again - CORRECTION

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Multiple Access to Database - The Answer

2012-02-05 Thread Govinda
[snip] PS: I respectfully request that if a user asks a question, that an explicit answer be given, not just a reference to the manual. It could be then followed by a manual reference. The user then has his answer and can look up more detail in the manual. Thanks. Ethan

Re: [PHP-DB] File Upload in PHP

2012-02-02 Thread Trinath Somanchi
Hi- Thanks for the reply. I'm near to the solution but was struct at teh end. I have configured post_max_size, memory_limit, max_upload_filesize to '-1' and max_execution_time to ' 0'. and restarted the server. But then, Apache and Browser problems were in place. In IE6 and IE7, The

[PHP-DB] File Upload in PHP

2012-02-01 Thread Trinath Somanchi
Hi All- I have doubt regarding file upload in PHP. With out updating the INI file settings, Can PHP process File upload just like Apache handling Multipart post. Like, Irrespective of post_max_size being 8M, PHP must process a 15MB Post data (15MB Uploaded file.) How to work this out with PHP.

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Karl DeSaulniers
I would set post_max_size in your htaccess for the directory where your upload.php file is. Or base64 your file and upload 8Mb chunks, then reassemble and store. but I am sure someone has a better solution than I. also, I may be wrong on this too, but this is a PHP General question, not

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Karl DeSaulniers
Sry, not better help... better luck. :) Best, Karl On Feb 1, 2012, at 7:01 AM, Karl DeSaulniers wrote: I would set post_max_size in your htaccess for the directory where your upload.php file is. Or base64 your file and upload 8Mb chunks, then reassemble and store. but I am sure someone

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Ege Sertçetin
Hi Trinath, You can use ini_set() function to change ini settings only for your upload script. http://php.net/manual/en/function.ini-set.php However, you cannot change any parameter you want. There is a list about php.ini parameters. As I remember, you just can set PHP_INI_ALL and

[PHP-DB] Subscription Suspensions

2012-01-31 Thread Ron Piggott
Hi Everyone. I manage an e-mail list. I am trying to add a new function into it: suspensions. The idea is that someone wouldn’t have to unsubscribe. Instead there would be a record of their suspension in the table member_subscription_suspensions and their account wouldn’t be included as a

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Matijn Woudt
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott ron.pigg...@actsministries.org wrote: Hi Everyone. I manage an e-mail list.  I am trying to add a new function into it: suspensions.  The idea is that someone wouldn’t have to unsubscribe.  Instead there would be a record of their suspension in

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Ron Piggott
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott ron.pigg...@actsministries.org wrote: Hi Everyone. I manage an e-mail list. I am trying to add a new function into it: suspensions. The idea is that someone wouldn’t have to unsubscribe. Instead there would be a record of their suspension in

[PHP-DB] mssql datetime weirdness

2012-01-30 Thread Udo Rader
Hi, I am facing some weird results when querying a MSSQL 2008 server, giving me just plain wrong results like 2012-01-01 32747:02 (usage of mssql_fetch_assoc originates from the original code fragment): Here's what I do: CUT- ?php ini_set( 'mssql.datetimeconvert', false ); $dbh

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread David McGlone
On Thu, 2012-01-26 at 11:59 +, Lester Caine wrote: David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread Lester Caine
David McGlone wrote: I started with PHP just before PHP5 was finally released, so never used PHP4, and found ADOdb very early on so have never used anything else. One gets stuck in one's way when something simply works ... Probably why I'm finding PDO such a backwards step having been

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread David McGlone
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen it described in a php book? While I

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Lester Caine
David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen it

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Matijn Woudt
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone da...@dmcentral.net wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php  adodb. The only documentation on ADOdb is the website

[PHP-DB] php adodb book suggestins

2012-01-25 Thread David McGlone
can anyone suggest any good up to date books out there on php adodb. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] SQLite3 API missing createCollation()

2012-01-23 Thread b dewar
Hi The C API for SQLite3 has an sqlite3_create_collation() feature that's missing from PHP's SQLite3 class API. I'm working on a patch that adds the SQLite3::createCollation(string collation_name, mixed callback) method. This allows registering a PHP function as a comparator for the database to

[PHP-DB] Settings to Allow Precise File Upload Bytes

2012-01-20 Thread Dee Ayy
Please advise the proper settings (Apache/PHP/HTML/MySQL/Anything else I missed) to allow a specific byte size upload and to deny 1 byte over with error reporting in LAMP/AJAX. I've heard of Flash and Gears solutions, but these require additional installs for the user -- just to know the file

[PHP-DB] Re: Settings to Allow Precise File Upload Bytes

2012-01-20 Thread Maciek Sokolewicz
Your problem here is the fact that you do not seem to grasp what is hapenning when a file is being uploaded, hence your question. So let me explain: 1. A user goes to your page by entering it into the browser. 2. The page is downloaded to the client, and the connection is closed. 3. The user

[PHP-DB] Re: Settings to Allow Precise File Upload Bytes

2012-01-20 Thread Dee Ayy
Obviously I don't want a Flash/Gears solution. FYI: Your #6 should be: The server uploads... Even though I do not want a Flash/Gears solution, I would be happy with your #8 stating: I won't fail silently, I'll report the problem to the user. Do you know the correct settings on any applicable

[PHP-DB] Re: Settings to Allow Precise File Upload Bytes

2012-01-20 Thread Maciek Sokolewicz
Answers are inside the mail On 20 January 2012 21:18, Dee Ayy dee@gmail.com wrote: Obviously I don't want a Flash/Gears solution. FYI: Your #6 should be: The server uploads... No, the server downloads, the client uploads. Downloading is performed by the receiving end (in this case, the

[PHP-DB] Re: Settings to Allow Precise File Upload Bytes

2012-01-20 Thread Dee Ayy
My browser is claiming it is still busy from a 1MB (1030001 bytes) upload where I was trying to find out if it is setting $_FILES['attachment']. Thanks Maciek. It makes sense that I should be looking at $_FILES['attachment']['error'] before the size. I'm just surprised it's still hanging. I'm

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-18 Thread Niel Archer
Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do this. PREFACE: I have now moved colors and sizes to their own tables and added a product options table

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-18 Thread Karl DeSaulniers
Hi Niel, Thanks for taking the time to respond. Comments below. On Jan 18, 2012, at 11:14 AM, Niel Archer wrote: Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do

[PHP-DB] Multiple Access to Database - The Answer

2012-01-18 Thread Ethan Rosenberg
Dear List - I have a database: mysql show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type

<    5   6   7   8   9   10   11   12   13   14   >