[PHP-DB] Requesting a feature change to PHP mysqli

2024-01-27 Thread John Wythe
, by exposing the above parameters separately in mysqli PHP. John Wythe Software & Systems Engineer Epicor Software Corporation www.epicor.com<http://www.epicor.com/> Ph: 250-260-6495 TF Support: 800-678-7423 E-Mail: jwy...@epicor.com Support E-Mail: silksupp...@epicor.com<mailto:silksupp.

RE: [PHP-DB] what does the mysqli real connect MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag do? How to disable only CN validation?

2023-03-23 Thread John Wythe
need to pass a context, and I don’t think $dsn gives me access to the context. It maybe too late in the sequence of events to change any of that. I was thinking of doing a context get, and a context set, i John Wythe Software & Systems Engineer Epicor Software Corporation www.epicor.com&

[PHP-DB] what does the mysqli real connect MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT flag do? How to disable only CN validation?

2023-03-22 Thread John Wythe
at? John Wythe Software & Systems Engineer Epicor Software Corporation www.epicor.com<http://www.epicor.com/> Ph: 250-260-6495 TF Support: 800-678-7423 E-Mail: jwy...@epicor.com Support E-Mail: silksupp...@epicor.com<mailto:silksupp...@epicor.com> Support portal: https://epicorcs.service-

[PHP-DB] Getting PDO-OCI to work in PHP 7

2019-05-28 Thread Stokes, John M via php-db
dap.h:27:0, from main/internal_functions.c:50: /usr/include/lber.h:335:1: note: previous declaration of ‘ber_scanf’ was here ber_scanf LDAP_P(( ^ make: *** [main/internal_functions.lo] Error 1 Can anyone offer me some ideas? Thanks in advance. -John -- John Stokes – Certif

[PHP-DB] PHP 7 and sqlsrv

2015-04-10 Thread John Hermsen
I was wondering if there is anyone who manager to compile the sqlsrv driver for php 7. I have tried, but I haven't been able to get it compiled yet. Thanks, John

Re: [PHP-DB] auto creation of email IDs

2009-12-19 Thread John Black
configuration files (dedicated server or virtual server). Configure your email demons to use a mysql database to store the account information. Now you can use php to create new email accounts. -- John You may say I'm a dreamer, but I'm not the only one, I hope some day you'll join us, And the world

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread John Black
then the one coming with XAMPP. But I never bother to find out why because I had full access to MySQL and could just create an account with the old password system. -- John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] adding a simple WHERE clause to this MySQL query causes the result to contain 0 rows?!

2009-08-10 Thread John Butler
is this, and where to install/ learn about it, and why- phpMyAdmin (3.2.0.1) John Butler (Govinda) govinda.webdnat...@gmail.com

Re: [PHP-DB] PostgreSQL query many escape characters?

2009-05-02 Thread John DeSoi
message you are seeing? John DeSoi, Ph.D. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HELP! PHP 4.4.4 and MySQL 4.1 - Can't find php_mysql.dll

2009-02-18 Thread John Burns
the older version? Thanks in advance for the help! John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2007-10-04 Thread John A DAVIS
left join where item in right table is null "Chris" [EMAIL PROTECTED] 10/3/2007 10:32:01 PM Aleksandar Vojnovic wrote: I would also suggest to limit yourself to things you actually need not to select the whole table.In this case you can't because you're looking for records that exist in

Re: [PHP-DB] showing warnings

2007-09-10 Thread John Mertic
Run the query through MySQL directly prepending EXPLAIN to the query and attach the results here. John On 9/10/07, Asim [EMAIL PROTECTED] wrote: Hi i have added index on both columns but still same warning is issued by mysql then what i do now John Mertic [EMAIL PROTECTED] wrote

[PHP-DB] mysql error...

2007-08-28 Thread John Pillion
, MaxParking, P' at line 1 I cannot find a thing wrong with this... any ideas what may be the problem? All the data types are either int(11) or varchar(50). John INSERT INTO tblBuildings (SiteID, Name, Available, MfgWHSqFt, OfficeSqFt, TotalSqFt, MinSqFtAvailable, MaxSqFtAvailable, Condition

Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding UTF8

2007-07-21 Thread John DeSoi
. It does not mean that PHP has set the right one. Before running your test, try executing this: SET client_encoding TO LATIN1; and see if that fixes it. John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] [PHP] Cannot connect to an MySQL database using Named Pipes (resolved)

2007-05-16 Thread John Comerford
- Original Message - From: John Comerford [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, May 16, 2007 11:05 AM Subject: [PHP-DB] [PHP] Cannot connect to an MySQL database using Named Pipes Hi Folks, I have a MySQL database running on Windows XP, that I want to disable

[PHP-DB] [PHP] Cannot connect to an MySQL database using Named Pipes

2007-05-15 Thread John Comerford
Hi Folks, I have a MySQL database running on Windows XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like... [client] #password= your_password port= 3306 socket= /tmp/mysql.sock [mysqld] #port

Re: [PHP-DB] debugging pg_connect

2007-04-29 Thread John DeSoi
. John On Apr 26, 2007, at 4:26 AM, [EMAIL PROTECTED] wrote: Hello, since we upgraded to the latest php and PostgreSQL - we started to get frequent pg_connect() errors. What is sure is that they are not caused by insufficient connections - PostgreSQL reports 100 connections available

Re: [PHP-DB] Fatal Error: Class 'mysqli' not found in...

2007-02-19 Thread John Comerford
Have you tried using phpinfo() to make sure it's seeing your php.ini file ? Ralph E. Brickley wrote: Hello All, I have been using Apache 2, PHP5 and MySQL 4 and 5 for a long time, and recently had to wipe my box due to a virus! Now that I have everything reinstalled, I can NOT get

[PHP-DB] indexing error - key length not specified

2007-02-09 Thread John Pillion
I am trying to set an index on a field in my table, but am getting the following error: BLOB column 'ReadBy' used in key specification without a key length The fieldtype is blob, though I get the same error whether blob or text, or the medium and long versions of each. My first

RE: [PHP-DB] indexing error - key length not specified

2007-02-09 Thread John
as to what type to use that wouldn't be variable length, but be able to store strings/values of that size? Thanks! John -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 6:29 PM To: John Pillion Cc: php-db@lists.php.net Subject: Re: [PHP-DB] indexing

Re: [PHP-DB] How to tell if a field type is auto_increment

2007-02-03 Thread John L. Creed
Ahhh, thanks. I'll do that. -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210 * http://www.pcexpressway.com * Niel Archer [EMAIL PROTECTED

Re: [PHP-DB] How to tell if a field type is auto_increment

2007-01-30 Thread John L. Creed
); if( $row[Extra] == auto_increment ){ $breturn = 1; } mysql_free_result($result); return $breturn; } Thanks again!!! -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210

Re: [PHP-DB] How to tell if a field type is auto_increment

2007-01-29 Thread John L. Creed
Thanks a Million my Friend. I've been struggling with this for days now grin -- Regards, John L. Creed pcExpressWay Consulting * dBASE Gold Charter Member 210 * http://www.pcexpressway.com

Re: [PHP-DB] CURL and process not finishing

2007-01-06 Thread john
: private Content-Type: text/html; charset=utf-8 Content-Length: 59347 ...and there it stops every time. Is this a script time out, as it stops while looking at the site it is finding OK? John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] CURL and process not finishing

2007-01-05 Thread john
a reasonable time? John

Re: [PHP-DB] Limited number of database results

2006-12-13 Thread John Meyer
Niel Archer wrote: Hi use a LIMIT clause in your SQL. Something like: $query=SELECT * FROM WHERE hello = '$hello' LIMIT . ($page - 1) * $rows . , $rows; then you only need specify the logic to set the page, row and limitations You also typically need to use the mod operand

Re: [PHP-DB] simple issue

2006-11-21 Thread John Comerford
You'll have to supply more information a) code sample b) error message Chris Carter wrote: Hi, I am new to PHP, just trying a peace of code to access mySQL database to fetch and show result on web page. But getting errors. Can you help me with this code please. Or if you have a very basic

Re: [PHP-DB] simple issue

2006-11-21 Thread John Comerford
I'm pretty new to this stuff myself but try this: while ($row = $result-fetch_array()) { $compname=$row[CompanyName]; $conname=$row[ContactName]; echo trtd$compname/td; echo td$conname/td/tr; } Chris Carter wrote: my code: html body ? $username=chris; $password=carter;

Re: [PHP-DB] Help Needed!!

2006-11-08 Thread John Meyer
Forgive me for saying this, but you should be posting this to the Oracle mailing list, not here. David Skyers wrote: Hello, I have an input field that inserts data into an oracle table. The users of the system will be composing the data that goes into this input field in Microsoft Word.

RE: [PHP-DB] Can you recommend Australian LAMP web hosting service?

2006-08-10 Thread John Meyer
BTW, not to shill, but if somebody needs a free LAMP system, you can go to http://www.110mb.com -Original Message- From: Miles Thompson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 5:56 AM To: PHP DB Subject: Re: [PHP-DB] Can you recommend Australian LAMP web hosting

[PHP-DB] Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread John Meyer
Wouldn't this: $id = mysql_insert_id(); $query = UPDATE tablename SET id= . ($id + 1); $result = mysql_query($query); Be a little simpler. But like I said, I'm confused over the need for this in the first place, seeing as how an auto_incremented primary key is self-descriptive. or are you saving

[PHP-DB] Re: [PHP] Class ADODB - Method GenID() in MySQL

2006-07-19 Thread John Meyer
Sorry, this should have gone to PHP-general, my bad.

Re: [PHP-DB] detecting negative numbers

2006-07-17 Thread John Meyer
Dave W wrote: No, I get it. I just thought that there might have been some built in function like if(neg_num($quant - $amount)) or something like that. I know how to do it, but I thought that there might have been an alternate method. Just because I asked a simple question doesn't mean I'm

[PHP-DB] Chinese characters

2006-06-07 Thread John Meyer
Is there any way to filter out Chinese or Asian characters from what I get from this list? I understand that there are a lot of intelligent, well-meaning Asians on this list but my system seems to get Montezuma's revenge when I look at those e-mails. -- Online library --

Re: [PHP-DB] Linux Commands

2006-06-03 Thread John Meyer
Manoj Singh wrote: Hello All, Is it possible to run the Linux Commands through php functions or code? If anyone knows, please help me out. Regards Manoj http://www.php.net/exec BTW, this is very risky and exposes your server to attacks. Try to find an alternative first before you let

Re: [PHP-DB] PHP/Mysql search

2006-05-22 Thread John Hicks
Miguel Guirao wrote: CREATIVITY is what you are looking for. What do you mean by CREATIVITY? -J -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be

[PHP-DB] PostgreSQL function call model for PHP

2006-05-17 Thread John DeSoi
A short article on using a class to call PostgreSQL functions: http://pgedit.com/resource/php/pgfuncall Comments and suggestions welcome! John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Adding url to google

2006-05-12 Thread John Hicks
Manoj Singh wrote: Hi all, I am developing the site using php and mysql. I have to add the url at google site through php code. If any one have idea about it, please help me. PHP is server-side technology. Google will never see it. The matter of placing your site in a search engine is a

Re: [PHP-DB] preg_replace help!

2006-05-03 Thread John Hicks
Nathan Heaps wrote: I am trying to parse a forum post using php, but it parses it everytime it sees the letter, not the thing in quotes. What letter? What thing in quotes? -J -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Example of mail()

2006-04-29 Thread John Hicks
Renzo Clavijo wrote: I know it's very simple but the question is: How can I erase the values held in $_REQUEST such that when I press F5 or I click Reload there are no messages sent again? ?php if(isset($_REQUEST['send_mail'])){

Re: [PHP-DB] capture a webpage to later process it

2006-04-29 Thread John Hicks
John Hicks wrote: J. Alejandro Ceballos Z. -JOAL- wrote: I want to read the results of an URL address, to later process it and insert part of them as internal code. If I use include or require, they inserts ALL the resulting code, but I want to do something like: blah, blah, blah

[PHP-DB] Re: Sheduled task for Php-MySql script

2006-04-28 Thread John Ellingsworth
/features.commandline -- Regards, John Ellingsworth http://john.ellingsworth.org -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] capture a webpage to later process it

2006-04-28 Thread John Hicks
J. Alejandro Ceballos Z. -JOAL- wrote: I want to read the results of an URL address, to later process it and insert part of them as internal code. If I use include or require, they inserts ALL the resulting code, but I want to do something like: blah, blah, blah ?php $result_webpage

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread John Hicks
) . dunno Do a select directly from the mysql console (bypassing php) to verify that the data is really truncated in the db and not in the output process (per Martin's suggestion. --John 2006/4/25, Skip Evans [EMAIL PROTECTED]: Hello all, I'm brand spanking new to the list and have a quick

Re: [PHP-DB] Sending multiple items via a single form field

2006-01-30 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hayri wrote: can somebody tell me what the hell does mysql_fetch_assoc do ??? thx It fetches a row of a result as an associative array (hash), the same as mysql_fetch_array($retval,MYSQL_ASSOC). -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2

Re: [PHP-DB] Limit chars from select

2006-01-29 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gavin Amm wrote: I'd like to avoid having to manually add all of the cols to the select statement if possible, so if there's a universal command I can put in that'd be best. In that case, what I would do is just do your SELECT statement, sans the

Re: [PHP-DB] database for books question

2006-01-21 Thread John Meyer
Flint Million wrote: Now I want to be able to do a subject listing as well as a search. For example, if I asked for a lsit of all subjects, I want something like: Nonfiction (2) PHP (1) Technology (2) Computers (1) Programming (1) History (1) Linux (1) In database design, I'd almost

Re: [PHP-DB] database for books question

2006-01-21 Thread John Meyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Flint Million wrote: Good idea. OK so I'll create a new database with subject ID's. Now, back in the primary database, how can I have multiple subjects assigned to one book? Let's say I repeat my above example and we assign Nonfiction to 1,

Re: [PHP-DB] Storing Credit Cards, Passwords, Securely, two-way encryption

2006-01-05 Thread John Meyer
Peter Beckman wrote: So I'm thinking about how to save credit card numbers in the DB, for re-charging cards for subscriptions, new orders, etc. Why, is the first question I would ask you. First off, on a new order, why wouldn't you just save the authorization code, instead of the credit

Re: [PHP-DB] isset or ! isset what is my problem?

2006-01-02 Thread John Meyer
On Monday 02 January 2006 8:54 pm, Ralph wrote: I'm building a URL based on data extracted from mySQL and I want the text space.gif used as my default value should the variable $picture by NULL. The results of the code below kick back a value for $picture when it is set in the database, but

[PHP-DB] Re: [PHP] To the person who told me about HTMLdoc

2005-12-28 Thread John Meyer
On Wednesday 28 December 2005 7:27 am, Rory Browne wrote: It'd probably be handier to use the continious file. htmldoc can be used as a gui app, so if you don't want to read the instructions, then that would probably be handiest. No I want to read the instructions. And how many pages should

[PHP-DB] Re: [PHP] PDF documentation

2005-12-27 Thread John Meyer
On Tuesday 27 December 2005 2:00 am, Rory Browne wrote: /me thinks that the OP needs to DL the html.gz manual, procure htmldoc, chant the magic incantation(i.e. type in the correct command), and wait for his PDF document to appear. okay, I'll bite, what the hell is htmldoc -- Dr. Joseph

[PHP-DB] Re: [PHP] Varchar date to real date?

2005-12-27 Thread John Meyer
On Tuesday 27 December 2005 7:01 am, William Stokes wrote: I think I need some help/ideas with this... If I can get this done how can I still display the dates in european format at my web page? Do I have to break the date to pieces and some how re-arrange it to the DD.MM. format or is

[PHP-DB] To the admin

2005-12-27 Thread John Meyer
[EMAIL PROTECTED] is bouncing e-mails. -- Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar? Fletch: I don't know. I don't have any. Dr. Joseph Dolan: No children? Fletch: No, elephant books. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Re: [PHP] load testing tools

2005-12-27 Thread John Meyer
On Tuesday 27 December 2005 1:13 pm, [EMAIL PROTECTED] wrote: Oh boy.. here we go.. hah.. can we refrain from a giant anti-Microsoft war type thing? Just making a joke about the anti-Microsoft feelings out there. -- Dr. Joseph Dolan: Isn't there a children's book about an elephant named

[PHP-DB] Re: [PHP] PhP

2005-12-27 Thread John Meyer
On Tuesday 27 December 2005 4:07 pm, James Lumb wrote: Hi, Does anyway know whether there is a PHP function which creates a new file? i know there is fwrite, fopen etc but is there any way of creating a new file? Thanks, James fopen() will create a new file if you open it for writing and it

[PHP-DB] Re: [PHP] insert to DB

2005-12-26 Thread John Meyer
On Monday 26 December 2005 6:40 pm, adriano ghezzi wrote: pls could you point out which instruction should insert record in db thanks... 2005/12/18, Anasta [EMAIL PROTECTED]: $sql = UPDATE leaderboard SET Name='$Name', Rating='$Rating' WHERE ID=$id; Um, do you have the option turned on

Re: [PHP-DB] Inserting a php file into a mysql database

2005-12-25 Thread John Meyer
On Sunday 25 December 2005 3:01 pm, Thomas Bonham wrote: Hello, I am trying to insert a php page into a database. I need to know if there is something that I need to do when setting up the table, also is there something to do with the code. Thank You for your help Thomas Well, you could

Re: [PHP-DB] Scrolling News

2005-12-22 Thread John Meyer
On Thursday 22 December 2005 1:38 pm, Alex Major wrote: Hi there. I'm trying to make a scrolling news box for my website. Basically I would like this news box to get information from a column in my database called 'news_title' and display it in a scrolling news box. The reason I'd like it to

[PHP-DB] Re: [PHP] pg_fetch_object

2005-09-24 Thread John DeSoi
' not 'pg_fetch_object'. Thanks much, John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] pg_fetch_object

2005-09-23 Thread John DeSoi
to the constructor, but it does not appear to be called. Has anyone successfully used this to create a class other than stdClass? Thanks, John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] pg_connect gets fatal error

2005-08-18 Thread John DeSoi
in these matters. Look at the Configure Command in phpinfo(). It should have the flag --with-pgsql. One of the easiest ways to get PHP/PostgreSQL going on the Mac is to use this installer: http://www.entropy.ch/software/macosx/php/ John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL

Re: [PHP-DB] Postgre SQL query error with PHP

2005-07-02 Thread John DeSoi
don't have permission to select from the property table. See the GRANT command and make sure you have the correct permissions to work with the table. The warning needs to be fixed also. The pg_num_rows command only takes one parameter. You need to remove the $dbconn parameter. John DeSoi

Re: [PHP-DB] Postgre SQL query error with PHP

2005-07-02 Thread John DeSoi
. http://www.php.net/manual/en/function.pg-fetch-row.php And if that does not help try just printing out the entire array so you know what is there. See the var_dump function: http://us2.php.net/manual/en/function.var-dump.php John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL

[PHP-DB] MySQL Functions Installation

2005-06-26 Thread John Jairo Vega Angulo
Ok here's a dummy question from yet another newbie: Reading the instructions for enabling the MySQL Functions, I understood until i get to this: For compiling, simply use the --with-mysql[=DIR] configuration option where the optional [DIR] points to the MySQL installation directory. i have a

[PHP-DB] Call to undefined function oci_

2005-06-19 Thread John Cecere
: Call to undefined function: oci_close() in /opt/ct/htdocs/costtool/access.php on line 3 Can anybody tell me what might be the problem ? I see nothing in the documentation that would indicate I'm missing anything, yet it still won't work. Please respond directly. Thanks, John I've just

[PHP-DB] More problems with a script. How to I get to a next entry

2005-05-19 Thread John R. Sims, Jr.
case note, and most of the clients will have several case notes that have been entered over the period of the program. Can anyone offer any suggestions. Keep the faith John html head titleWireless Neighborhoods/title /head ?php // Set the page title and include the HTML header

[PHP-DB] Showing the next entry

2005-05-16 Thread John R. Sims, Jr.
client in the case_note table. Can anyone point me in the right direction. Keeping the faith in fatherhood John

[PHP-DB] looking pgEdit beta testers

2005-05-15 Thread John DeSoi
Hi, The latest beta release of pgEdit 1.1 includes support for PHP. If you use PHP and PostgreSQL, I would be very interested in your comments and feedback. Changes since pgEdit 1.0 are summarized here: http://pgedit.com/node/view/30 John DeSoi, Ph.D. http://pgedit.com/ Power Tools

[PHP-DB] problems with a script

2005-05-12 Thread John R. Sims, Jr.
to change my script? JOHN

RE: [PHP-DB] problems with a script. .

2005-05-12 Thread John R. Sims, Jr.
Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? Keep the faith John html head

[PHP-DB] Getting information on ICQ

2005-05-07 Thread John R. Sims, Jr.
I understand that there is a support group for newbie's on ICQ. Can anyone direct me as to how I can get on that list. thanks John

[PHP-DB] Looking for help.

2005-05-04 Thread John R. Sims, Jr.
on line that I can use to learn more about these programs. Thanks John

RE: [PHP-DB] Sorting multidimensional arrays from mysql

2005-05-02 Thread John R. Sims, Jr.
the faith in fatherhood John _ PHP script ?php //connect to database $conn = mysql_connect(localhost, root, becky) or die(mysql_error()); mysql_select_db(testDB,$conn) or die(mysql_error

[PHP-DB] Problems with a script

2005-05-02 Thread John R. Sims, Jr.
?php if (($_POST[op] != add) || ($_GET[master_id] != )) { //haven't seen the form, so show it $display_block = h1Add an Entry/h1 form method=\post\ action=\$_SERVER[PHP_SELF]\; if ($_GET[master_id] != ) { //connect to database $conn = mysql_connect(localhost,

[PHP-DB] MySQLi group

2005-05-02 Thread john
Caio, I have started a new Google group for those of us here that may run into issues specifically with MySQLi in PHP5. http://groups-beta.google.com/group/MySQLi Regards, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Newsgroup?

2005-04-26 Thread John Swartzentruber
On 4/26/2005 2:56 PM Nhan wrote: I seek for a MySQL newsgroup, can anybody help me? Martin If you really want a newsgroup and not the mailing lists, you can get them at gmane.org. The general list is gmane.comp.db.mysql.general, but there are others as well. -- PHP Database Mailing List

[PHP-DB] Query that generates href links

2005-03-20 Thread John Burroughs
myphpadmin to manage my MySQL database.) Now my connection to my MySQL server for my online hosting company has been done for 12 hours and I haven't been able to work on it anymore. Does anyone know an easy way to do this? Thanks, John Burroughs -- John Burroughs http://johnaburroughs.com

[PHP-DB] Re: Problems with 4.3.10 and SQL Server

2005-03-18 Thread John Lim
Hi There are serious bugs in mssql support in 4.3.10. Get the latest snapshot from CVS and update php_mssql.dll http://snaps.php.net/ Aifoundations.Org [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I don't see many SQL Server posts here but I will give it a shot. I am using PHP

Re: [PHP-DB] How to emulate phpMyadmin for editing with checkboxes

2005-02-25 Thread John Holmes
, this has to be the case. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to emulate phpMyadmin for editing with checkboxes

2005-02-23 Thread John Holmes
crashes? etc... :) -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL: Top $num results

2005-02-13 Thread John Holmes
sorting the rest of the table after it finds the 10 highest (or whatever your limit is). Is that what you're after? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http

Re: [PHP-DB] 'Order by' question

2005-02-09 Thread John Holmes
for me to make it sort by number first and then by letter? Not in your query. Try resorting it using a natural sort in PHP. The A, B, and C should be in another column, anyhow. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP

Re: [PHP-DB] IIS, PHP, and session data

2005-01-25 Thread John Holmes
to the errors you see later. The question I have is: What concerns should I have with PHP sessions when I move from Apache to IIS? None if sessions are set up correctly on each machine and you're using the same version of PHP at the same error reporting level. -- ---John Holmes... Amazon Wishlist

Re: [PHP-DB] last record

2005-01-24 Thread John Holmes
set? Unless you're trying to recreate mysql_insert_id(), then the way you have written is the way to do it. I suppose you could use mysql_result(), but that'd be pretty inefficient. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP

Re: [PHP-DB] Pulling Date from MySQL then subtract

2005-01-22 Thread John Holmes
... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] insert into mysql-db from csv-file

2005-01-17 Thread John Holmes
Ruprecht Helms wrote: I want to read a csv-file and import the datas into a mysql-db. How do I make this. A little scriptexaple in php would be helpfull. Why not just LOAD DATA INFILE from MySQL? No need to involve PHP at all, really... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o

Re: [PHP-DB] MySQL Auto PK

2005-01-05 Thread John Holmes
OOzy Pal wrote: Is it possible to have mysql at an ID as 20050105-1 as (MMDD-1), -2, etc. automatically? No. But you can always just use SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ... if you _really_ need something like this. Or just join them together in PHP. -- ---John Holmes

Re: [PHP-DB] Getting total results

2004-12-29 Thread John Holmes
in it may not be more efficient than connecting to the database and just retrieving 10 data units at a time... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http

Re: [PHP-DB] is this a problem ?

2004-12-28 Thread John Hicks
.) --Try including an 'else' in your 'if' statement (along with a debug message) so you can see if the 'submit' is detected by your script when the form is submitted. -John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting total results

2004-12-28 Thread John Holmes
(no way around that, anyhow), but hopefully optimized better by MySQL. Perform your own tests, of course. See the documentation on FOUND_ROWS() at the following URL for more info: http://dev.mysql.com/doc/mysql/en/Information_functions.html -- ---John Holmes... Amazon Wishlist: www.amazon.com/o

Re: [PHP-DB] Getting total results

2004-12-28 Thread John Holmes
was about how to make two queries more efficient: SELECT ... FROM table WHERE ... LIMIT x,y SELECT COUNT(*) FROM table WHERE ... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing

Re: [PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread John Hicks
an 'else' in your if statement (along with a debug message) so you can see if the 'submit' is detected. -John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] check out this , if block is not executing ............

2004-12-27 Thread John Holmes
or if you're learning it yourself, you need to spend some more time on the basics before getting this difficult, apparently. Take your database out of the equation and spend some more time learning how forms, register_globals and variables work. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o

Re: [PHP-DB] query is not executing data is not entering in created database

2004-12-26 Thread John Holmes
never getting to it. I could tell you to use $_GET['submit'] or $_REQUEST['submit'], but would you know why or where to use it? -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing

Re: [PHP-DB] Undefined indicies

2004-12-26 Thread John Holmes
method if you're afraid of isset() or something. I do it the second way, but yeah, it's personal preference. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http

Re: RE: [PHP-DB] PHP Classes to generate Excel files ?

2004-12-22 Thread John Holmes
styling along with it. ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP Classes to generate Excel files ?

2004-12-22 Thread John Holmes
still being actively developed or kept up to date or what, though... ---John Holmes... UCCASS - PHP Survey System http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Object oriented database in PHP?

2004-12-20 Thread John Holmes
From: symbulos partners [EMAIL PROTECTED] Has anybody implemented an object oriented database in PHP yet? No... PHP would not be a suitable programming language to create a database in... If you mean an OO abstraction layer to a database, however... then yeah. ---John Holmes... UCCASS

[PHP-DB] Turn off out of offfice messages for the list, please

2004-12-14 Thread John Holmes
a while, if you can imagine. Yes, I know how to filter them to my Junk folder, but let's try to stop it at the source instead, eh? ;) Happy Holidays, -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP

  1   2   3   4   5   6   7   8   9   10   >