Re: [PHP-DB] SQL injection

2015-06-21 Thread Mark Murphy
But what does your application do when it gets an invalid SQL statement? Maybe it is telling the attacker something important about your database so that they can compromise it with the appropriate injection. On 2:36PM, Sun, Jun 21, 2015 Lester Caine wrote: > On 21/06/15 18:55, Richard wrote: >

Re: [PHP-DB] Re: Code Security

2015-02-18 Thread Mark Murphy
@Taco, Read back through the whole thread and you will understand. Ethan just can't do what he wants to with PHP. On Feb 18, 2015 9:59 AM, "Taco Mathijs Hillenaar-Meerveld" < tm.hillen...@gmail.com> wrote: > Sorry if i misread and put my reply in a wrong context. > but from how i read this questio

[PHP-DB] Error fetching a second row from a result set (mysql)

2014-11-14 Thread Mark Murphy
loop I get the following error: Warning: mysql_fetch_assoc(): 40 is not a valid MySQL result resource in C:\Users\Mark Murphy\whiworkspace\spur\cron\import_bookings.php on line 89 Problem is that for the resource, the type is changed to Unknown by a different mysql_query within the loop. Any id

Re: [PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
. > Switch back to double quotes? :-) > > $stmt = OCIParse($conn, "SELECT * FROM v\$sql WHERE > INSTR(SQL_TEXT,'something')>0"); > > - Original Message - > From: "Mark Casson" > To: > Sent: Thursday, April 23, 2009 6:10 AM > Subj

Re: [PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Noted! :) ""Ford, Mike"" wrote in message news:93ed589e60ba254f97435fe6c97f2c6702b92...@leedsmet-exch1.leedsmet.ac.uk... On 23 April 2009 11:36, Mark Casson advised: > Hi Guys, > > Thanks to you both - you are spot on! > > Shame this is not better documente

[PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Hi, Of course, the next problem is that i want to specify a line to find: $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE INSTR(SQL_TEXT,'something')>0'); and i seem to have to use single quotes in the INSTR function. Is there an alternative way to deal with th

Re: [PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Hi, For reference, this didn't work, but just using single quotes instead of double quotes did. Mark ""Yves Sucaet"" wrote in message news:006201c9c3ff$4896f7e0$0402a...@rincewind... > What if you use back-quotes `` around the table/view name? > $stmt = OCIPar

[PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. Mark ""Mark Casson"" wrote in message news:89.4e.33545.c2d30...@pb1.pair.com... > Hi, > > I am trying to access some of the v$ views using php on iis, with admin >

[PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Hi, I am trying to access some of the v$ views using php on iis, with admin privileges. However, using: $stmt = OCIParse($conn, "SELECT * FROM v$sql"); gives me this error: PHP Notice: undefined variable: sql . . . Is there a way around this? Thanks Mark -- PHP Database Ma

[PHP-DB] LDAP: get list of ou

2009-04-20 Thread Mark Zimmermann
Hello, i am working with a LDAP tree like this. o=tree ou=de user1 user2 user3 ou=en ou=ignore.me ou=us I wish to get a list of all 'ou' entries and one of their attributes, not the users one. I have no idea, how

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Grant, thank you very much. You are a life saver. This worked perfectly. Thanks again Mark On 16 Mar 2009, at 11:53 AM, Grant Croker wrote: Hi Mark, you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will not work in your case, it's for the Mac OS X supplied Apache.

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
r all your help Mark On 16 Mar 2009, at 10:27 AM, Grant Croker wrote: On/El 16/03/09 09:23, chris smith wrote/escribió: On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown wrote: Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
cle/instanceclient, DYLD_LIBRARY_PATH: /opt/oracle/instanceclient For completeness, I have also put the variables is /etc/profile, /etc/ bash_profile etc So it seems that the variables are set up for sure (unless this is just for php, but I do have these variables in the apache httpd.con

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv ORACLE_BASE /opt/oracle/instanceclient But given that it works on the command line, but not through the browser, I think that the environment variables must be set correctly. Cheers Mark On 16 Mar 2009, at 1:26 AM

[PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-13 Thread Mark Halling-Brown
pache as lots of different users, but to no avail Thanks in advance Mark # PHP SCRIPT # (HOST=)(PORT=1521) ### I have hidden this for security ) (CONNECT_DATA=(SERVER=DEDICATED)(SID=orcl) (SERVICE_NAME=orcl)) )"; if ($c = OCILo

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: MySQL Identifying worst-performing codes

2007-11-09 Thread Mark Summers
There may be something useful here... http://forge.mysql.com/ chris smith wrote: > On Nov 9, 2007 1:18 AM, Colin Guthrie <[EMAIL PROTECTED]> wrote: > >> Lasitha Alawatta wrote: >> >>> There is a tool call "idera" (SQL diagnostic manager). Basically it is >>> a performance monitoring and

[PHP-DB] Executing a query in the future

2007-09-13 Thread Mark Bomgardner
I am looking for a way in PHP to execute a query at some point in the future. Here is my example; I am writing a page to checkout laptop computers to instructors. I want the person that checks out the laptop to receive an email when the laptop is close to being to, but I want this to be automate

[PHP-DB] Connection to MySQL from PHP 4 with SSL enabled by default?

2007-07-23 Thread Mark B.
Hi, I would like to know if there is any setting that allows to connect to mysql from php using SSL by default. I know that there is a flag MYSQL_CLIENT_SSL in mysql_connect, however, I am trying to force PHP apps which I did *not* wrote to transparently connect to mysql using SSL without having

Re: [PHP-DB] array field type

2007-03-06 Thread Mark
Sancar Saran wrote: > Thanks for all those replies. It seems there was no easy solution (and or > serializing was better solution) for us. > > Our arrays contains lots of things.. XML may not fit because content of > array may broke xml structure. > Before you give up, take a look at the XMLDBX

[PHP-DB] Do while loop inside of mail()

2006-07-05 Thread Mark Bomgardner
MySQL 4.1/PHP 4.2 I am trying to generate a email to send to people with a list of events happening through out the month. I am pulling the email addresses from the database with no problem, but when I put the list of events inside of the mail(), it barks at the do while statment. Here is

[PHP-DB] Converting to Decimal

2006-06-28 Thread Mark Bomgardner
I am query a database and pulling some decimal values out of the table, but when I display whole numbers in php, it drops the decimal places. It takes a value of 12.00 in the database and makes it 12, where I need 12.00. I am having trouble finding ways to "cast" this value. markb -- PHP D

Re: [PHP-DB] Generating forms and form elements

2006-06-20 Thread Mark Fellowes
ld, label name, required field, etc). At that point the chosen elements (the ones now in the form) should be pumped back into another table where a name column will save the form intact with all it's elements. Hope this gives a better idea of what I"m trying to acheive. Mark -Orig

Re: [PHP-DB] Generating forms and form elements

2006-06-20 Thread Mark Fellowes
PHP code to generate HTML markup. Or maybe just HTML code and then have the php generate it from the makrup in the table ? Mark -Original Message- From: [EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 6:49 PM -07:00 To: Mark Fellowes [EMAIL PROTECTED] Cc: php-db@lists.php.net Subject

[PHP-DB] Generating forms and form elements

2006-06-20 Thread Mark Fellowes
Hi, Hitting up the list for maybe a decent link(s) or pointers. I need to figure out how to generate forms and form elements from php code inside database tables. Hope this makes sense. It's not a complete picture of what I need to do but the first step I'll need to take. TIA Mark

[PHP-DB] Weird database entry

2006-05-29 Thread Mark Fellowes
site is not totally operational and not really in production I gues I still should have put the validation code in anway :) However aside from my bad behaviour does this type of entry signify an attempt at an attack of any kind ? TIA Mark

[PHP-DB] Date Conversion

2006-05-16 Thread Mark Bomgardner
m the form. When I go to format the month from a string to numeric with date('m',strtotime($sMonth1)); it returns 12, no matter which month I select. In reading the docs at php.net, date('m',strtotime($sMonth1)); is correct to reformat from a string to a time format. What a

[PHP-DB] Result set in different columns

2006-04-10 Thread Mark Bomgardner
nuaryFebruary March April MayJune JulyAugust September October November December Any ideas? Mark Bomgardner -- PHP Database Mailing List (http://www.php.net/) To unsubs

Re: [PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
now Im not sure how to call the individual fields. I've tried $usrreg['date']; but that doesn't seem to work. Do I need to use keys and values ? TIA Mark -Original Message- From: [EMAIL PROTECTED] Sent: Friday, April 7, 2006 4:14 PM -07:00 To: Mark Fel

[PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
rom a db. I tried this and while it returns no errors, it also returns no value. Am I defining wrong or pulling the values wrong ? TIA Mark __ Organize. Communicate. Share. @ http://www.goowy.com

[PHP-DB] MySQL Query Help

2006-03-23 Thread Mark Dyer
for the store to make asap. Php: if sale_period_total < min_level then email low order email. Any assistance to combine to the queries instead of hundreds of individual would be grateful. Regards Mark Dyer NZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL creating new tables using wrong engine...

2006-03-15 Thread Mark Benson
I have run into an issue where I keep getting InnoDB tables everytime I create a new table in PHPMyAdmin, and I want MyISAM tables. It's very annoying. Anyone got any suggestions as to what I might have done that made MySQL or PHPMyAdmin do this? -- Mark Benson http://homepage.ma

[PHP-DB] Mail Function

2006-03-01 Thread Mark Bomgardner
I have been racking my brain for the better part of a day with a simple mail function. I am trying to generate a list of events from MySQL and then use the php Mail function to email the list in an html email to a mailing list. I keep getting a parse error on a section that I can not figure o

[PHP-DB] Future Event

2006-02-20 Thread Mark Bomgardner
n for this, but I would perfer not, as I am writing an application in which cron may not be an option. Is there 3rd party engines that will do this? Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to compare crypted password with stored in MySQL

2006-02-01 Thread Mark Bomgardner
Eduardo Bejar wrote: Hi, I have a MySQL database with encrypted passwords, that were created with: $input_password = $_POST["password"]; $salt = "ab"; /// Salt is always two character string and the same for all $password_to_save = crypt($input_password, $salt); and then saved in MySQL with:

[PHP-DB] Date Formatting Question

2005-12-14 Thread Bomgardner, Mark A
tc., I have tried the following with no success: Date("F",strtotime($sDate)); Strftime("%B:,$sDate); Date("F",$sDate); I would use MySQL to format the date, but I have three date fields to modify and it would be easier to do it in PHP Any pointers would be appreciate

Re: [PHP-DB] MySQL 5 Stored Procedures

2005-11-03 Thread Mark Jordan
Thanks a lot. Ive just been reading them up on the MySQL website, and they seem really useful, so this really helps. Mark On 03/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > It is possible using PHP 5. Simply make a query like this: > > Select name_of_procedure(par

[PHP-DB] MySQL 5 Stored Procedures

2005-11-03 Thread Mark Jordan
Ive heard that mysql 5 now supports stored procedures. Can you call these from PHP? or is it too early to expect functionality already? Mark -- This message is best viewed with your eyes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HTML Tables in PHP...

2005-09-26 Thread Mark Jordan
boo ... short tags though i admit it's gotta be easier to type. Why I don't like short tags : I use XML a lot. Mark On 26/09/05, Micah Stevens <[EMAIL PROTECTED]> wrote: > > Rasmus, there's a shortcut for this: > > > > > > Saves me a lot of

Re: [PHP-DB] Getting Started..

2005-09-19 Thread Mark Jordan
Maybe you don't need the trailing semicolon after the phpinfo()? This is just a thought as sometimes you don't need it in the final php statement before the ?> tag. Mark On 20/09/05, Clint Lovell <[EMAIL PROTECTED]> wrote: > I'm just getting started here and I

[PHP-DB] Re: retrieving field names in ascending order

2005-09-10 Thread Mark Jordan
Does php have anything like the Visual Basic statement "Option Compare String" or "Option Compare Database" which controls how visual basic sorts strings like this.? If it does, then it might help *rushes off to check php manual* -- --- theExile.vze.com www.stpaulswalsall.com -- PHP Database

Re: [PHP-DB] Files stored in mysql

2005-08-17 Thread Mark Cain
licked reads the real file out to the browser such as header("Content-Type: application/pdf"); header("Content-Disposition: inline; filename=$file_access_name"); @readfile("$file_access_name"); . This is one way to do it. Of course you may want to read the files out of the dat

Re: [PHP-DB] Payment Gateways

2005-07-21 Thread Mark Cain
for a custom request string? what is the separator of the custom request? Then read the following: http://php.net/curl Mark Cain - Original Message - From: "Ahmed Shams" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 20, 2005 1:11 PM Subject: [PHP-DB] Payment Gateways

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
was by no means obvious from the documentation, by the way. But now the real fun begins...will the migration work? Stay tuned ~mark -Original Message- From: D.C. [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 4:23 PM Le 27 juin 05, à 21:23, Mark Galbreath a écrit : > Thanks for

RE: [PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
since PHP5 and PostgreSQL 8.0 have been released, there are many developers who have had to deal with this or a similar problem. ~mark -Original Message- From: D.C. [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 2:43 PM Le 27 juin 05, à 20:31, Mark Galbreath a écrit : > I h

[PHP-DB] PostgreSQL 7.2 - 8.0 replication issue

2005-06-27 Thread Mark Galbreath
PostgreSQL 7.2 server, I did a pg_dumpall > db.out and ftp'd db.out to the PostgreSQL 8.0.3 (DEV) server. When I attempt to pg_restore db.out, the PostgreSQL archiver aborts with the error: "input file does not appear to be a valid archive" I'd sure appreciate a clue on

Re: [PHP-DB] mysql check boxes

2005-06-24 Thread Mark Cain
but this should get you to the place where you can work it out. Mark Cain - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, June 24, 2005 5:25 AM Subject: [PHP-DB] mysql check boxes Dear Friends, I have mysql database and php script. Script pulls all the data with th

[PHP-DB] Problem with MySQL Extension

2005-06-23 Thread Bomgardner, Mark A
with imap, odbd and ldap which all show up with a call to phpinfo(), but mysql does not. I upgrade the php-mysql extension from 4.3.2-8 to 4.3.2-23, which is the most current rpm and still no luck. I now get the message that it can't find mysqli extension. Any ideas? Mark Bomgardner Techn

RE: [PHP-DB] PHP 4 to 5 Upgrade Issue

2005-06-23 Thread Mark Galbreath
Excellent, Gary! Typically, sitting there staring me in the face! Thanks a lot! ~mark -Original Message- From: Gary Every [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 4:12 PM To: Mark Galbreath; php-db@lists.php.net Subject: RE: [PHP-DB] PHP 4 to 5 Upgrade Issue I need to

[PHP-DB] PHP 4 to 5 Upgrade Issue

2005-06-23 Thread Mark Galbreath
Root /srv/www/htdocs ScriptAlias /* /srv/www/htdocs When I browse http://localhost:8181/ I always get the root (/index.html) instead of the alias (/php5/index.php). An

[PHP-DB] list test - ignore

2005-06-23 Thread Mark Galbreath
is this list alive? *** This email and any file transmitted with it may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. If y

Re: [PHP-DB] Com 1

2005-06-13 Thread Mark Cain
ot opened."; } else { $e = chr(27); $string = $e . "A" . $e . "H300"; $string .= $e . "V100" . $e . "XL1SATO"; $string .= $e . "Q1" . $e . "Z"; echo $string; fputs ($fp, $string ); fclose ($fp);

Re: [PHP-DB] Still having a form problem

2005-05-30 Thread Mark Cain
to show you how to do it) So, now your code will look like this: Now the array that is passed to page2 looks like this: _REQUEST["quantity"] Array ( [b54] => 1 [t3fl] => 2 [8956798] => 3 [A-E3600] => 4 [SA-8] => 5 ) Voila! SKUs and quanti

Re: [PHP-DB] Need some help

2005-05-11 Thread Mark Cain
You could use a form -- but since this is a db maillist -- maybe you ought to explore that on one of the other php lists e.g. general. Mark Cain - Original Message - From: "ReClMaples" <[EMAIL PROTECTED]> To: "Philip Hallstrom" <[EMAIL PROTECTED]> Cc

Re: [PHP-DB] Need some help

2005-05-11 Thread Mark Cain
output of phpinfo(); Mark Cain - Original Message - From: "ReClMaples" <[EMAIL PROTECTED]> To: "PHP" Sent: Wednesday, May 11, 2005 3:14 PM Subject: [PHP-DB] Need some help > Hello all, > >I am having an issue with displaying a variable from anothe

Re: [PHP-DB] URL question

2005-04-29 Thread Mark Cain
a 404 script is the way I would handle it. Modify what the server does when it finds a page that doesn't exist. Currently the server issues 404 headers and displays a brain dead message about not being able to find the page. Change that so that the server issues 200 headers (tricking the client

Re: [PHP-DB] mime-type related to extension?

2005-04-27 Thread Mark Cain
?extdetail=JPG you could also try http://www.jpeg.org/index.html Mark Cain - Original Message - From: "mel list_php" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 27, 2005 4:03 AM Subject: FW: [PHP-DB] mime-type related to extension? > Hi I sent this on 21st of apri

Re: [PHP-DB] SQL or array ?

2005-04-23 Thread Mark Cain
explain the phrase "big array." What is big to you might not be big to the server nor to me but then again maybe it's bigger. Are you talking dozens, hundreds, thousands, millions?? - Original Message - From: "Paul Reilly" <[EMAIL PROTECTED]> To: Sent: Saturday, April 23, 2005 5:05 PM S

Re: [PHP-DB] 'OR' logic in mySQL query

2005-04-17 Thread Mark Cain
complain with the use of "like" You ought to check out: http://dev.mysql.com/doc/mysql/en/where-optimizations.html Mark Cain - Original Message - From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Sunday, April 17, 2005 4:04 PM Subject: [PHP-DB

Re: [PHP-DB] using POST data for a readfile

2005-04-11 Thread Mark Cain
look for the var: _SERVER["HTTP_REFERER"] this will allow them to try to modify the url and you will know who is attempting it -- if you'd care to know that info. Mark Cain - Original Message - From: "mel list_php" <[EMAIL PROTECTED]> To: Sent:

Re: [PHP-DB] eregi problem

2005-04-03 Thread Mark Cain
the line." Without the $ as an end anchor the user would be able to put non-A/N characters at the end of the line of A/N characters and your code would not trap it. Mark Cain - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Sunday, April 03, 2005 11:18 AM Subject:

Re: [PHP-DB] File retrieval

2005-04-03 Thread Mark Cain
You could read this: http://php.net/fread or try this -- assuming that this is a non-windows OS: Mark Cain - Original Message - From: "Ron Piggott" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Friday, April 01, 2005 11:43 PM Subject: [PHP-DB] File retrieval

Re: [PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Mark Cain
Let me encourage you to be open minded about the use of dynamic PDF generation. Don't think PDF as in storage and downloading -- think PDF in the realm of format control. google class.ezpdf.php or just use this link: http://www.google.com/search?hl=en&q=class.ezpdf.php&spell

Re: [PHP-DB] Working with multiple tables...

2005-03-21 Thread Mark Cain
ng to do and that perhaps you understand what I am trying to do. Let me know if this needs clarification. Mark Cain - Original Message - From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: Sent: Monday, March 21, 2005 2:44 PM Subject: [PHP-DB] Working with multiple tables.

Re: [PHP-DB] undefined function error

2005-03-18 Thread Mark Cain
It could be possible that mySQL is not enabled in your installation of PHP. Let the server parse a page with phpinfo() in it and read the results. Look for mySQL enabled. Perhaps the reason it runs fine on another server is that the php on that server has mysql enabled. HTH, Mark Cain

Re: [PHP-DB] dynamic data manipulation in form

2005-03-18 Thread Mark Cain
You can try tinyMCE http://moxiecode.com/downloads_tiny_mce.php Mark Cain - Original Message - From: "Doug Finch" <[EMAIL PROTECTED]> To: "phpdb-list" Sent: Friday, March 18, 2005 4:42 PM Subject: [PHP-DB] dynamic data manipulation in form > I have a

Re: [PHP-DB] php and serial port

2005-03-16 Thread Mark Cain
You could try this code http://www.phpfreaks.com/quickcode/code/156.php I found it by doing this search: http://www.google.com/search?hl=en&q=php+serial+port Mark Cain - Original Message - From: "Rodrigo Cabeceiras" <[EMAIL PROTECTED]> To: Sent: Tuesday, Mar

Re: [PHP-DB] Error with "Where" Clause

2005-03-16 Thread Mark Cain
use backticks (read -- not single quotes, not double quotes, but backticks) to quote your fields such as where `1091vote038.state` = `109caucuses1.state` It is possible that the code is interpreting the "109" part of your table name as a integer. That just might do it.

Re: [PHP-DB] variable and MySQL

2005-03-16 Thread Mark Cain
first with concatenation. $question_pointer = $xxx . "_name_en"; $get_question_data[$question_pointer] Mark Cain - Original Message - From: "simon" <[EMAIL PROTECTED]> To: Sent: Monday, March 14, 2005 7:14 PM Subject: [PHP-DB] variable and MySQL > Hi, I&

[PHP-DB] Forms...

2005-03-09 Thread Mark Benson
Does anyone know if it is possible to have 'checkbox' elements in a form appear 'checked' or 'unchecked' when a page loads data from a MySQL data source? Can I use an attribute in the tag to switch that? -- Mark Benson AIM - SilValleyPirate MSN - [EMAIL PROTEC

[PHP-DB] Hyphens and MySQL

2005-01-28 Thread Mark Benson
p out with an error in the syntax. I can't get around it by putting a slash in front of them (using 'addcslashes'), it will just not at all accept them. Are they the 'wrong' type of slash? Is there an easy way to search and replace/remove characters in a st

[PHP-DB] Re: MySQL version issue

2005-01-05 Thread Mark Benson
imes one needs a new perspectiuve on these things, I was stuck in my mysql_query brackets. Putting mind to matter using your tips it would actually be fairly simple to do that. Again thank you for providing an exit() to my stuck loop ;o) -- Mark Benson http://homepage.mac.com/markbenson --

[PHP-DB] MySQL version issue

2005-01-04 Thread Mark Benson
L3 compliant substitute for the 'ON DUPLICATE KEY UPDATE' Query action? -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HTTP Auth for PHPMyAdmin

2004-12-23 Thread Mark Benson
all times from all points of access. -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HTTP Auth for PHPMyAdmin

2004-12-22 Thread Mark Benson
inc.php and setup some other system or can i use the grant tables from my MySQL server? Ideally I would want to log into the MySQL server as either my normal 'dbadmin' user OR 'root' as only 'root' has alteration rights on the grant tables so stuff that is out

[PHP-DB] HTTP Auth for PHPMyAdmin

2004-12-21 Thread Mark Benson
What do i need to do to enable proper HTTP authorisation for PHPMyAdmin? I enabled it in the config file, but it rejects my attempts to login. -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Mark Benson
s for the help on the 'ON DUPLICATE KEY UPDATE' thing, I didn't realise it was a new thing in MySQL 4.1.0! -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Spot the deliberate mistake...

2004-12-16 Thread Mark Benson
t do an update statement with the data already >provided". If I try that it returns: You have an error in your SQL syntax near 'ON DUPLICATE KEY UPDATE' at line 1 so I guess something doesn't work there. I also tried it with and without the line ending and it didn't work either way :). -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Spot the deliberate mistake...

2004-12-16 Thread Mark Benson
;$data[1]', alt_no='$data[2]', descript='$data[3]', price='$data[4]', unit_sale='$data[5]', unit_issue='$data[6]', weight='$data[7]', brand='$data[8]', nla_tag='0'" This is passed in a PHP script so the

RE: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Mark Benson
gt;then just grab all the data the first time through and put it where it >needs to go. OK, sounds like a plan... Sorry (again) about the code gaffs :-S -- Mark Benson http://homepage.mac.com/markbenson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Mark Benson
On Wednesday 24 November 2004 20:31, Mark Benson wrote: >> From the above code, >Actually the above code would result in a parse error. There are no >where-loops in PHP but there are while-loops. This is not being pedantic. If >you're going to post code, make sure it

[PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Mark Benson
p 2 returns a blank array, the output is simply "Array >()". If I remove the loop (by commentiung it out) that extracts $crab the >mysql $result array is suddenly full of the correct values. It seems to me >that loop 1 is destroying or somehow not resetting $result. Very odd...

[PHP-DB] Currency and number types...

2004-11-19 Thread Mark Benson
2) but that cuts off the trailing zero on numbers that comne out as, for example '12.10' or '12.00'. Does anyone know a way to force PHP to print numbers to a set number of significant figures (i.e. 2) and stop the trailing zero suppression? -- Mark Benson http://homepage.mac.

[PHP-DB] perl module to filter data to prevent SQL injection

2004-11-07 Thread Mark-Walter
Hello, I'am searching for a perl module to prevent SQL injection. Target is a simple logfile I need to analyse. I read the manpage from DBI where the function quote has been discussed, but not sure if this is the correct way. -- Best Regards, Mark -- PHP Database Mailing List

[PHP-DB] how to filter data to prevent SQL injection

2004-11-05 Thread Mark-Walter
Hi, I'am searching for a perl module to prevent SQL injection. Target is a simple logfile I need to analyse. I read the manpage from DBI where the function quote has been discussed, but not sure if this is the correct way. -- Best Regards, Mark -- PHP Database Mailing List

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

2004-11-02 Thread Mark Benson
'regular' users and also the 'root' user and it makes no odds. I've also tried dumping the list of single variables and using '($data[0], $data[1] etc...) and that has no effect. It's probably something glaringly obvious to an expert but as I say I'm l

[PHP-DB] Insert and Update on same page

2004-11-01 Thread Bomgardner, Mark A
n the record ID field. I can use the ID field together with another value to get the unique number that I want, but it would require a insert, select and update in one shot. Is this possible? I hope I have not confused everybody Mark A. Bomgardner Technology Specialist KLETC

[PHP-DB] Time Field

2004-10-28 Thread Bomgardner, Mark A
When creating a time field in MySQL, its purpose is for elapsed time, not time of day. Is it better to use this field or to combine it with the date field when looking at inserting the start date and time of an event? Mark A. Bomgardner Technology Specialist KLETC

[PHP-DB] Date Question

2004-10-27 Thread Bomgardner, Mark A
I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about this, but I keep getting an error message when I try to search the archives. I have looked at the manual, but I am not finding what I am looking for. Mark A. Bomgardner

Re: [PHP-DB] delete time related data inside a table within 1 hour

2004-10-26 Thread Mark-Walter
the right format but when I use INTERVAL 1 HOUR it deletes it immediately. The used column is date and time related 2004-10-24 07:42:34 and work's fine while using INTERVAL -1 DAY. -- Best Regards, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] delete time related data inside a table within 1 hour

2004-10-25 Thread Mark-Walter
ately. Maybe someone could help me at this point. -- Best Regards, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Importing Excel and Access data to MySQL

2004-10-08 Thread Bomgardner, Mark A
length. Mark A. Bomgardner Technology Specialist KLETC -Original Message- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 9:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Importing Excel and Access data to MySQL Simple question, How does one import excel and

Re: [PHP-DB] Error with addition of second

2004-09-18 Thread Mark
uters > > Also, you shouldn't have all of the radio buttons associated with the same variable checked. In fact, if this is a quiz, none should be checked. And this last question doesn't even make sense :-) > > Q-2)Once there is inflation ; > > Governme

Re: [PHP-DB] mysql_connect dies silently

2004-09-13 Thread Mark Boyle
If you have access to your php.ini file, take a look for the Error Reporting settings. It may be set to none, to to log the errors to syslogd or a file. Mark On Mon, 13 Sep 2004 12:48:33 +0200, Christian Schlaefcke <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I have a proble

Re: [PHP-DB] Insert Query PROBLEMS

2004-09-10 Thread Mark
27;,". "fname = '".$_POST['fname']."',". "lname = '".$_POST['lname']."',". "address1 = '".$_POST['addres

Re[2]: [PHP-DB] Re: Building A Web Site Search Engine Using PHP / mySQL

2004-09-08 Thread Mark Wylie
Joseph> are you saying Orase uses phpdig? No. Only that phpdig uses PHP & MySQL. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Building A Web Site Search Engine Using PHP / mySQL

2004-09-08 Thread Mark Wylie
http://www.phpdig.net/ Uses both PHP and MySQL. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php-db@lists.php.net is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

2004-08-05 Thread Mark
CLICK THE LINK SO HE CAN RECEIVE YOUR MAIL, and you won't have to > > do this again ;) > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

RE: [PHP-DB] LAMP

2004-08-03 Thread Galbreath, Mark A
SuSE 9.1 Pro Mark -Original Message- From: Gavin Amm [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 8:40 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] LAMP I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are ther

RE: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
Thanks, David - I'm doing that at this moment :-) -Original Message- From: David Orlovich [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 4:05 PM To: Galbreath, Mark A Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] PHP use in Federal Govt Mark, a Google search

[PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
help! tia, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   3   4   >