[PHP-DB] MySQLi, MongoDB and MySQL work together

2019-07-17 Thread Matt Zand
synchronize data or what is best way to achieve that? I have basic knowledge of MongoDB, so I appreciate your advice. -- Cheers, Matt Zand Cell: 202-420-9192 Work: 240-200-6131 High School Technology Services <https://myhsts.org/> DC Web Makers <https://dcwebmakers.com/> Coding Boot

[PHP-DB] Issue using IBM iAccess, ODBC, and PDO

2016-01-13 Thread Matt Parnell
ng it. Have any of you successfully managed to call stored procs using iAccess? I had to workaround, for now, using java and the JDBC driver, which work perfectly. Thanks! Matt Parnell

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Matt Pelmear
. (You may wish to read about buffered vs unbuffered queries) Matt On Sep 2, 2014 9:57 PM, "Karl DeSaulniers" wrote: > On Sep 2, 2014, at 9:37 PM, Ethan Rosenberg < > erosenb...@hygeiabiomedical.com> wrote: > > > Dear List - > > > > Th

Re: [PHP-DB] Number of Lines in Table.

2014-09-02 Thread Matt Pelmear
See : http://stackoverflow.com/questions/14682448/how-to-get-the-total-row-count-with-mysqli Matt On Sep 2, 2014 7:38 PM, "Ethan Rosenberg" wrote: > Dear List - > > This works: > > mysql> describe Purchases; > +---+-+--+-+-+---

Re: [PHP-DB] Writing Problems

2014-08-27 Thread Matt Pelmear
to try is to put the output of fprintf() into a variable and echo that variable, just to make sure everything is working fine there, but at a glance that all looks ok. -Matt On Tue, Aug 26, 2014 at 8:12 PM, Ethan Rosenberg < erosenb...@hygeiabiomedical.com> wrote: > On 08/26/2014 0

Re: [PHP-DB] Writing Problems

2014-08-26 Thread Matt Pelmear
not world-writeable. (you almost never want things to be world-writeable) Matt On Aug 26, 2014 5:45 PM, "Ethan Rosenberg" wrote: > Dear List - > > I can't figure this one out. > > 1] Straighten out ownership > > ethan@meow:/var/www$ rm receipt.txt >

Re: [PHP-DB] Re: www-data file

2014-08-26 Thread Matt Pelmear
On 08/26/2014 06:21 AM, Jim Giner wrote: On 8/26/2014 12:20 AM, Ethan Rosenberg wrote: Dear list - When I use fopen, the file owner and group are both www-data. How can I ensure that the owner and group will be ethan? TIA Ethan Why should ownership be a concern when you are simply openin

Re: [PHP-DB] www-data file

2014-08-25 Thread Matt Pelmear
ments quite nicely in the past. You'll find that simply chowning from inside php won't always work, depending on how your groups are setup. If it will be just one file (rather than an unlimited number of them created by the server), simply chown it to "ethan" manually, once. -mat

Re: [PHP-DB] Popular website search engines

2014-03-13 Thread Matt Pelmear
Besides the usual suspects that are 3rd party, a common solution I've seen is Solr/Lucene: https://lucene.apache.org/solr/ -Matt On 03/13/2014 11:44 AM PT, Olivier Austina wrote: Hi, I am new to website search engine area.I would like to do a survey of popular search engine used

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Matt Pelmear
an/5.0/en/mysql-tzinfo-to-sql.html If it is running in a Windows environment: http://dev.mysql.com/downloads/timezones.html -Matt On 11/10/2013 04:22 PM PT, Ron Piggott wrote: A suggestion I was given is to use the mySQL "CONVERT_TZ" command with the PHP time zone names. But when

Re: [PHP-DB] Calculating Past Dates In A Different Time Zone

2013-11-10 Thread Matt Pelmear
;setTimezone( $tz_gmt ); /* * At this point: * $start_dt->format('Y-m-d H:i:s') == the beginning of our interval in GMT * $end_dt->format('Y-m-d H:i:s') == the end of our interval in GMT */ // We'll use a PDO prepared statement as an example here. Assume $dbh

Re: [PHP-DB] Subject Matter

2013-08-23 Thread Matt Pelmear
On 08/23/2013 04:36 PM, Lester Caine wrote: Matt Pelmear wrote: I am not sure who runs the list, whether they care about off-topic posts, or whether anyone else cares about it. The php lists are only loosely moderated, but comments like yours usually bring things under control. I'd

[PHP-DB] Subject Matter

2013-08-23 Thread Matt Pelmear
ribed to). Thoughts appreciated. -Matt

Re: [PHP-DB] chmod

2013-08-19 Thread Matt Pelmear
this question would be either the "General user list" or, if you are indeed using Windows, the "Windows PHP users list": http://php.net/mailing-lists.php -Matt On 08/20/2013 08:39 AM, Emiliano Boragina wrote: Hello everyone, I try to use chmod 0777, but the JPG file in my

Re: [PHP-DB] Sorting a PHP array

2013-05-15 Thread Matt Pelmear
wever, strongly recommend keeping the work in the database. (If you're using a bleeding-edge version of PHP (I think this is in the 5.5 release candidates), you could also use array_column() along with usort() or uasort() to make your life easier.) -Matt On 05/15/2013 09:32 AM, Charlie Lewis

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Matt Pelmear
to me, but I keep hoping things will turn around... -Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution, but with the script, easy to maintain. Honestly, you would be better off just putting those 6

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
-htaccess-tips-tricks.html) -Matt It sounds like I'll have to modify multiple htaccess files - which is about the same as this php.ini problem - having multiples perhaps. I've been working fine with a php.ini that merges onto the "full" ini file. Suddenly this new appl is not

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 01:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which-is-passed-by-get-or-post Every pro has this feature (magic_quotes_gpc) turned off. If you understand SQL Injection

Re: [PHP-DB] pdo ?

2013-01-24 Thread Matt Pelmear
. -Matt On 01/24/2013 08:55 AM, Jim Giner wrote: ok - new to using pdo functions, but I thought I had a handle on it. I'm writing out to my page an input tag with the following value in it: 49'ers I can confirm it by using my browser's "view source" to see that is

Re: [PHP-DB] Programs not running - Mystery SOLVED

2013-01-07 Thread Matt Pelmear
This is a *very* common problem, so don't feel too bad :-) I personally *never* set the error reporting level in the code, and during code reviews I reject code that does so. It is much cleaner to manage this in php.ini. Glad you solved your problem. -Matt On 01/07/2013 08:49 AM,

Re: [PHP-DB] Programs not running

2013-01-07 Thread Matt Pelmear
-booted into Windows. (They say it runs fine in Wine, but major things like the code completion popup are either difficult or impossible to get working. Anyone from NuSphere listening? I want to pay you for a native Linux version like you used to have...) -Matt -- PHP Database Mailing List (htt

Re: [PHP-DB] Programs not running

2013-01-04 Thread Matt Pelmear
On 01/04/2013 06:00 PM, tamouse mailing lists wrote: On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote: On 01/04/2013 01:40 PM, tamouse mailing lists wrote: One should be able to solve parsing problems without resorting to using a web server. Every time I save a php file, I have my editor

Re: [PHP-DB] Programs not running

2013-01-04 Thread Matt Pelmear
On 01/04/2013 01:40 PM, tamouse mailing lists wrote: One should be able to solve parsing problems without resorting to using a web server. Every time I save a php file, I have my editor set to run it through php -l. Saves lots of angst when I get to the web testing stage. This is a good idea

Re: [PHP-DB] Programs not running

2013-01-03 Thread Matt Pelmear
s weren't enough- I've had to actually remove the code from the file and paste it in bit by bit. PHP can be extremely annoying sometimes. -Matt On 01/03/2013 08:54 PM, Ethan Rosenberg, PhD wrote: ===== Jim and Matt - Did all the suggested debugging prior to se

Re: [PHP-DB] Programs not running

2013-01-03 Thread Matt Pelmear
In addition to Jim's comments, Have you checked to see whether the permissions on all files are appropriate on the environment where this doesn't work? Are you running this in a web environment or CLI? If web, are you 100% sure the web server configuration is correct? -Matt On 01/

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Matt Pelmear
want, depending on how large you anticipate those lists becoming. If you care about efficiency you may want to look at this blog post: http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/ -Matt On 11/26/2012 09:55 PM, Karl DeSaulniers wrote: Hi guys, Thanks for your responses.

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Matt Pelmear
. That said, you could use a TEXT field to store a comma separated list, I just wouldn't recommend doing it that way. -Matt On 11/26/2012 06:01 PM, Karl DeSaulniers wrote: On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Matt Pelmear
nd the elements around it to see if there is some strange padding. Or, try disabling any stylesheets you are loading with the page to see if it still renders in an undesirable way. Good luck, -Matt On 11/25/2012 07:05 PM, Jim Giner wrote: On 11/25/2012 5:39 PM, Ethan Rosenberg, PhD wrote: List -

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-28 Thread Matt Pelmear
this section of my example: $stmt = mysqli_prepare( $dbh, $q ); if( !$stmt ) throw new Exception( 'Error preparing statement' ); where $dbh is the result of mysqli_connect() and $q is a string containing your unbound query. -Matt On 09/28/2012 09:46 AM, Ethan Rosenberg,

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Matt Pelmear
nd_param() page shows one way of solving the issue you are having. (http://php.net/manual/en/mysqli-stmt.bind-param.php) I think you will find people a lot more willing to help if you can show that you've done basic research like looking at the documentation for the function you are tryi

Re: [PHP-DB] Prepared Statements - Select

2012-09-21 Thread Matt Pelmear
( !array_key_exists( $k, $_POST ) ) continue; $args[] = $_POST[$k]; $types .= $type; $sql1 .= " AND ($key = ?) "; } $stmt = mysqli_prepare( $mysql_resource, $sql1 ); if( !call_user_func_array( 'mysqli_stmt_bind_param', array_unshift($args, $stmt, $types) ) )

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Matt Pelmear
ww.artfulsoftware.com/infotree/queries.php#78 -Matt On 09/19/2012 01:33 PM, Bruno Sandivilli wrote: Sorry for the lack of explanation. Again: I have to model a bill table. The bill have 20 fields. But for each field we have: *registered* value, *billed *value and* total value.* So i've created

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Matt Pelmear
space? Can you provide a little more detail about the data? -Matt On 09/19/2012 11:44 AM, Bruno Sandivilli wrote: Anyone? Please. 2012/9/18 Bruno Sandivilli Hi, i strugling to decide what is the best choice: I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have 3 value

Re: [PHP-DB] PDO user question

2012-09-10 Thread Matt Pelmear
on your result set (which would be advisable if you're returning these results in a web interface). -Matt On 09/09/2012 02:40 PM, brandon wrote: That's how I'd do it. Extend the PDO interface on your abstract class to include a "num_rows()" method that utilizes that h

Re: [PHP-DB] mysqli_connect ??

2012-09-10 Thread Matt Pelmear
ysql If you're in a hosted environment, you might be out of luck unless they'll install it for you :-) But I would also be surprised if a hosted environment was missing this package. -Matt On 09/07/2012 01:36 PM, Jim Giner wrote: No - they are not. :( On 9/7/2012 1:32 PM, Bastien Ko

Re: [PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Matt Pelmear
anual/en/mysqli-stmt.execute.php -Matt On 09/10/2012 08:29 PM, Karl DeSaulniers wrote: On Sep 10, 2012, at 7:06 PM, Ethan Rosenberg, PhD wrote: Dear list - Here is my code: $sql3 = "select max(Indx) from Visit3"; $result7 = mysqli_query($cxn, $sql3); $row7 = mysqli_fetch_ar

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Matt Pelmear
of data and performing manipulations on it in the code as well. columnCount can be useful here. (In fact, it comes from the mysql library directly, if I'm reading the code correctly.) -Matt On 09/10/2012 10:57 AM, Jim Giner wrote: On 9/10/2012 10:53 AM, Graham H. wrote: I think it'

Re: [PHP-DB] Adding entry to /dev

2012-09-10 Thread Matt Pelmear
Ethan, I think you should be a little more specific about what your end goal is. -Matt On 09/10/2012 07:41 PM, Ethan Rosenberg, PhD wrote: Dear list - How do I add a new entry to /dev; eg, /dev/sdb? Thanks, Ethan Rosenberg -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread Matt Pelmear
7;]['name']}' in it." or this: "This is my string with '" . $_POST['image']['name'] , "' in it, using the concatenate operator." -Matt On 08/27/2012 04:43 PM, David McGlone wrote: On Monday, August 27, 2012 03:36:41 PM M

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread Matt Pelmear
ant to also look at the alternative mysql drivers, as the API you're using is planned for deprecation at some point. http://php.net/manual/en/mysql.php http://www.php.net/manual/en/mysqlinfo.api.choosing.php (this page seems to leave out the mysqlnd driver) -Matt On 08/27/2012 03:04

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-21 Thread Matt Pelmear
Amit, Thanks for the suggestion. Unfortunately, even when I explicitly enable E_WARNING or even E_ALL error reporting in php I still do not receive any indication that data was truncated on insert. -Matt On 08/21/2012 07:09 AM, Amit Tandon wrote: Dear Matt, Even with MySQL, u get the

Re: [PHP-DB] Re: PDO Mysql data truncation missing error

2012-08-20 Thread Matt Pelmear
On 08/21/2012 01:08 AM, David Robley wrote: Matt Pelmear wrote: Hello, I'm trying to detect data truncation on insert to MySQL using PDO. As far as I can tell, this gets reported at least in some cases (ex: http://drupal.org/node/1528628), but I have been unable to see this myself. The

[PHP-DB] PDO Mysql data truncation missing error

2012-08-20 Thread Matt Pelmear
cated after the 5th character as expected, but the truncation is not reported. (running in php 5.3.2 and 5.3.4) Running the same query directly in the mysql command line shows a warning as expected. Am I missing something simple here? Thanks, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Insert a xml file into a DB

2008-09-23 Thread Matt Anderton
I'm with Yves -- just store the xml files on the local disk and then record their *location* in the DB if you need to reference them. if you really want to store the xml in the db, why not just use a 'text' data type? -- matt On Tue, Sep 23, 2008 at 4:35 PM, YVES SUCAET &l

Re: [PHP-DB] mySQL SELECT query

2008-08-29 Thread Matt Anderton
or NOT IN (0,4) -- matt On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts <[EMAIL PROTECTED]>wrote: > In the SQL standard this would be > > AND NOT ministry_directory.listing_approved=0 AND NOT > ministry_directory.listing_approved=4 > > MySQL supports (and there are pr

Re: [PHP-DB] Submit Button variable passing

2008-05-03 Thread Matt Anderton
quot; onclick=\"deleteCategory('" . $row['reference'] > . "');\">\n"; >$table .= " id=\"rename\" > value=\"Rename Category\" onclick=\"renameCategory('" . $row['reference'] > . "&#

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Matt Anderton
this process. that goes for any other field you don't want the user to be able to edit too -- just don't put it in the form or the update and they can't mess with it. I usually have an "is_admin" (yes/no) field and don't want the user to change that of course. -- matt

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Matt Anderton
fields they changed get changed in the db. if($_POST['_submit']) { $update = "UPDATE member SET .. blah, blah..." } that way, none of the fields are blank unless they were in the db blank to begin with. and you can add client or server-side validation to prevent

Re: [PHP-DB] Multiple values in SELECT query

2008-03-09 Thread Matt Anderton
I like the "IN" keyword: SELECT * FROM table WHERE name LIKE "ABC" AND listing_type IN ('1','2'); works kinda like PHP's "in_array" -- matt On Sun, Mar 9, 2008 at 1:34 PM, Ron Piggott <[EMAIL PROTECTED]> wrote: > What is the co

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Matt Anderton
httpd.conf should have something like this: PHPIniDir "C:/Program Files/PHP/" LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll" AddType application/x-httpd-php .php ... but all that should have been taken care of by the PHP installer. -- matt On Sat, Mar 8, 200

Re: [PHP-DB] mysql_connect() Help

2008-03-08 Thread Matt Anderton
a missing directive or two in your php.ini. something like... [PHP_MYSQL] extension=php_mysql.dll but there may be some other directives you are missing - port numbers, etc. best to just reinstall. -- matt On Sat, Mar 8, 2008 at 5:53 PM, Manysh <[EMAIL PROTECTED]> wrote: > Thanks for your i

Re: [PHP-DB] New to PHP/MySQL - Need help with images

2008-01-05 Thread Matt Anderton
how about like this: echo "\n"; $result = @mysql_query("SELECT image FROM specials"); while($row = mysql_fetch_row($result)) { echo "\n"; } echo "\n\n"; hope it helps! matt On Jan 5, 2008 4:51 PM, Thomas <[EMAIL PROTECTED]> wrote: > I'm

Re: [PHP-DB] Re: [PHP] the opposite of a join?

2007-10-03 Thread Matt Anderton
| ++--++ company: ++---+ | id | name | ++---+ | 1 | Company A | | 2 | Company B | | 3 | Company C | ++---+ -- matt On 10/3/07, Zoltán Németh <[EMAIL PROTECTED]> wrote: > > 2007. 10. 3, szerda keltezéssel 05.21-kor [EMAIL PR

[PHP-DB] How to test PHP form for proper input

2007-08-03 Thread Phil Matt
I've got a mail form that automatically pulls in the addressee from a MySQL db, and lets the sender fill in his/her own info before sending. I figured out how to set up tests for legal input in the different fields, but I don't know how to incorporate the test results into my form submission cod

Re: [PHP-DB] First and Last ID of a table

2007-07-11 Thread Matt Leonhardt
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > SELECT MIN(id), MAX(id) FROM mytable As an aside, is you are using associative arrays, be sure to use the following keys: $array['MIN(id)'] and $array['MAX(id)'] Just something I figured out recentl

Re: [PHP-DB] Newbie alert: supplied argument is not a valid MySQL result resource

2007-07-11 Thread Matt Leonhardt
wing code, and it behaved exactly like the code I first posted, which I'm not sure why: ($query = mysql_query("valid SQL")) || die(); Shouldn't everything within the first set of parentheses here evaluate as the first || condition? Thanks for everyone's help, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Newbie alert: supplied argument is not a valid MySQL result resource

2007-07-09 Thread Matt Leonhardt
Okay, so I get that the mysql_query() function here is not returning a valid resource identifier. I just can't figure out why...here's the pertinent code: (db.php) (auth.php) http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Mailto and PHP

2007-06-14 Thread Phil Matt
around for the right syntax, but it just escapes me. I have the Welling & Thompson book, but it only mentions that this can be done, without a clue as to how to do it. Pardon my ignorance, but this is not my area of expertise. TIA for your collective wisdom! --- P. Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php portfolio

2007-04-19 Thread Matt Anderton
separate website? point the employer to the real deal first, then give him a link to a "behind the scenes" version? and then what? just throw in "" tags -- "this is how I did this part"? ~ matt On 4/19/07, bedul <[EMAIL PROTECTED]> wrote: nope.. nothing du

[PHP-DB] php portfolio

2007-04-18 Thread Matt Anderton
just a link to one of my finished projects? can an experienced programmer get a strong enough sense of how I code by looking at the end result (probably a dumb question)? thanks, matt

Re: [PHP-DB] Re: populating multi-dimensional array

2007-04-11 Thread Matt Anderton
thanks for the advice Roberto! the typos in (2) WERE the cause of my problems. I appreciate the comments on my SQL queries and table structures too. sloppy rookie mistakes. ~ matt On 4/11/07, Roberto Mansfield <[EMAIL PROTECTED]> wrote: Matt Anderton wrote: > long-time reader, f

[PHP-DB] populating multi-dimensional array

2007-04-11 Thread Matt Anderton
#x27;, 'Categories: '); 31 $sel->setMainOptions($main); 32 $sel->setSecOptions($secondary); 33 $form->addElement('submit', 'btnSubmit', 'Submit'); 34 35 $form->display(); **

Re: [PHP-DB] big problem with PhPBB and PHP

2006-10-12 Thread Matt
Did you install PHP from the FreeBSD ports tree? If yes, then you need to make sure you've also installed the "php5-pgsql" port located in "/usr/ports/databases/php5-pgsql". On 10/12/06, jamesbond <[EMAIL PROTECTED]> wrote: Hi, I'm trying to install PhPBB on a FreeBSD box, and am having proble

Re: [PHP-DB] php crashes with msyql

2006-03-22 Thread Matt Richards
net connection broke just before i hit the send button and i have to run off now so i dont have time to read all the replys. HTH Matt. > Hello, > > I have a mission critical problem that I cant seem to solve. Can > anyone help?? > > I'll even offer $100 paypal if someone gives me

[PHP-DB] Re: Still having trouble with mysqli unclonable objects

2005-12-01 Thread Matt Monaco
compatibility_mode = Off in php.ini ? > > regards > holo > > > > ""Matt Monaco"" <[EMAIL PROTECTED]> escreveu na mensagem > news:[EMAIL PROTECTED] >>I am having all sorts of trouble with unclonable objects of type mysqli >>and mysqli_re

[PHP-DB] Still having trouble with mysqli unclonable objects

2005-12-01 Thread Matt Monaco
anyone experienced this sort of issue before? Thanks in advance for any assistance, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Comma separated JOIN syntax

2005-11-28 Thread Matt Monaco
for a query involving 5 or 6 tables and WHERE arguments which do not deal with the relationships. I would like to assure the efficiency of this query. Thanks in advance, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Update Quandry

2005-11-25 Thread Matt Monaco
tched from mysql_info your problem should be solved. Matt "maestro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Greetings, > > I am doing an update to a table as such: > > class DB { > > > function updateMember($email, $password, $po

[PHP-DB] Searchable/Sortable Database Fields with MySQL/PHP

2005-07-12 Thread Matt McNeil
ddition, I wouldn't be able to install an encrypted file system on the database server). My sense is that this is a difficult problem. However, I made the mistake of promising this functionality, so I'm scrambling to figure out some kind of solution. Any suggestions? Thanks so much! Ma

Re: [PHP-DB] Queries close session

2005-03-15 Thread Matt Ferris
ave the .php (or equivilant) extension, thus preventing your server from serving their full contents to people who would request them directly (as the server won't know to parse them as PHP scripts). -- Matt Ferris [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] suggestions

2005-03-03 Thread Matt M.
> Hello > > I need to dev a small app and I can think of a couple different ways to > handle it but not sure the best way. I need to register those who come to > our site that want to download .pdf's. They will fill out some information > before I redirect to the pdf. > > I'm thinking the bes

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Matt M.
On Tue, 22 Feb 2005 10:47:43 -0600, Matt M. <[EMAIL PROTECTED]> wrote: > > if ($_POST['op'] != 'ds') { > > $display_block = " > > > > Your E-mail Address: > > > >subscribe > >unsubscribe > >

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Matt M.
> if ($_POST['op'] != 'ds') { > $display_block = " > > Your E-mail Address: > >subscribe >unsubscribe > > > "; > } try: if (isset($_POST['op']) && $_POST['op'] != 'ds') -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

Re: [PHP-DB] referencing external functions

2005-02-15 Thread Matt M.
> and am trying to use it in this links3.php > > include('functions.php') or die (mysql_error()); > ?> > > but I keep getting the error message > *Warning*: main(1): failed to open stream: No such file or directory in > *C:\Accounts\dbadream\wwwRoot\links3.php* on line *4* > *Warning*: main(): F

Re: [PHP-DB] $_GET of array variables

2005-01-05 Thread Matt M.
> $_GET['simplevariable'] but am not having much luck with anything like: > > $_GET["arrayvariable$a"] (1-dimensional array) or > $_GET["arrayvariable$a$b"] (2-dimensional array) > > (I've tried several other odd syntaxes such as > $_GET["arrayvariable[$a][$b]"]. Also it's not an \" situation.)

Re: [PHP-DB] Parsing CSV files into a MySQL Table

2004-11-02 Thread Matt M.
> > $csvfile = file("http://foo.com/foolist.csv";); and this fopen("http://foo.com/foolist.csv";, "r"); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Parsing CSV files into a MySQL Table

2004-11-02 Thread Matt M.
> // > mysql_connect (localhost, foouser, foologin); > > mysql_select_db (footest1); > > $csvfile = file("http://foo.com/foolist.csv";); > > foreach($csvfile as $line_no => $datastring) { > $data = explode (",", $datastring); > $foo1 = $data[0]; > $foo2 = $data[1]; >

Re: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Matt M.
> How can I send a SID (SessionID) in a security way from one page to another? > Is it "security" to do this? not sure what exactly you want. You could just use cookies, dont allow it to be in form fields or query strings. you could use ssl. -- PHP Database Mailing List (http://www.php.net/) T

Re: [PHP-DB] Two session for the same user, possible?

2004-10-21 Thread Matt M.
> Is it possible to have two sessions for the same user in php? If yes, how > can I implement this? > > I am currently using one without problem. However, when I try to create a > second session, the first one is lost. could you post some code. I am not sure I follow what you are doing. -- PHP

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Matt M.
where is your insert statement? I am guessing it is after your loop if ( is_array( $_SESSION['l_industry'] ) ) { foreach ( $_SESSION['l_industry'] as $p ) { $query = "INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES ($LID, $p)"; /This is where y

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Matt M.
if ( is_array( $_SESSION['l_industry'] ) ) { foreach ( $_SESSION['l_industry'] as $p ) { $query = "INSERT INTO Profiles_Industries (ProfileID,IndID) VALUES ($LID, $p)"; } //foreach ( $_SESSION['l_industry'] as $p ) } //if ( is_array( $_SESSION['l_industry'] ) ) --

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Matt M.
> if ( is_array( $_SESSION['l_industry'] ) ) { > foreach ( $_SESSION['l_industry'] as $p ) { > $query = "INSERT INTO Profiles_Industries (ProfileID, > IndID) > VALUES ($LID, $p)"; > } do you have a } for the if statement? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] pdf

2004-10-15 Thread Matt M.
> i want to how i can save the data retrieved from mysql through php in pdf > format. http://www.fpdf.org/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Matt M.
> Warning: session_start(): Cannot send session cookie - > headers already sent by (output started at > /home/lurkkcom/public_html/Multi2Return.php:2) in > /home/lurkkcom/public_html/Multi2Return.php on line 3 read a little more about sessions. session_start is trying to set a cookie but output h

Re: [PHP-DB] code example to store PHP session data in mySQL ?

2004-10-06 Thread Matt M.
> where can I find a working example that shows me how to implement PHPSESSION > with MySQL as stor? i know adodb has session functions, download it a nd take a look maybe here http://www.devarticles.com/c/a/MySQL/Developing-Custom-PHP-Sessions/ also try google. -- PHP Database Mailing List (ht

Re: [PHP-DB] Multi Page Form

2004-10-04 Thread Matt M.
> Not sure if I posted about this yesterday, anyway new > question. > I'm building a multi page form. So I"m using hidden > fields and echoing them to the next page in the loop. > > Now someone tells me this is dangerous. > "because someone can save the final page (with most > of the hidden value

Re: [PHP-DB] microsoft access

2004-10-01 Thread Matt M.
> Does anyone know of a good online source for using php and microsoft > access. > I don't want to have to use asp. > Thank you for your time. you could use com objects with Microsoft ADO -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Names with apostrophe's

2004-09-29 Thread Matt M.
> echo(" href='user_book_results_detail.php?book=$row[book]>$row[book] td>"); http://us4.php.net/urlencode -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] File Mime Type Function

2004-09-23 Thread Matt M.
> I've looked around for a while, does anyone know of a PHP function > already built in to the install that gets the Mime type of a file on > the server? you might try this http://pear.php.net/package/MIME_Type/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] Warning message -- session side-effect

2004-08-27 Thread Matt M.
> Warning: Unknown(): Your script possibly relies on a session side-effect which > existed until PHP 4.2.3. Please be advised that the session extension does > not consider global variables as a source of data, unless register_globals > is enabled. You can disable this functionality and this warnin

Re: [PHP-DB] Postgresql Performance

2004-08-19 Thread Matt M.
On Thu, 19 Aug 2004 18:12:16 -0500, Norma Ramirez <[EMAIL PROTECTED]> wrote: > Hi all, I have a problem with a small software in Postresql, through the > time the database become slower and slower so, quick solution: pg_dump, > dropdb, createdb and pg_dump again but this software is becoming import

Re: [PHP-DB] MySQL to EXCEL?

2004-08-17 Thread Matt M.
> > I have another option that might work for you also. Go to MySQL's website > > and grab their ODBC driver and use that to pull data directly into Excel. > > That's what I do and the end result tends to be a lot cleaner than going > > through cvs or other MySQL exports. > > I was not sure that

Re: [PHP-DB] MySQL to EXCEL?

2004-08-17 Thread Matt M.
> I have another option that might work for you also. Go to MySQL's website > and grab their ODBC driver and use that to pull data directly into Excel. > That's what I do and the end result tends to be a lot cleaner than going > through cvs or other MySQL exports. I was not sure that this was a m

Re: [PHP-DB] MySQL to EXCEL?

2004-08-17 Thread Matt M.
> I'm having a dilemma (Now that I have power back after the hurricane hit us > directly in Orlando). Anyway, I need to export a database table to Excel, I > can do it as a .txt file without a problem, but I can't seem to get it to > put each column into a separate cell when I try to export as an

Re: [PHP-DB] sendmail

2004-08-02 Thread Matt M.
On Mon, 2 Aug 2004 14:31:49 -0400, Aaron Todd <[EMAIL PROTECTED]> wrote: > So far, I have been doing ok with PHP. I feel that I have picked it up > rather easily. But now I need some help. I am trying to use the sendmail > functions to send data entered in a form to my email address. Currently

Re: [PHP-DB] Printing selected characters (strcnt?)

2004-07-15 Thread Matt M.
> $first_name = $_POST['first_name']; > $last_name = $_POST['last_name']; > $name = $first_name . ' ' . $last_name > $rma = ?strcnt($last_name), 1 . Datetime(?) // takes the 1st character from > $last_name and adds datetime in format of 715041200 $rma = substr ($last_name, 0 , 1).Your.Datetime;

[PHP-DB] map algorithm

2004-07-07 Thread matt perry
I have written a shortest point algorithm that takes a number of addresses and finds the best delivery route. Yahoo maps finds the distances between two addresses but I cannot seem to find out how to grab the results and use them in my algorithm. How should I approach this problem? - Matt

  1   2   3   4   >