[PHP-DB] How to get mysqli to allow SQL-based User-Defined Variables as column aliases?

Hi all, I’m able to get mysqli to set a user-defined variable and the use it later on either in a column value definition or a conditional, I.e. (semi-pseudocode since I’m not in front of my work computer) First do mysqli $conn->query(‘Set @foo = “bar”;’); …which will prepare the database sessi

[PHP-DB] How to use mysqli with php5.6

Hi, I have installed php5.6 by command "pkg install php-56“ in solaris 11 x64,and I want to use mysqli extension to connect mysql 5.5 database,but I found that I can’t find any mysqli extension.Any one can tell me how to use mysqli extension?Any suggestions should be appreciated!

[PHP-DB] How to get stored procedure return values via PDO (in 2011)?

Hi there, I just stumbled upon the problem regarding the return values of mysql stored procedures via PDO. In my case I use Zend_Db_Adapter_Pdo_Mysql but hence this is an adapter I still blame PDO. ;-) Some times ago (in 2007) this problem was discussed already: http://marc.info/?l=php-general&m=

[PHP-DB] How to have a smooth hairless skin

How to have a smooth hairless skin. Hairless in the bikini zone. Click here: http://www.removehair.tk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Hi Ron, I personally don't believe in syncing peoples personal contacts to anyones server. Especially google. If that is what that API does. But your call. You should be able to connect to the contact sync right on the phone with your app and not need a server to do this. On the jailbreakin

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Hi Ron, yes,you should try to use Google as a gateway; the Google API is very well documented, I think all you need is just the user account (and password) and then through the API you should access all data. Cheers. On 23 October 2010 19:10, listread wrote: > Andrés, > > It would be tempting to

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Andrés, It would be tempting to build an app for this, but we don't have a single Mac in the place. Maybe syncing with Google is the way to go? That would keep the iPhone out of the equation. (This is not intended for the market.) Thanks, - Ron On 10/23/2010 2:16 PM, Andrés G. Montañez

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Hi Ron, watchout with the jailbrake becaous it will void your warranty over the iphone. If you want to sync the phone's contact with "something", you really should check the iphone API and build an iphone application which hooks and listens for contact's change and then notify the changes to your s

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Karl / Andrés Thanks for your replies. iMy appears to be only a client and I can already access servers with php on the iPhone web browser. I would like MySQL on my iPhone. There was a way to make a jailbroke iPhone a MySQL server, but I'm not sure it is available any longer. My immediate

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Hi Ron, what's what you want to sync? Contacts? Or everything else? You want to sync it over the internet? Or over wire? You should research the iPhone API/SDK for sync; and not focus with MySQL, wich is just an storage. Cheers. On 23 October 2010 03:09, Karl DeSaulniers wrote: > I believe there

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

I believe there is a MySQL for the iphone iMy? http://forums.mysql.com/read.php?58,249718,249718 You'd probably want o use JASON or an equiv. to talk back and forth with your database and app. At least thats the consensus I'm finding on posts about it. HTH Karl On Oct 22, 2010, at 11:21 PM,

[PHP-DB] How to Sync MySQL with iPhone or Google Contacts

Hey all! Does anyone know how to go about syncing a MySQL db with an iPhone over the internet? An alternative would be syncing with Google Contacts, which then could sync with the iPhone. I think Google Contacts uses Exchange Server to sync with devices. Thanks! - Ron -- PHP Database

Re: [PHP-DB] how to explain such a regular syntax

On 13 August 2010 08:47, win.a wrote: > Its was picked from drupal source code and i don't know how does it works. > This is the code : > preg_match('/^\[?(?:[a-z0-9-:\]_]+\.?)+$/', $host); This has got nothing to do with php or php-db - your question is on regular expressions. Try consulting htt

[PHP-DB] how to explain such a regular syntax

Its was picked from drupal source code and i don't know how does it works. This is the code : preg_match('/^\[?(?:[a-z0-9-:\]_]+\.?)+$/', $host); After followed the regular syntax ,i try to cut it into pieces to make it simpler to understand , part a1: ^\[? part a2:([a-z0-9-:\]_]+\.?)+$ Then go o

Re: [PHP-DB]how to handle exception in php

hi friends... Thanks for your suggestions..but i could not get the exact rank list properly.. My code is as below.. $sql2="SELECT * FROM rank"; $result=mysql_query($sql2,$con); $num=mysql_num_rows($result); for($i=0;$i<$num;$i++) { $f1=mysql_result($result,$i,"regno"); $d6=mysql_result($result,$i

Re: [PHP-DB] how to upgrade php in linux

I apologize guys for being rude.. i know that u guys are helping me out, but i was in a typical awkward position searching for the same things made me a little restless. coming to the point i have posted the question to the centos list as well as suggested by dan.. but still now i could not able t

Re: [PHP-DB] how to upgrade php in linux

No idea what's happening there. Have u done this: yum update ? On Wed, May 5, 2010 at 3:02 PM, Chaitanya Yanamadala < dr.virus.in...@gmail.com> wrote: > hai dan > thank you for your suggestion regarding the google thing.. > thank god u said me that or else i could have never known that google wil

Re: [PHP-DB] how to upgrade php in linux

On 05/05/10 15:02, Chaitanya Yanamadala wrote: hai dan thank you for your suggestion regarding the google thing.. thank god u said me that or else i could have never known that google will get me all the results. dude i just asked this question thinking that some one would help me find the soluti

Re: [PHP-DB] how to upgrade php in linux

hai dan thank you for your suggestion regarding the google thing.. thank god u said me that or else i could have never known that google will get me all the results. dude i just asked this question thinking that some one would help me find the solution not for fun. regarding the thing of compiling

Re: [PHP-DB] how to upgrade php in linux

As someone else mentioned in the list, try the remi repository. If you still want to compile from source, then this is what you do to search for packages: yum search packagename So you would be doing: yum search gcc and then install the missing package before compiling php. You may have to

Re: [PHP-DB] how to upgrade php in linux

hai bavitra i have read the article from this site http://www.web-tech-india.com/articles/php/compiling_php_apache/ but actually the thing is it is not working for me.. it is giving me some error like this checking for gcc ---no checking for cc--no configure: error: no acceptable cc found in $PA

Re: [PHP-DB]how to handle exception in php

On 2 May 2010 06:26, Bavithra R wrote: > hi friends > > I am doing a simple student mark details project. > for calculating rank I need to compare the total marks one by one. > To do so i use *for loop.* so atlast while reaching the end of the table it > shows the following warning. > * > Warning*

Re: [PHP-DB] how to upgrade php in linux

> i have downloaded the tar file from php.net but dont know how to complile >the same for the linux. > > Hi Chaitanya > > > As you have downloaded the tar file you need to extract it. > Try this *Extraction: *tar -jxvf php-5.3.2.tar.bz2 where php-5.3.2.tar.bz2 is the filename y

Re: [PHP-DB] how to upgrade php in linux

php 5.3.2 is availabe in remi repository, so go to http://blog.famillecollet.com/ and read or go directly to http://blog.famillecollet.com/pages/Config-en 2010/5/3 Chaitanya Yanamadala : > hai kesavan >  the latest rpm is what i have installed already. > but i require the php 5.3.2 to be installed

Re: [PHP-DB] how to upgrade php in linux

hai kesavan the latest rpm is what i have installed already. but i require the php 5.3.2 to be installed so where can i get the rpm for that i hve used the yum search php which is giving me the 5.1 only.. Chaitanya On Mon, May 3, 2010 at 6:54 PM, Kesavan Rengarajan wrote: > Add DAG and RPMF

Re: [PHP-DB] how to upgrade php in linux

Add DAG and RPMForge repos (google for how to) and try to do a yum install.Compiling from source might not be the best option if you are new to Linux. Sent from my iPhone On 03/05/2010, at 10:57 PM, Chaitanya Yanamadala > wrote: hai david the rpm available is for this is the one which i

Re: [PHP-DB] how to upgrade php in linux

hai david the rpm available is for this is the one which i am having that is the latest one. but i require to install the 5.3.2 for some more extenstions to be working. i have downloaded the tar file from php.net but dont know how to complile the same for the linux. i am pretty new to the linux..

Re: [PHP-DB] how to upgrade php in linux

On Monday 03 May 2010 07:02:35 Chaitanya Yanamadala wrote: > Hai > i have installed php in the cent os 5.4. the one which is installed is > 5.1.6 now what i want to do is upgrade it to latest one 5.3.2, as i am new > to linux environment it is quite hard for me to configure that, can any one > gui

[PHP-DB] how to upgrade php in linux

Hai i have installed php in the cent os 5.4. the one which is installed is 5.1.6 now what i want to do is upgrade it to latest one 5.3.2, as i am new to linux environment it is quite hard for me to configure that, can any one guide me with this also one more thing is that i need to install zend fr

Re: [PHP-DB]how to handle exception in php

On 02/05/10 15:26, Bavithra R wrote: hi friends I am doing a simple student mark details project. for calculating rank I need to compare the total marks one by one. To do so i use *for loop.* so atlast while reaching the end of the table it shows the following warning. * Warning*: mysql_result()

Re: [PHP-DB]how to handle exception in php

Dear Bavithra, I would suggest you the following solution $sql = "SELECT x FROM y"; $rs = mysql_query ($sql) $num = mysql_numrows($rs); while ($i < $num){ z = mysql_result($rs, $i, 'x'); $i++; } I hope that above solution help you. Luiz Alberto On Sun, 2010-05-02 at 10:56 +

[PHP-DB]how to handle exception in php

hi friends I am doing a simple student mark details project. for calculating rank I need to compare the total marks one by one. To do so i use *for loop.* so atlast while reaching the end of the table it shows the following warning. * Warning*: mysql_result() [function.mysql-result

Re: [PHP-DB] How to use PHP to fill in existing pdf document

Just a thought, You may be able to instead of having them download, just display it as a html page and the fields will be there, then attach a PHP mail script to it somehow with a macro or something to that effect. Have it call on this php script to send the message and/or store in the datab

Re: [PHP-DB] How to use PHP to fill in existing pdf document

Hi Ron, I have done this once before and what I had to do was let the user download the pdf that had the fields in it, they fill in the fields and email the pdf back, right from acrobat. In the pdf, you set the fields to lock after they finish and submit. You can also have them sign the docu

Re: [PHP-DB] How to use PHP to fill in existing pdf document

Yes, I've looked hard at fdpf and see how it is used to generate a new pdf, but I need to simply fill in the form fields in an existing pdf. If it can do that, I'm not finding the feature Thanks, - Ron On 5/1/2010 7:43 PM, Gary wrote: "listread" wrote in message news:4bdc9ced.3060...@c

Re: [PHP-DB] How to use PHP to fill in existing pdf document

"listread" wrote in message news:4bdc9ced.3060...@cze.com... > Yes, we can first ask the user to fill in a form, but then comes the part > I don't understand - how to covert it to pdf. > > It would be best if we could just fill in the fields on an existing form, > but it would also work to p

Re: [PHP-DB] How to use PHP to fill in existing pdf document

Search for pdflib or fpdf. They help you with generating PDF files from a php script. Sent from my iPhone On 02/05/2010, at 7:28 AM, listread wrote: Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if

Re: [PHP-DB] How to use PHP to fill in existing pdf document

Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if we could just fill in the fields on an existing form, but it would also work to print the printer friendly form to the server's printer queue, which could

Re: [PHP-DB] How to use PHP to fill in existing pdf document

I am not sure if this works for your project but you can first ask user to fill the form in PHP and then convert it into PDF. What say?

[PHP-DB] How to use PHP to fill in existing pdf document

Greetings PHP gurus! Does anyone know of a way to use PHP to fill in the form fields in an existing pdf document residing on the server? We want the end result to be the creation of a unique pdf document for each visitor which can either be emailed or stored in a directory on the server. W

Re: [PHP-DB] How to: Include identifier with a query

listread wrote: Greetings! We are searching for names that might or might not exist in a 4 million row db and have to do a lot of fuzzy searches that often don't return results. I would like the use to have the option of killing a query process. Since we are apt to have several queries run

Re: [PHP-DB] How to: Include identifier with a query

;t know if that helps, but just to add to the list of "how *some* people do it". Good luck! -TG - Original Message - From: listread To: php-db@lists.php.net Date: Mon, 02 Nov 2009 07:16:23 -0600 Subject: [PHP-DB] How to: Include identifier with a query > Greetings! > &g

[PHP-DB] How to: Include identifier with a query

Greetings! We are searching for names that might or might not exist in a 4 million row db and have to do a lot of fuzzy searches that often don't return results. I would like the use to have the option of killing a query process. Since we are apt to have several queries running KILL QUERY d

Re: [PHP-DB] How to fix config mysql?

Sorry for top posting, a little flaw in the web version of gmail. Restart the web server to get the ini change to take effect bastien On Thursday, July 23, 2009, Ankur Singh wrote: > Please add mysql dll to you php extension directory > > 2009/7/23 yi wang : >> Hi, all! >> >> I have intalled ap

Re: [PHP-DB] How to fix config mysql?

Please add mysql dll to you php extension directory 2009/7/23 yi wang : > Hi, all! > > I have intalled apache and php on win32, It works fine. I can get phpinfo > page correctly. > > And I intall mysql then. It works fine itself too. I can start the service, > and get into mysql throuth the cmd li

[PHP-DB] How to fix config mysql?

Hi, all! I have intalled apache and php on win32, It works fine. I can get phpinfo page correctly. And I intall mysql then. It works fine itself too. I can start the service, and get into mysql throuth the cmd line. But, when I go php with sql by wirting mysql_connect, the broswer says "Call to

Re: [PHP-DB] How to access MySQL through PHP in windows 2K.

Should be simple enough... Do you have the mysqli driver enabled in your php.ini file? ;extension=php_mysqli.dll should become extension=php_mysqli.dll hth, Yves -- Original Message -- Received: Tue, 28 Apr 2009 06:55:37 PM CDT From: "Katiyar \(GMail\)" To: Cc: Subjec

[PHP-DB] How to access MySQL through PHP in windows 2K.

Praveen's MailHi List, I am new to PHP and as well as with MySQL, a.. I have installed PHP 5.28, on win 2K (with IIS) and it is installed properly I suppose, as when I call phpinfo (), through a script, it shows the PHP Information. b.. then I installed MySQL 5.1.30, and through MySQL c

Re: [PHP-DB] How to know the name of a function ?

On 9 Nov 2008, at 21:41, Jean-Philippe Battu wrote: In a function, what is the best way to know the name of this function ? I read the documentation and found only func_num_args(), func_get_arg() and func_get_args which are relative to the arguments given to the function. What is the equivalent t

[PHP-DB] How to know the name of a function ?

Hello In a function, what is the best way to know the name of this function ? I read the documentation and found only func_num_args(), func_get_arg() and func_get_args which are relative to the arguments given to the function. What is the equivalent to $0 (bash) in php ? Thanks for your help Ch

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

Trullo wrote: On Tue, Sep 23, 2008 at 6:58 AM, Chris <[EMAIL PROTECTED]> wrote: To the OP: why does it matter where the row appears in the list? In the case i'm facing it doesn't matter, but it could be useful to display a scroll bar related to the size of the table and the row viewed at the

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

On Tue, Sep 23, 2008 at 6:58 AM, Chris <[EMAIL PROTECTED]> wrote: > To the OP: why does it matter where the row appears in the list? > In the case i'm facing it doesn't matter, but it could be useful to display a scroll bar related to the size of the table and the row viewed at the moment, or any

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

Jack van Zanen wrote: As a caution, I would never, ever use a query that relies on the data to be returned from the table in a certain order. That is just wrong and goes against the principals of a rdbms. I don't know that it goes against the principle, it's more that a database will nev

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

As a caution, I would never, ever use a query that relies on the data to be returned from the table in a certain order. That is just wrong and goes against the principals of a rdbms. Just write your queries in such a way that the result is always returned the way you want it regardless of the wa

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

En/na Chris ha escrit: > Trullo wrote: >> hello_world(); >> >> in fact.. how to goTo next/previous row of a table without using >> incremental ids AND without reading the whole table? >> i will explain: >> I wanna do something like a paging toolbar blinded to a list of rows >> (for example, a liter

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

Trullo wrote: hello_world(); in fact.. how to goTo next/previous row of a table without using incremental ids AND without reading the whole table? i will explain: I wanna do something like a paging toolbar blinded to a list of rows (for example, a literally view of a db table). The first differe

[PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

hello_world(); in fact.. how to goTo next/previous row of a table without using incremental ids AND without reading the whole table? i will explain: I wanna do something like a paging toolbar blinded to a list of rows (for example, a literally view of a db table). The first difference from a norma

Re: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0

how about convert into SQL file? then try to import using phpmyadmin? naren pendyal wrote: Check out the tool Oracle Migration work bench Regards, Naren www.bigfatprize.com --- santoso berkah <[EMAIL PROTECTED]> wrote: Dear friends, I would ask to you about the tools or references for im

Re: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0

Check out the tool Oracle Migration work bench Regards, Naren www.bigfatprize.com --- santoso berkah <[EMAIL PROTECTED]> wrote: > Dear friends, > > I would ask to you about the tools or references for > importing data > from Oracle 10g to MySQL 5. > > Thank you for your kindness. > > Regards

Re: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0

ot;santoso berkah" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 30, 2008 10:24 PM Subject: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0 Dear friends, I would ask to you about the tools or references for importing data from Oracle 10g to MySQL 5. Thank you for your kind

Re: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0

Have you looked into PHPMyAdmin? http://www.phpmyadmin.net/home_page/index.php There's an option for importing an oracle sql file. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com santoso berkah wrote: > Dear friends, > > I would ask to you about the tools or

[PHP-DB] How to import data from Oracle 10g to MySQL 5.0

Dear friends, I would ask to you about the tools or references for importing data from Oracle 10g to MySQL 5. Thank you for your kindness. Regards, im_id -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] How to do a Newsletter

Hello; What exactly do you mean? I have some jobs in cron that run a query and then spit out an thml page via email. That type of thing? From: Nasreen Laghari <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] How to do a Newsletter Date: Thu, 1 May 2008 08:59:33 -070

Re: [PHP-DB] How to do a Newsletter

have to email it. Basically I have run a query according to user criteria of newsletter and send it via email - Original Message From: Jason Pruim <[EMAIL PROTECTED]> To: Nasreen Laghari <[EMAIL PROTECTED]> Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM Su

Re: [PHP-DB] How to do a Newsletter

Subject: Re: [PHP-DB] How to do a Newsletter That's not an awful lot to go off of.. I'm assuming the actual  newsletter is already produced probably in a PDF? Are you looking to e-mail it out? Post it to a website? Get e-mail addresses to e-mail it to? Get postal addresses to postal

Re: [PHP-DB] How to do a Newsletter

That's not an awful lot to go off of.. I'm assuming the actual newsletter is already produced probably in a PDF? Are you looking to e-mail it out? Post it to a website? Get e-mail addresses to e-mail it to? Get postal addresses to postal mail it to? More info I think would definitely help.

[PHP-DB] How to do a Newsletter

Hi, Does any one know a better way of doing "Newsletter". I have to run a query and send that data to clients. Regards Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. h

Re: [PHP-DB] How to recognize which 'case' is being echoed by switch statement

On Fri, Feb 22, 2008 at 6:01 AM, Tim Daff <[EMAIL PROTECTED]> wrote: > Hi, > > This is my first time using php in my site navigation, I have the code > for all the pages in one file and I am using the switch statement to > change between them. [snip!] None of your code included a case/switc

RES: [PHP-DB] How to recognize which 'case' is being echoed by switch statement

09:31 Para: Tim Daff Cc: php-db@lists.php.net Assunto: Re: [PHP-DB] How to recognize which 'case' is being echoed by switch statement On 22 Feb 2008, at 11:01, Tim Daff wrote: > $page = case; >

Re: [PHP-DB] How to recognize which 'case' is being echoed by switch statement

On 22 Feb 2008, at 11:01, Tim Daff wrote: "; } else { echo "Contacta>"; } ?> $page = case; will be raising a notice which you're obviously not see

[PHP-DB] How to recognize which 'case' is being echoed by switch statement

Hi, This is my first time using php in my site navigation, I have the code for all the pages in one file and I am using the switch statement to change between them. This is working great but I am now trying to change the css id of the current page's navbar link. How do I get my script to

Re: [PHP-DB] How to Parse XML Feed on my PHP page

Take a look at the pear XML_Feed_Parser package at http://pear.php.net/package/XML_Feed_Parser for parsing Atom & RSS feeds For parsing normal xml documents try XML_Parser package http://pear.php.net/package/XML_Parser Vikas Jayna Chris Carter wrote: > > Hi, > > I have never done parsing of

[PHP-DB] How to Parse XML Feed on my PHP page

Hi, I have never done parsing of an XML feed or URL on my PHP page. Basically there is a website that shows products, in order to list those products on your page you need to parse the XML URL that they provide. I have no experience to this, have been searching on this but have not got a clue. S

[PHP-DB] How to get last insert id safely?

Hi All, How to get last insert id safely in php with persistent connection to mysql?because there may be larger concurrence requests to the php to query insert statements.Example,the php query following two sql statements: mysql_query("insert into tb(id,name) values(null,$username)"); $res = mys

RE: [PHP-DB] how to store a heirarchy of resellers and customers WAS: newbie help

Also, you really should use a more descriptive subject line, 'newbie help' is kind of weak. If everyone did that, nobody would be able to search subjects or distinguish one topic from another. I won't even get into the whole 'top/bottom post' B.S. (personally I think top posting is great as you d

RE: [PHP-DB] How to capture from session and match database

e code you could use Do read my comments after // (slashes) Naintara -Original Message- From: Chris Carter [mailto:[EMAIL PROTECTED] Sent: Sunday, September 23, 2007 9:59 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] How to capture from session and match database Hi Naintara,

Re: [PHP-DB] How to capture from session and match database

Hi Naintara, thanks for your code could you please advice why is the code giving this error. "Parse error: syntax error, unexpected T_ISSET in /path/submit-store-details.php on line 4" This is coming when I am trying to use your code like this: and then retrieving it in SQL query: $query="S

RE: [PHP-DB] How to capture from session and match database

y variables, and then test the sql. -Original Message- From: Chris Carter [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 8:34 AM To: php-db@lists.php.net Subject: [PHP-DB] How to capture from session and match database Hi, I have this session code on each page and this is

Re: [PHP-DB] How to capture from session and match database

You can use cookies to keep your info so that you don't pass them from page to page. A way to do this is: $email = '[EMAIL PROTECTED]'; session_start(); setcookie('e-mail',$email); And then retrieve the cookie information using the $_COOKIE array: $query="SELECT * FROM table WHERE email = '".

[PHP-DB] How to capture from session and match database

Hi, I have this session code on each page and this is working fine for authentication: Now I wish to 1)capture the value (userName) from session on one of my pages and 2)match it with the database and 3)display the value in the textfields This is the code I am using to do this please: in

[PHP-DB] How to capture from session and match database

Hi, I have this session code on each page and this is working fine for authentication: Now I wish to 1)capture the value (userName) from session on one of my pages and 2)match it with the database and 3)display the value in the textfields This is the code I am using to do this please: in

Re: [PHP-DB] how to avoid showing warnings

Warning: mysql_query(): Your query requires a full tablescan (table Mobile_Tunes, 4 rows affected). Use EXPLAIN to optimize your query. in D:\Program Files\Apache Group\Apache2\htdocs\Breez\mtunes_main.php on line 47 Warning: mysql_query(): Your query requires a full tablescan (table Mob

Re: [PHP-DB] how to avoid showing warnings

Hi i am including table structure and other results to you CREATE TABLE Mobile_Tunes ( Tune_ID int(6) NOT NULL AUTO_INCREMENT, Tune_Name varchar(30) NOT NULL, Tune_Type varchar(10) NOT NULL, PRIMARY KEY (Tune_ID), UNIQUE KEY Tune_Name (Tune_Name), INDEX Tune_Type (Tune_Type) )ENGIN

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

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

Re: [PHP-DB] how to delete

Hi There is no DESTROYIMAGE() function. May be you mean imagedestroy(). If so this does NOT erase files, it destroys in memory images created using the Image functions. To erase files use the unlink function. For detail look here http://uk3.php.net/unlink Niel -- PHP Database Mailing List (

Re: [PHP-DB] how to delete

text mean bold" (use " ") - Original Message - From: "Asim" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 19, 2007 12:08 PM Subject: [PHP-DB] how to delete > HI > > can you tell me how to delete images from HARD DISK OR WEB SPACE by using php? >

[PHP-DB] how to delete

HI can you tell me how to delete images from HARD DISK OR WEB SPACE by using php? i have created tumbnails of some images and they are stored on HARD DISK IN PRESCRIBED FOLDER. now i use DESTROYIMAGE(); FUNCTION in php but it didnot delete crearted thu

Re: [PHP-DB] How to call image from mySql to php file

Chris Carter wrote: I have a field in database called "logos" which has one value "images/logos/some_logo.jpg" In my php I am trying to call it in my php file as image. With this code. $sno = $_REQUEST['sno']; $query="SELECT logos FROM table WHERE sno = '$sno'"; Please please please read ht

RE: [PHP-DB] How to call image from mySql to php file

is Carter <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] How to call image from mySql to php file Date: Wed, 21 Feb 2007 03:26:44 -0800 (PST) I have a field in database called "logos" which has one value "images/logos/some_logo.jpg" In my php I am trying to call i

[PHP-DB] How to call image from mySql to php file

I have a field in database called "logos" which has one value "images/logos/some_logo.jpg" In my php I am trying to call it in my php file as image. With this code. $sno = $_REQUEST['sno']; $query="SELECT logos FROM table WHERE sno = '$sno'"; $result=mysql_query($query); $num=mysql_numrows($r

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

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]> w

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

Hi John, I'd suggest searching within the Extra field instead of testing for the value explicitly, as this field can theoretically hold several extra pieces of information. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

Here's what I did wih your help: function isAutoinc($table,$fieldname){ // returns 0 if false, 1 if true $breturn = 0; $sql = "SHOW COLUMNS FROM $table LIKE '$fieldname%' "; $result = mysql_query($sql) or die("Couldn't open table"); // check column Extra $row = mysql_fetch_array( $result

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

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

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

Hi Try using: SHOW COLUMNS FROM db.table LIKE 'field_name%' and from the returned row, check the 'Extra' column for 'auto_increment' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

I've been struggling to figure a way to determine if a mySql filed type is auto inc. Any ideas? Iv'e written a function that will INSERT form data which has the exact field names as the mysql table, thus looping through the table names and then building a query string for the insert. However I'

RE: [PHP-DB] How to stop the server timing out

Hi, Thanks, the echos causes the page to responds after each insert, so the server no longer times out. David -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 04 October 2006 03:24 To: David Skyers; php-db@lists.php.net Subject: RE: [PHP-DB] How to stop the

Re: [PHP-DB] How to stop the server timing out

Hi, > Is there anything I can do, to get the page to run completely sure, contact the hosting company to prolong the maximum execution time on that script > or speed up how the page works maybe, but I dont see the source code > The page does a select from a table and inserts the data into ano

Re: [PHP-DB] How to stop the server timing out

ot;David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every time I run it, it causes the server to times-out. Is there anything I can do, to get the page to run completely or s

RE: [PHP-DB] How to stop the server timing out

You need to just start adding echo statements to the code to see where the hang up is Bastien From: "David Skyers" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] How to stop the server timing out Date: Tue, 3 Oct 2006 11:51:30 +0100 Hi, I have written a php page and every t

  1   2   3   4   5   6   7   8   >