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

On Saturday 22 June 2002 06:27, Jonathan wrote: > Hello everyone, > I am brand new to php, so any replies I get are very much appreciated. > My goal is to retrieve one entire table from my database and post the > information on the web. My query seems successful, but I am having trouble > get

RE: [PHP-DB] MYSQL Socket error :\

It may prove beneficial to check the event log. More clues may lie in there. If the webserver has any type of error log check that as well. Aaron Weiker > -Original Message- > From: Marco Lanini [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 22, 2002 1:10 AM > To: [EMAIL PROTECTED] >

Re: [PHP-DB] MYSQL Socket error :\

Thanks Dan, but i have already tested this solution... i have build a very little test script, who generate this error. i am in localhost and i use very simple "root" "admin" login but the message is always the same! Can't create TCP/IP socket (10106) i think, probably is an error in php.ini

[PHP-DB] password()... is it possible?

Hi all, I need the administrators of one site to actually see the user’s passwords. I like using password() for encrypting but doesn’t know if it can be retrieved in common English. Thanks, Cesar Aracena CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.44666

[PHP-DB] Re: [Q] EXT SQL IN PostgreSQL

PostgreSQL module does not have cursor. All you have to do is execute query then fetch records one by one. For example, $result = pg_query($db_connection, 'select * from your_table;'); while ($record = pg_fetch_array($result)) { print_r($record); } Above code can be used to print all record

Re: [PHP-DB] how expensive is mysql_connect in performance

At 22:39 -0400 6/21/02, Michael Zornek wrote: >I'm just getting into some stuff where I seem to be making a lot of >mysql_connect and mysql_close calls. I wonder, how taxing is this on the >server? Not very. MySQL's connection-establishment sequence is pretty efficient. mysql_pconnect() by cont

[PHP-DB] Re: Populating multi-select list from mysql

Hi Bob, I have written some functions which make select lists much easier. I have two functions: - BuildQuickSelect() - you pass a couple of parameters (tablename, etc) - BuildSelectMenu() - you pass $sql and some more parameters Unfortunately, they require a few things (such as

[PHP-DB] how expensive is mysql_connect in performance

I'm just getting into some stuff where I seem to be making a lot of mysql_connect and mysql_close calls. I wonder, how taxing is this on the server? Is there any performance test of PHP/MySQL out there I could run on my development or deployment machines? ~ Mike -- Mike Zornek | Project Leader

RE: [PHP-DB] Converting values from text to numerical

Hi Matt, I think this might be the answer to your problem. It basically checks if the string is an integer. I generally love the PHP automatic type conversion, but sometimes it can trick ya :) if (intval($val) == $val){ // integer stuff } else { // string stuff } Adam > H

[PHP-DB] [Q] EXT SQL IN PostgreSQL

# Sorry to my poor English I have a procedure ( named by select_table ) ## BEGIN; select select_table('select_cur','table_name'); FETCH ALL IN select_cur; COMMIT; ## This Query is right In Console (psql). I wanna s

[PHP-DB] Emulating HTTP File Uploads

Does anyone know how to upload a file through PHP through the HTT interface. I use fopen() to open remote php scripts using the GET method for non-file uploads but it doesnt work with HTTP POST or file uploads. Does anyone have any ideas? -- Regards, Georgie Casey [EMAIL PROTECTED]

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

Hello everyone, I am brand new to php, so any replies I get are very much appreciated. My goal is to retrieve one entire table from my database and post the information on the web. My query seems successful, but I am having trouble getting the information out from the variable $result. My ta

[PHP-DB] MSSQL

I just starting with mssql coming from a mysql background. Im looking for tutorials and such on how to get scripts working with php. The server is IIS 5 with php 4.2.1 and mssql 2000. phpinfo() shows that mssql is recognised. Im not sure if I have to jump through hoops like how I did when I firs

Re: [PHP-DB] help with $_Get in form

The method is right, for your form, the problem is the lowercase $_get, I believe. use $_GET['formfield'] Jeff "Mike Germain"

Re: [PHP-DB] MySQL Query Acting Up

I would suggest using ' instead of " for SQL queries... That's what I use... so much easier. $query = "UPDATE articles2 SET title='$title', brief='$brief', doclink='$doclink' WHERE article_id='$id'"; Then I would print the query: print( "$query\n" ); Then if it still looks right, try m

RE: [PHP-DB] help with $_Get in form

Just from quickly looking you are trying to submit a form and grab the submitted value and stick it into the DB? If so try using METHOD="POST" on your form, and using the variable $_POST["form_field"] in the insert statement Matt Babineau MCWD / CCFD - e:

[PHP-DB] help with $_Get in form

I'm trying to get a partnum field into a select statement but i'm not getting anything passed into the varable. i'm sure it's a simple fix but i can't find it. thx mike Inventory Lookup PartNum: "; exit; } else { echo "Connection successful\n"; }; $query = "SELECT whs,loc,mipr

Re: [PHP-DB] BBS program

AHAHAHAH Now that was funny!! Do any of you remember the game Nuk'em?? That was a Blast!! Dan On Friday, June 21, 2002, at 12:50 PM, [EMAIL PROTECTED] wrote: >> BBS = Backyard Bible Study? > > Heh. Good guess. BBS = Bulliten Board System. > > Chris > > > > -- > PHP Database Mailing List (h

[PHP-DB] Finding numbers in a string

Forgot my email on that last one ;) Hello all - I am trying to seperate numberic characters from a string. The book I was looking at described something like this: if(ereg("[[:alnum]]+", $textandnumbers, $numbers)) { print("$numbers"); } When I run my script I receive this error: W

Re: [PHP-DB] BBS program

> BBS = Backyard Bible Study? Heh. Good guess. BBS = Bulliten Board System. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [PHP] Re: ARRAY, IF & INSERT

Thanks for the input. I wasn't considering the possibility of making a new table for kids until now which seems pretty logic when trying to save space. The only thing missing now is how to assign a unique relation number for each kid/relative. That's 1 for the first born, 2 for the second one, etc

Re: [PHP-DB] BBS program

One of the best PHP Message Boards around is Invision Boards (http://www.invisionboard.com). It's made by the same person who made IkonBoard. For an example check out my boards, which are still in development (I'm slow, what can I say? hehe): http://www.completesource.net/forums/ Martin >>

Re: [PHP-DB] BBS program

> I would like to avoid reinventing the wheel and find an existing BBS program. > Do these exist? You could probably take a look at PHPNuke or something along those lines. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] BBS program

BBS = Backyard Bible Study? -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] BBS program I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you --

[PHP-DB] BBS program

I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.

[PHP-DB] Finding numbers in a string

Hello all - I am trying to seperate numberic characters from a string. The book I was looking at described something like this: if(ereg("[[:alnum]]+", $textandnumbers, $numbers)) { print("$numbers"); } When I run my script I receive this error: Warning: REG_ECTYPE in ../mypage.ph

RE: [PHP-DB] MYSQL Socket error :\

I'm no expert on XP, but you may want to check the firewall settings, to make sure that windows XP isn't preventing the connection. For the $host, you may want to either use 'localhost' or 127.0.0.1 Cheers, Dan > -Original Message- > From: Marco Lanini [mailto:[EMAIL PROTECTED]] > Se

[PHP-DB] MYSQL Socket error :\

Hi sorry for my english but i'm italian. I have a server who run with WIN XP HOME Abyss Web Server (Freeware) www.aprelium.com MySql 4.0.1-alpha-nt PHP 4.2.1 when i use mysql_connect($host,$user,$pass) or die(mysql_error()); function he write: Can't create TCP/IP socket (10106) i have searc

RE: [PHP-DB] Populating multi-select list from mysql

Thanks for all the help. I got it working using the following code from Martin. Rob. $sql = "SELECT category FROM categories"; $result = mysql_query($sql, $connection); echo "\n"; while ($row = mysql_fetch_array($result)) { $id = $row['id']; $category = $row['category']; echo "$cat

Re: [PHP-DB] Innodb and transactions.

One other obvious thing to remember is that you need to to use: create table (int id blah blah blah) type = InnoDB; Also, to take advantage of these features you will also need to update your /etc/my.cnf file (assuming you run some *nix flavored OS) so the InnoDB files are created on disk. I fo

RE: [PHP-DB] Populating multi-select list from mysql

Whenever you are having trouble with your PHP pages, always echo! By doing this, you can see whether or not the query is formatted correctly, whether or not the variables are containing the values you think they are. It's incredibly helpful, no matter what the situation. Martin >>> "Ryan Ja

RE: [PHP-DB] Populating multi-select list from mysql

You're logic seems to make sense. The output (page source) you are getting would help. :-) <>< Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:06 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating multi-s

RE: [PHP-DB] Populating multi-select list from mysql

Hi all, I'm having problems getting my multi-select list populated from a mysql table. There is a table called categories with 2 columns (id and category). I want to get all the items (category) and list them in the multi-select list box. This is the code I have so far: $sql = "SELECT categor

RE: [PHP-DB] Can I be an ASP with PHP?

If your database server is on a remote server then expect the page to take even longer to render since it will take time to send the database query info back and forth between the two servers. -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: June 21, 2002 11:06 AM To: Re

Re: [PHP-DB] Creating an email form

On Wednesday 19 June 2002 10:35, Tim Best wrote: > I am creating an HTML form that one will fill out, upload their resume, > write a message, give their reply-to email address and send the email to me > with the uploaded file as an attachment. > > I know I have to create the email message with mim

Re: [PHP-DB] array problem

On Thursday 20 June 2002 23:26, Richard Black wrote: > By passing a second parameter to mysql_fetch_array, MYSQL_ASSOC > > This means you only get back an array with the values indexed by > fieldname. Or just use mysql_fetch_assoc(). -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk O

Re: [PHP-DB] Can I be an ASP with PHP?

You can connect to remote servers - but i'm guesssing that this will be a much more difficult route. Especially with customers that will be on shared servers (unless you licensed to the hosting companies...) read the manual for mysql_coonect mysql_connect (server, username, password) olinux -

Re: [PHP-DB] E-mail address verification

On Thursday 20 June 2002 23:59, [EMAIL PROTECTED] wrote: > As you can see, the email can "look" right, but domain isn't valid. So you > can check DNS record for MX domain. A valid email address does not necessary have to have an MX record. You could be incorrectly invalidating addresses like th

Re: [PHP-DB] MySQL and datatime field and displaying on page

On Friday 21 June 2002 21:42, Charlie Grosvenor wrote: > Hi > I have a mysql table that has a field in it called 'DATETIMEADDED' > which has data type 'datetime' I want to display the contents of the field > on my page. I have tried usng the following code but the value in the > 'DATETIMEADDED

Re: [PHP-DB] Populating multi-select list from mysql

On Friday 21 June 2002 10:31, bob wrote: > Hi all, > > I'm having problems getting my multi-select list populated from a mysql > table. There is a table called categories with 2 columns (id and category). > I want to get all the items (category) and list them in the multi-select > list box. > > Th

[PHP-DB] MySQL and datatime field and displaying on page

Hi I have a mysql table that has a field in it called 'DATETIMEADDED' which has data type 'datetime' I want to display the contents of the field on my page. I have tried usng the following code but the value in the 'DATETIMEADDED' only the value in the 'NAME' field which is a varchar is displa

RE: [PHP-DB] Innodb and transactions.

At 8:55 -0400 6/21/02, Steve Bradwell wrote: >So should I be using Innodb tables or BDB tables? You have to be using *some* kind of transaction-safe tables (InnoDB and BDB qualify). If you use a table type like MyISAM, then all statements are committed as they execute, and use of a transaction h

[PHP-DB] Re: intercative selection menu

You could have if statements for every option. May be better if you have a for loop for some of the options -- SEE BELOW. e.g : %s",$i); } printf(" 1916"); printf(" volta"); printf(" scatt11"); ?> Cheers Steve "Walid Dib" <[EMAIL PROTECTED]

[PHP-DB] Re: [PHP-WIN] RE: [PHP] How to Show my Own Error Message Instead of Mysql Error?

> i made a Registration Form for user to input their Data, but i also had some > Field Check before the data can be insert to the Mysql_Database! > I had a question here, sometime the mysql shows the error : > "Duplicate Key for xxx" > I know what is this about, reguarding to my Registration Form,

RE: [PHP-DB] Innodb and transactions.

Great! thanks for your help. -Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:11 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB

Re: [PHP-DB] Innodb and transactions.

Hi, use InnoDB, because InnoDB supports row-level locking, and InnoDB also supports referential-integrity, bye, Steve Bradwell schrieb: > So should I be using Innodb tables or BDB tables? > > Thanks, > Steve. > > -Original Message- > From: Michael Bretterklieber [mailto:[EMAIL PROTEC

Re[2]: [PHP-DB] a "back" include script

On Fri, 21 Jun 2002, Latex Master wrote: > DH> To manipulate the browser in such a way, you have at least two options: > DH> 1) Make the .inc just have a link to the REFERER value from the browser. > > The first one want work if the person is behing a socks server or PHP > gets a referer diferen

Re[2]: [PHP-DB] a "back" include script

Hello Duncan, Friday, June 21, 2002, 3:50:10 PM, you wrote: DH> On Fri, 21 Jun 2002, Dib, Walid (MED, Stagiaire GEMS) wrote: >> I want to create a file include .inc which by calling it in almost all the >> pages which I use, will return me to the previous page, thus this script DH> To manipula

RE: [PHP-DB] Innodb and transactions.

So should I be using Innodb tables or BDB tables? Thanks, Steve. -Original Message- From: Michael Bretterklieber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 2:49 AM To: Php-Db (E-mail) Subject: Re: [PHP-DB] Innodb and transactions. Hi, you have to do something like this: m

Re: [PHP-DB] WebSite Submissions Question

Since PHP is parsed before ever reaching it's destination for viewing/profiling, there should be no penalties for putting this on your page. If you have a page like the following (in PHP): Then it will come up like so, when Google/Yahoo/Whoever goes to view it for inspection: blahblah. H

Re: [PHP-DB] a "back" include script

On Fri, 21 Jun 2002, Dib, Walid (MED, Stagiaire GEMS) wrote: > I want to create a file include .inc which by calling it in almost all the > pages which I use, will return me to the previous page, thus this script To manipulate the browser in such a way, you have at least two options: 1) Make the

[PHP-DB] WebSite Submissions Question

Hi All On the website I am building, my Index page (index.html) does a check to see if it is Internet Explorer or Netscape Navigator that the user has for a browser.. and redirects the user to either header("Location: ../nav/index.html"); or header("Location: ../ie/index.html"); depending o

[PHP-DB] FW:

- Nco quebre a brincadeira. > > >>> > > > > >>> > > Se seu nome estiver na lista, coloque um asterisco ao > > >>> > > lado. > > >>> > > Se NAO, adicione seu nome em ordem alfabitica. > > >>> > > Mande para 10 pessoas e tambim para pessoa que lhe > > >>> > > enviou. >

[PHP-DB] Re: ARRAY, IF & INSERT

(i am new to these groups, but shouldn't there be a follow-up-to on a X-post?) César aracena wrote: > I have this form in which one Administrator can insert new members and > after that, in another page, a form where he/she can insert the new > member’s sons & daughters. I want to display a tabl

[PHP-DB] ARRAY, IF & INSERT

Hi all. I have this form in which one Administrator can insert new members and after that, in another page, a form where he/she can insert the new member’s sons & daughters. I want to display a table with “text inserts” into the admin can type let’s say a maximum of 5 kids in the second page. Th

[PHP-DB] intercative selection menu

Hello, I need to get back the present value in the data base and to post(show) it in the menu of selection. somebody has an idea?? Thank you in advance. : 1904 1905 1906 1907 1908 1909