RE: [PHP-DB] MySQLnd support for ed25519

Mysql 8 is already the stable version and has been for a while. I for development use it on windows and its v8 -Original Message- From: Ruprecht Helms Sent: 08 September 2021 16:02 To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQLnd support for ed25519 Hi Dimi, I think mysql 8 is

Re: [PHP-DB] Debugger

Do you have xdebug installed? - "The cold winds are rising" On Oct 24, 2012 7:02 PM, "Ethan Rosenberg, PhD" < erosenb...@hygeiabiomedical.com> wrote: > Dear list - > > A. Is anyone aware of a debugger that: > > 1] will step thru the code, > 2] will stop at a point that input is requested [eg, for

Re: [PHP-DB] Re: php generators

d and no longer maintained? ;-) -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Wed, Apr 29, 2009 at 4:26 PM, Manuel Lemos wrote: > Hello, > > on 04/28/2009 01:40 PM conor mahaney said the following: > > Hello Everyone, > > > > I am a beginne

Re: [PHP-DB] php generators

eck it out at http://www.cakephp.org for more info -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Tue, Apr 28, 2009 at 12:40 PM, conor mahaney wrote: > > Hello Everyone, > > I am a beginner with PHP and Mysql and have dived into a project that may > be

Re: [PHP-DB] Bounty for PHP DB project

. -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Mon, Mar 23, 2009 at 12:12 AM, Jack van Zanen wrote: > Always willing to make a buck, but in all honesty I reckon if you use the > adodb libraries it will take you all of 20 minutes to create this yourself > as

Re: [PHP-DB] MySQLi not closing connections

I was thinking the same bug, except that I'm not using real_connect (pass login params when initializing the class), and also the issue only occurs when logging is enabled. I'm really at a loss here :-\ -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On W

Re: [PHP-DB] MySQLi not closing connections

', array_keys($activity_log)) . '`) VALUES ("' . implode('","', $activity_log) . '")'; mysql_query($sql); mysql_close(); } exit; } /* /Snippet */ ?> -- Jonathan Lang

[PHP-DB] MySQLi not closing connections

Hoping someone may have some insight. I'm a PHP developer for my current employer. Recently, a coworker and myself started revamping our PHP-based intranet to add more OO functionality and replace some of the repetitive procedural code that was in place. In this revamp, we also converted the majo

[PHP-DB] Re: Help with JOIN query

x27;t have any. Implicit (or explicit INNER) JOINs will not show you all of the data. Jonathan Crawford [EMAIL PROTECTED] Original message >Date: 6 Mar 2008 18:46:18 - >From: [EMAIL PROTECTED] >Subject: php-db Digest 6 Mar 2008 18:46:18 - Issue 3990 >To: php-db@

RE: [PHP-DB] Prevention for multiple submissions from the same form

I used the JavaScript method to disable the button after the first click and discovered from irate customers and administration that this resulted in an unsubmittable form on the AOL Browser although it worked perfectly in all others. Just a mention in case your clientele is AOL heavy (like ours).

[PHP-DB] Newly inserted record ID

Thanks to the help of this list, I am making great progress. Now this -- I have a multi-part submission form for a support application for us, the manufacturer - the reseller's information is submitted, the customer's information is submitted, then the warranty support information needs to be subm

[PHP-DB] Dynamic DataBinding in Form

I have an INSERT form with several fields two of which are FName and LName. There is also a field named CUSTOMER which is the concatenation of those two fields separated by a space. Is there a way to fill in customer as the user types in the other two fields. I used to do this in Coldfusion; can I

[PHP-DB] Session Variable from Recordset

What is the syntax for pulling a field out of a query and setting it as a session variable? Thanks, Jon -- Jonathan Gravois Omni Sports Technologies 800.529.6664 X125 http://www.omnisportstech.com Quote: "Failure is not the only punishment for laziness; there is also the success of o

[PHP-DB] Compiling PHP with IMAP and OpenSSL

ith-openssl=/usr/include/openssl' '--with-imap=/usr/lib/courier-imap' '--with-imap-ssl=/usr' '-enable-memcache=/usr/local/lib/memcache' -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] passing DOMDocument Object to another function

I am accessing information in my database. If the format is set to be html, I echo out the variables just fine. If the format is set to be xml, I create a DOMDocument. The problem is that in processing the result set, it calls several other functions. How do I pass the DOMDocument Object to t

[PHP-DB] format of mysqli returned array

Is there any documentation about how mysqli returns a result set? i use fetch_assoc on it and would like to write a result to a text file in the same format so that it could be opened at a later point and run through a while phrase. thanks, jonathan -- PHP Database Mailing List (http

[PHP-DB] what is the value of session_register

Is there any values to this function? I'm looking over some code where this is a done a bunch of time and I don't see any value to it. Maybe I'm naive about the internals but... -jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] reg expressions- please help!!!!!1

flight from London Gatwick to Manchester. etc can some help with some ideas or sql queries i can use to query my database and then provide an appropriate answer or response to eaach query Thank you in davance for your help -- Jonathan Trepczyk -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] NLP to SQL queries

hiya guys, just trying to find the best way of translating natural language queries to sql queries to put in a website, i will be glad if you can help or point me towards the right direction Thanks for your help Jonathan -- Jonathan Trepczyk -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] database connectivity problem

b@lists.php.net' Subject: Re: [PHP-DB] database connectivity problem Adams, Jonathan K. [C] wrote: > Here is the error: "Warning: sybase_connect() [function.sybase-connect]: > Sybase: Unable to allocate connection record > > My configuration - The database is Sybase ASE 12.0

[PHP-DB] database connectivity problem

Here is the error: "Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver is Apache 1.3.33 with PHP 5 running Solaris 9 The sybase libraries are shared via NFS, which

[PHP-DB] php database connectivity issues

Here is the error: "Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver is Apache 1.3.33 with PHP 5 running Solaris 9 The sybase libraries are shared via NFS, which

[PHP-DB] Cannot load module php_mysql.dll!!

I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It w

[PHP-DB] Cannot load module php_mysql.dl!!

I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It

[PHP-DB] super define...

Is there a way to use define so it replaces the constant even if it's inside quotes? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HTML stored in a text field

Gabe Covert wrote: I have a database which has a BLOB field storing text... It should probably be in a text field, but I don't think that's the problem... The field has HTML control codes, such as , , and . When I echo them from the database, a la: echo "" . $row['textfield'] . "" I get the conte

Re: [PHP-DB] Space requirements (with respect to foriegn languages)

(BOn Aug 26, 2004, at 12:27 PM, Gerard Samuel wrote: (B (B> My site/code/database is developed primarily for the english language. (B> I've had people from "The Far East" add content to my site using their (B> native language, and it is displaying properly in the site. (B> But Im a bit concer

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

use mysql_escape_string. http://us3.php.net/manual/en/function.mysql-escape-string.php Jon Ron Piggott wrote: I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now havin

Re: [PHP-DB] Timeout problem

can you just use a cron job and mysqlbackup instead? it does what you want and is already written. Jon Mauro Chojrin wrote: Hi: I'm developing a db application with php and I have this problem: I have a script for backup making which is very simple, it just goes through the entire database cre

Re: [PHP-DB] Begining PHP...Have Questions

ugging. I do have it set to = on a normal basis. I am a little unsure what you mean at the end of your reply about register globals. Are you saying that everywhere I use $username to refer to the users inputed username I should use $_POST['username'] instead? Or are you suggesting

Re: [PHP-DB] Begining PHP...Have Questions

if you have shell access, please do the following describe users; select * from users; also, why are you using LIKE instead of =? use this instead: $query = "SELECT * FROM users WHERE email = '".$username."'"; i would also suggest turning off register globals and using $_POST['username'] and not $

Re: [PHP-DB] Reducing Strings to a certain length

substr On Jul 18, 2004, at 9:48 PM, Cole Ashcraft wrote: How would you reduce a string to a specified length? Say reduce 600 to 60 or abc to ab? Is there a PHP function for this? Will I have to write my own code? Cole -- This message has been scanned for viruses and dangerous content by MailScanner

[PHP-DB] Security Issues

meone from writing to that folder? Jonathan Haddad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql auto increment

There might be some system that requires a 4 digit number and the PK is being used directly. Also, this same system might need to be exported to Excel, which trims leading zeros and is generally a pain in the ass. Peter Westergaard wrote: I've done exactly this for a really cheap-and-dirty ins

Re: [PHP-DB] problem....

Please post the table definition to the mailing list so we can help you more quickly. Also, is there a table called RuneRunner_1 or are you meaning to use RuneRunner_1 as an alias? Odds are, your problem is not PHP related, it's an error in your SQL syntax. Jon water_foul wrote: i fixed those t

Re: [PHP-DB] Re: datetime update

[EMAIL PROTECTED] wrote: Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with >the date and current time. can anyone point me ? Via PHP: $dateTime = date('Y-m-d H:

Re: [PHP-DB] Combining 2 queries into 1?

How about select count(*) from online Jon On May 30, 2004, at 1:23 PM, Kim Steinhaug wrote: I have theese two queries : select count(*) as online from online where uid=''; select count(*) as online from online where uid!=''; Each online user has a uid (UserID), so if their logged inn this field wil

Re: [PHP-DB] HTML mail

Set Content-Type: text/html in your headers And just enter in html as your body example $body = "\n the rest of your html "; mail($to,$subject,$body,$headers) get the picture? On Sun, 2003-11-02 at 19:20, Ronald Wiplinger wrote: > I got an interesting program to do: > > For a

[PHP-DB] PG and error handling

I have been looking for a resource on how to do proper error handling with (BPostgreSQL connections and queries. In one specific case, I have a (Breferential integrity constraint on a table. When I try to delete from that (Btable, it fails, as it should, when there is something referring to the

Re: [PHP-DB] Excel file into MySQL

right... I was just looking for a quick answer without having to look for it myself... (I tend to be a little self-centered sometimes, sorry) On Tue, 2003-09-30 at 13:29, Jason Wong wrote: > On Wednesday 01 October 2003 02:23, Jonathan Villa wrote: > > On Tue, 2003-09-30 at 10:31,

Re: [PHP-DB] Excel file into MySQL

On Tue, 2003-09-30 at 10:31, Jonathan Villa wrote: > Is it possible to transfer information from an excel file (33,000 rows) > into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Excel file into MySQL

Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Working query not able to run with PHP script.

Sorry, I meant referenced in another table not database On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote: > I have several tables I want to delete as well as their reference in > another database > > The query prod

[PHP-DB] Working query not able to run with PHP script.

I have several tables I want to delete as well as their reference in another database The query produced is this: === DROP TABLE xxx.zorder_47629403705b7e7f0c97387559d8c811; DELETE FROM orders WHERE table_name = "zorder_476294

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

: > El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: > > I believe this would need php to installed as a cgi, which I prefer not > > to do... > > If you don't want to because of security resons, please install it and don't > leave it in the hands of the web server.

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

/file.php > > Just a thought, > Ryan > > -Original Message- > From: Jonathan Villa [mailto:[EMAIL PROTECTED] > Sent: Monday, September 15, 2003 3:28 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? > > > > Inter

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

15 at 14:49, CPT John W. Holmes wrote: > From: "Jonathan Villa" <[EMAIL PROTECTED]> > > > > I have an application which creates temporary tables. My plan is to > > remove them after a 24 hour period and only those which are have a > > created time greater

[PHP-DB] Need to Run a PHP script using CRON or ?

I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull t

RE: [PHP-DB] Define()

Edwin, There is no $ in front of the vars because it's a constant. $ signifies a variable. A variable's value can change, a constant's value cannot. ---> Jonathan -Original Message- From: Edwin Boersma [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003

RE: [PHP-DB] Define()

Jim, I don't think that matters. One can escape into PHP in several ways (depending on the php.ini config of course) 1. Jonathan -Original Message- From: Jim Hunter [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:59 PM To: [EMAIL PROTECTED] Subject: RE:

RE: [PHP-DB] Define()

the event that my image directory changes or a directory changes from login to register, then I don't want to have to go into EVERY SINGLE page and line of code to change it. ---> Jonathan

RE: [PHP-DB] Define()

efine(IMG_HOME_ROOT, "/client_name/web/images/"); and it didn't work What would be the difference between using that and $img_dir = "/client_name/web/images/"; ---> Jonathan -Original Message- From: Jim Hunter [mailto:[EMAIL PROTECTED] Sent: Wednesday, M

[PHP-DB] Define()

I am developing an app which needs 3 constants. The value of these constants comes from a database result. This works fine. My problem is that they do not work very well. I am developing on both windows/Linux (depending what I boot into). This is the effect I want $doc_dir = the string of d:

RE: [PHP-DB] Easy array question...

Try it with the original array first, just for testing ---> Jonathan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:10 AM To: '[EMAIL PROTECTED]'; 'Hutchins, Richard'; [EMAIL PROTECTED] Subject:

RE: [PHP-DB] Easy array question...

Sorry, I just reread your post $array_copy = array(); array_push($array_copy, $original_array); echo $array_copy[0];//or whatever to test ---> Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:56 AM To: 'NIPP,

RE: [PHP-DB] Easy array question...

$array_copy = array(); array_push($array_copy, $_SESSION['original_array']); echo $array_copy[0];//or whatever to test ---> Jonathan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:43 AM To: 'Hutchins,

RE: [PHP-DB] Searchform to results.php

"SELECT .. FROM ".$_POST['searchtype']; I'm not to sure if this is just for easy ready, but I haven't too many instances where the query is in all caps. Anyone, does case matter in a query? ---> Jonathan -Original Message- From: [EMAIL PR

RE: [PHP-DB] How to access a MS Access DB

I believe I posted that thread. Try odbc_exec instead of odbc_prepare Let me know if have more problems ---> Jonathan -Original Message- From: Beverly Steiner [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:11 PM To: [EMAIL PROTECTED] Cc: Beverly Steiner Subject:

RE: [PHP-DB] Help with a query

ch is what I wanted to avoid, but I guess there's no other way Thanks for the quick reply. ---> Jonathan -Original Message- From: Paul Burney [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:06 AM To: [EMAIL PROTECTED]; PHP Database List Subject: Re: [PHP-DB] Help

[PHP-DB] Help with a query

er_id = $customer_id; -Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Customer id

Create a customer_id field in the database, make it primary, int, and autoincrement ---> Jonathan -Original Message- From: Dan Kelly [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 6:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Customer id How do I write a scr

[PHP-DB] phpMyAdmin

Ok, maybe this is strictly a phpMyAdmin Q, but I'm sure many of use it =) I have a server at home which runs phpMyAdmin. I also run it locally on my laptop. The cfg_uri for both is http://localhost/phpMyAdmin/ When I open a web browser (IE), I go to http://mydomainonmyserverathome/phpMyAdmin Th

RE: [PHP-DB] Storing an array in the database

Thanks! I checked out the php docs, serialize() returns a string containing a byte-stream representation of value that can be stored anywhere. Perfect! ---> Jonathan -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 10:43 AM

[PHP-DB] Storing an array in the database

How would I store an array in the database? I want to store 2 things. One array of shirt sizes and one array of which holds other arrays. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Processing Page

work if you could set the field being used as a point of a reference when the other process is running. ??? ---> Jonathan -Original Message- From: Aspire Something [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:56 PM To: php-db Subject: Re: [PHP-DB] Processing P

RE: [PHP-DB] Re: Processing Page

something like that, I know it involved 3 pages 1. please hold page 2. page to verify the status of the process, then redirect to #1 or else #2 3. final result ---> Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fredrik de Vibe Sent: Thu

RE: [PHP-DB] Re: Processing Page

I guess I was thinking of a "success only" scenario. If the backend never failed, then an easy Meta redirect would work, (if given enough time to process). However, in the "real world", assuming success is a foolish mistake. ---> Jonathan -Original Me

RE: [PHP-DB] Processing Page

http://yourpagehere";> 5 = time to wait ---> Jonathan -Original Message- From: John A DAVIS [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page What are the correct META tags? I cou

RE: [PHP-DB] Processing Page

http://yourpagehere";> 5 = time to wait ---> Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:10 PM To: 'Aspire Something'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page You could do t

RE: [PHP-DB] Processing Page

f on WinXP ---> Jonathan -Original Message- From: Aspire Something [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Processing Page Hi all, Permit me to recive your valuable knowledge , We are working on a project where the b

RE: [PHP-DB] Get MySQL table schema for a dump

I never thought of mysql_fetch_row. What I ended up using was $row = mysql_fetch_array($result_id); echo $row[1]; I'll probably use fetch_row as it makes more sense. Thanks. ---> Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent:

Re: [PHP-DB] php-dbase on RedHat 8.0

That's odd. I haven't tried 4.3.1, but I do have 4.3.0 running on apache 2.0.44. I'll try 4.3.1 today and see if I come across anything. At Thursday, 27 February 2003, Roger Boily <[EMAIL PROTECTED]> wrote: >Hi, >I have upgrated to RedHat 8.0 that unfortunatly "downgrade" my working >php 4.

RE: [PHP-DB] Get MySQL table schema for a dump

sql,$connection); then what, if (mysql_num_rows($res...)) ??? or while ($rows = mysql_fetch_array()...) ---> Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:49 PM To: [EMAIL PROTECTED]; [E

RE: [PHP-DB] Re: Get MySQL table schema for a dump

Sorry, I should have explained that I want to do this via PHP. ---> Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fredrik de Vibe Sent: Wednesday, February 26, 2003 5:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Get MySQL ta

[PHP-DB] Get MySQL table schema for a dump

x,x,x,) VALUES(x,x,x); INSERT INTO table (x,x,x,) VALUES(x,x,x); INSERT INTO table (x,x,x,) VALUES(x,x,x); etc. but what I'm missing is CREATE table blah, blah, blah **that is what I want to get. -Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

[PHP-DB] Issue with this particular SQL query construction

I have two tables. Table_1 contact_id (INT 5) Table_2 contact_id (INT 5) type (enum '1','2') data (TEXT) In table_2, there is a possible of two records that can be associated to an entry in table in the form of the record type can be an either 1 or 2. There will always be a type 1, but not nece

[PHP-DB] RE: your odbc problem can be solved

e to create a new RecordSet class and pass it a query. I'm pretty hard pressed for time and have not found the "right" info on the web which is why I am asking what I am asking. Thanks in advance. ---> Jonathan -Original Message- From: John A DAVIS [mailto:

RE: [PHP-DB] How to access a MS Access DB

d. I'm not to sure how to set this up to work with PHP ---> Jonathan -Original Message- From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 3:38 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] How to access a MS Access DB to set

[PHP-DB] How to access a MS Access DB

I need to know exactly how to hook up to an Access database under Office Xp. I normally use MySQL, but the current site sits on Windows servers. I am using php 4.3.0 Office Xp Pro w/ Access I'm running Apache 2.0.43 I need to know how to check if ODBC is set up on my machine (I hear that by def

RE: [PHP-DB] passing variables

One of many possible things. Dependent on the version of PHP you are using, you might have register_globals set to off in your php.ini file, which is preferable. In which case you'll have to use If($_REQUEST['variable']) Or If(isset($_REQUEST['variable'])) Second possible is: I've never reall

RE: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

onvenient. Ignatius - Original Message - From: "Jonathan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 10:00 PM Subject: [PHP-DB] CREATE TABLE QUERY PHP/MySQL > This is the first time I am trying to create a tabl

[PHP-DB] CREATE TABLE QUERY PHP/MySQL

t whether the table has been created or not. I know I could probably do some sort of mysql_list_tables and look for it or whatever but I was looking for something similar to If (mysql_affected_rows() == -1) Because that is very easy. And ideas as to why the table is not being created. ==

RE: [PHP-DB] RE: regarding multiple joins

that worked perfectly! thank you so much! -jon -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:08 PM To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB Subject: Re: [PHP-DB] RE: regarding multiple joins At 05:26 PM 11/22/02

[PHP-DB] RE: regarding multiple joins

ther complex JOIN but i'm not sure how it looks exactly. any help would be appreciated. thank you very much. -jon -Original Message- From: David Elliott [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 2:18 AM To: Jonathan Narong on PHP-DB Subject: Re: regarding multiple

[PHP-DB] RE: inserting html into mysql tables

5k of data is way too much for varchar, so i would use a field of type TEXT. i do this as well (storing html data in mysql) and it works great. some say to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes automatically - not sure exactly why that is though. -Original Me

[PHP-DB] regarding multiple joins

this is a problem i've been struggling with for a little while. any attempt to find help online has not produced any useful information. this is regarding joins, which i'm not an expert in, but hopefully one of you can help me out. i have an table 'articles' which has multiple fields, such as auth

RE: [PHP-DB] creating a new mysql automatically every day?

John, That is good advice. I wasn't aware of indexes/keys slowing down inserts. Whats the best way to copy a table over to another table though? -jon -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 5:36 PM To: 'Jonathan Naron

[PHP-DB] creating a new mysql automatically every day?

i'm currently building a traffic analysis application for a website. it is my first time working on such a project, so i'm not even sure if this would be the best way to do it all, but here it goes. what i would like to do is count the number of hits that go to different sections of the site. i ca

[PHP-DB] checking for 0 results?

maybe i'm totally not thinking straight right now, but is there a way in php to check if 0 results are returned in a mysql query? for example, i have a definition database, that has a list of letters the user clicks on (click on the letter, and all the terms for that letter pop up).. but for some

[PHP-DB] RE: date questions in mySql

yes, you need to insert the date as -mm-dd. you can go around this and still have the user see a form field with mm/dd/ but you need to break each part down, and play with the string functions so the final mysql query is in -mm-dd. -jon -Original Message- From: Paul Ihrig [mai

[PHP-DB] RE: Displaying a single picture...

not sure i understand why you would need to use a php script for this? why not just use a static html tag, if all you're doing is opening the picture in a new window? -jon -Original Message- From: Brett Lathrope [mailto:brett@;lathrope.com] Sent: Tuesday, November 12, 2002 1:44 PM To: [E

[PHP-DB] Re: Multi-Dimensional Arrays

gt; $cartArray[1]["Quantity"] = $itemqty; > $cartArray[1]["ItemName"] = $itemname; > > Note that $cartArray[] = $val is just a short hand way of doing > array_push($cartArray, $val); > > Cheers, > > Owen Prime > http://www.noggin.com.au > > > > J

[PHP-DB] Multi-Dimensional Arrays

;"; $brand="Brand2"; $itemnumber="123456"; $itemname="Another Item Name"; $itemqty=9; array_push($cartArray, array($itemnumber=>"$brand", "$itemqty", "$itemname")); print_r($cartArray).""; echo $cartArray[0][0].""; Thank you, Jonathan Duncan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Are running sessions using a MySQL handler faster?

Good afternoon! Quick performance question - I'm currently preparing the release of a new website running on a Linux box written in PHP and MySQL with sessions throughout. I've read a bit about changing the PHP session handler to use a database vs. the flat file method. Does anyone have experie

[PHP-DB] "resource ID #3"

7; command to the mysql que. Then, I have a second database which matches each abbreviation with the proper name. When I try to run any query on the second database, the only output I recieve is "resource id #3" Any suggestions? Jonathan -- PHP Database Mailing List (htt

[PHP-DB] A challenge

an html form. Any suggestions?? Deeply appreciated. Thanks. [EMAIL PROTECTED] -- Jonathan

[PHP-DB] retrieving all information from a single table

table has 4 fields, the primary key, "location," "organization," and "charge." Any suggestions? A million thanks. Here is the code: "; echo $row[i["location"].""; echo $row[i]["charge"]; } } ?> -

RE: [PHP-DB] page expires

http://php.sitecreative.com/faq.php -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:12 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] page expires Hi to all, I have form that users fill out and submit. What I'm trying to do is not to

RE: [PHP-DB] appending new entry to old entries

= 5, and append "Appended Text" to the end of MyField without a query to get the previous values. For numeric fields, you can also increment them like this: UPDATE table SET MyNumericField = MyNumericField + 1; That would update all rows in table, incrementing every row's MyNumeri

[PHP-DB] PHP to Fax

work well with scripting? #2 Does anyone know about fax servers or how to obtain one? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   3   >