Re: [PHP-DB] Database Search Engine ?
I see. But what if I am using mySQL? *by the way, can you tell me from where I get them. -M.Mamedov - Original Message - From: Joshua D. Drake [EMAIL PROTECTED] To: Muhammed Mamedov [EMAIL PROTECTED] Cc: phpdb [EMAIL PROTECTED] Sent: Thursday, February 26, 2004 12:59 PM Subject: Re: [PHP-DB] Database Search Engine ? Hello, I suggest PostgreSQL+TSearch2+OpenFTS... 30 minutes to a wonderful search engine. On Thu, 26 Feb 2004, Muhammed Mamedov wrote: Anyone knows/uses IMP database search engine? http://www.imptechnology.com/DesktopDefault.aspx?tabid=56 Thanks, M.Mamedov -- Co-Founder Command Prompt, Inc. The wheel's spinning but the hamster's dead -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] What's wrong with this query?
Try this:
$logit = mysql_query(INSERT INTO log (term,returns,time,date,ip) VALUES
('$search','$arrayword',CURTIME(), CURDATE(), '$ip'));
Regards,
Muhammed Mamedov
turkmenweb.com
- Original Message -
From: Axel IS Main [EMAIL PROTECTED]
To: PHP-DB [EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 11:05 AM
Subject: [PHP-DB] What's wrong with this query?
I've just tried to do something I've done a thousand times. It does not
work. I've checked all of the syntax, made sure the field and variable
names are correct. No matter what I do it just doesn't work. The table
remains empty. Here's the query:
$logit = mysql_query(INSERT INTO log SET term='$search',
returns='$arrayword', time=CURTIME(), date=CURDATE(), ip='$ip');
Now that doesn't look too difficult does it? Well, apparently it's
impossible! I'm really hoping someone out there can see something that I
missed.
Nick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Database Search Engine ?
Anyone knows/uses IMP database search engine? http://www.imptechnology.com/DesktopDefault.aspx?tabid=56 Thanks, M.Mamedov
[PHP-DB] Database Search Engine
Hi, I have many databases, each full up of more than 20 tables. I need to perform search based on search criteria entered by users. Does anyone know effective way of performin this task? Waiting for your comments. Regards, Muhammed Mamedov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database Abstraction Layer?
I don't think that DB_DataObject will create a nicce SQL. I think it's better to write it yourself (you know when you have large data sets its better to handle the work youurself)... But your comments on that PEAR::DB is a good package and that many others depend on it makes it the favorite one, I am right?.. And one more question : A guy from this list told that MDB supports XML files (can create db from an XML file and ...) . What do you all think about it? Regards, Muhammed Mamedov - Original Message - From: Justin Patrin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:26 PM Subject: Re: [PHP-DB] Database Abstraction Layer? There's also PEAR's DB_DataObject which does build SQL for you. The join syntax isn't set up to be totally DB independant yet, but it can and will be. Paul Miller wrote: PEAR is great from what I hear. The issue you are going to run into with DB independence is not the function calls which could be handled with something as simple as sqlalphp. It is the SQL calls themselves. The two options I have found is a SQL library with unembeded SQL or the Propel solution. Either way adds a significant time to coding and product release initially. - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:07 AM To: [EMAIL PROTECTED]; phpdb Subject: Re: [PHP-DB] Database Abstraction Layer? Hmm.. Thank you for you sql picks:) But what do you guys think aabout Pear :: DB? Is it as effective as these Paul's picks? Thank you. Muhammed Mamedov - Original Message - From: Paul Miller [EMAIL PROTECTED] To: phpdb [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] Database Abstraction Layer? There are a couple of products out there that I am about to start testing, starting first with: - SQL Relay http://sqlrelay.sourceforge.net/ This product uses its on C interfaces to interact with DBs and different programming languages. It addresses a bunch of items in the PHP DB calls. Connection pooling and load balancing. - Propel http://propel.phpdb.org/ Extensive templates create the SQL definition files you need to setup your database and the classes you need to work with your data model in your PHP scripts. The classes for your object model are generated from a simple XML schema and any customizations are written in plain PHP. This will effectively that add SQL and DB dependence out of your mix. This is PHP5 also. HTH - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:31 AM To: phpdb Subject: [PHP-DB] Database Abstraction Layer? Hello everybody, What do you think is the best method to abstract php code from a specific database?. Make PHP code 100% database independent?.. Waitin' for your comments. Muhammed Mamedov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- paperCrane Justin Patrin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Database Abstraction Layer?
Hello everybody, What do you think is the best method to abstract php code from a specific database?. Make PHP code 100% database independent?.. Waitin' for your comments. Muhammed Mamedov
Re: [PHP-DB] Database Abstraction Layer?
Thanks Ricardo for your comments. What do you think guys: ADODB or PEAR::DB ? - Original Message - From: Ricardo Lopes [EMAIL PROTECTED] To: Muhammed Mamedov [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:21 AM Subject: Re: [PHP-DB] Database Abstraction Layer? You have ADODB and PEAR DB that both work as abstraction layer. I have used ADODB and seems to me that is very good, yet i have not tested PEAR DB... To make php code 100% database independent is not very easy, depends of what are you going to do with your code. Use the ADODB or PEAR functions every time possible, and avoid the using of sql statements in your code because you have to carefull design then to be database independent but that can be a very difficult task. - Original Message - From: Muhammed Mamedov [EMAIL PROTECTED] To: phpdb [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:31 AM Subject: [PHP-DB] Database Abstraction Layer? Hello everybody, What do you think is the best method to abstract php code from a specific database?. Make PHP code 100% database independent?.. Waitin' for your comments. Muhammed Mamedov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database Abstraction Layer?
Hmm.. Thank you for you sql picks:) But what do you guys think aabout Pear :: DB? Is it as effective as these Paul's picks? Thank you. Muhammed Mamedov - Original Message - From: Paul Miller [EMAIL PROTECTED] To: phpdb [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:44 PM Subject: RE: [PHP-DB] Database Abstraction Layer? There are a couple of products out there that I am about to start testing, starting first with: - SQL Relay http://sqlrelay.sourceforge.net/ This product uses its on C interfaces to interact with DBs and different programming languages. It addresses a bunch of items in the PHP DB calls. Connection pooling and load balancing. - Propel http://propel.phpdb.org/ Extensive templates create the SQL definition files you need to setup your database and the classes you need to work with your data model in your PHP scripts. The classes for your object model are generated from a simple XML schema and any customizations are written in plain PHP. This will effectively that add SQL and DB dependence out of your mix. This is PHP5 also. HTH - Paul -Original Message- From: Muhammed Mamedov [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 2:31 AM To: phpdb Subject: [PHP-DB] Database Abstraction Layer? Hello everybody, What do you think is the best method to abstract php code from a specific database?. Make PHP code 100% database independent?.. Waitin' for your comments. Muhammed Mamedov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Different character sets
Try Unicode (UTF-8) encoding... Make charset=utf-8 an your pages Muhammed Mamedov turkmenweb.com - Original Message - From: Christine Clerc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 3:59 PM Subject: [PHP-DB] Different character sets Hi, My pages collect short texts from different languages through HTML forms. The texts are stored in a MySQL database. Then, they are used in HTML pages. Problem 1 : the carriage returns don't show back up. Problem 2 : The character above chr128 are not coded properly (obviously) Problem 3 : what about other character sets (russian for example) Thank you for any information on those subjects. Christine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP-DB] multi-language site
Thank you for your help Martin, I am aware of the seperation stuff you are talking. There is a much more professional term for that 'Design Patterns' use in JAVA (I tell you as a JAVA professional).. I am also aware of need for code and design seperation.. What I meant here is that NOT every project needs this! If you are on a small project it is much easier to write straight forward, without making this hard seperation.. By the way thanks for HTML_Template_IT advice.. I will check that out. If you have any other advice I am waiting.. What do you think guys how it is better to seperate PHP code from Design (HTML)? Regards, Muhammed Mamedov turkmenweb.com - Original Message - From: Martin Marques [EMAIL PROTECTED] To: Muhammed Mamedov [EMAIL PROTECTED]; Cc: Ignatius Reilly [EMAIL PROTECTED]; phpdb [EMAIL PROTECTED] Sent: Friday, January 16, 2004 10:21 PM Subject: Re: [PHP-DB] multi-language site Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Let me disagree with you! :-) I a multi-tiered design yuo have a client layer, a server layer (this should be the PHP pages on the server), and the database layer (simply for storage). Now, the server layer is easier to maintain if you have it devided in a buissness layer and a presentation layer. The presentation layer should have programs that print the results. Now, to make it even easier to maintain your code, abstraction of HTML code from the PHP code is the best way to go. It make the PHP more readable, and the HTML easy to edit by non programmers. Further on this issue: Consider that there are lots of dynamic stuff like news, and there are thousands of users and all data is stored in a database. Currently data is stored as a simple text. And I want to provide users (or their graphic editors) to display these news on their page in the way they like. So, to achieve this task I need a nice seperation of code and design. We may not achieve a 100% seperate work, but at least a graphical designer (who doesn't know any PHP) has to be able to develop a new design for his customers (our user) with ease. I think you should point to HTML_Template_IT (pear.php.net) -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática | Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Embedded DB
If you have enough time, wait till PHP5.0. They are going to embed sqlite into it. Regards, Muhammed Mamedov turkmenweb.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:47 PM Subject: RE: [PHP-DB] Embedded DB You could try sqlite. http://www.sqlite.com/ would give you more details on sqlite, http://hu.php.net/sqlite is the PHP manual pages for the sqlite extension (PHP4). You can download the php_sqlite.dll extension for windows here as well. Neil Morgan -Original Message- From: GUIRAUDOU [mailto:[EMAIL PROTECTED] Sent: 16 January 2004 10:08 To: [EMAIL PROTECTED] Subject: [PHP-DB] Embedded DB Hi the List, Could somebody tell me if it exists embedded database . I would like to integrate a small database in a terminal that has not a big memory size. Please tell me if this kind of database exist and please give me some information / an Internet site where found it. Regards Michel GUIRAUDOU -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] multi-language site
Hello Ignatius, I am working on a project which requires a CLEAR seperation of code and appearance. Think of this: There is a page which lists news from DB in a specific manner (latest 10 added, and next,prev links on the bottom). Of course this requires some PHP code which will retrieve data from DB and display it. Firstly, designers design appearance of the page (in pure HTML/css) and then coders re-code that page embedding pieces of PHP code. What I want to do is to make this process as easy as possible for designers/coders. I am familiar with XML and XSLT, but in practise never used XSL to transform XML... What do you suggest? Waiting for your suggestions. M.Mamedov - Original Message - From: Ignatius Reilly [EMAIL PROTECTED] To: Dan Hewins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 8:03 PM Subject: Re: [PHP-DB] multi-language site I would not consider a DB-based design. I use two approaches (sometimes mixed): 1. Write content in XML files (one per language) and transform them with XSLT. This is nice for mostly content-based sites. 2. Write the complete application in English and translate it with the excellent PHP gettext() extension. Makes it fast, efficient and very cheap to maintain. A better option for web applications. In any case the user's language must be stored in a session variable. HTH Ignatius _ - Original Message - From: Dan Hewins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 18:50 Subject: [PHP-DB] multi-language site Forgive me if this is pedestrian or has been covered before. I'm new to the list and I haven't used PHP too much (yet). Here's my question: I'm looking to use PHP for an upcoming site project where the site needs to be in either English or Spanish. Would PHP be a good approach? I was envisioning having a database with every text bit and image with text in it in two columns, one for English, and one for Spanish. Then each web page would reference some kind of global variable (a cookie?) to determine whether to pull the images and text from the English column or the Spanish column. Does this sound like a good approach? Is PHP capable of something like this? Thanks for any help or suggestions you can give. Dan Hewins -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] multi-language site
Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Further on this issue: Consider that there are lots of dynamic stuff like news, and there are thousands of users and all data is stored in a database. Currently data is stored as a simple text. And I want to provide users (or their graphic editors) to display these news on their page in the way they like. So, to achieve this task I need a nice seperation of code and design. We may not achieve a 100% seperate work, but at least a graphical designer (who doesn't know any PHP) has to be able to develop a new design for his customers (our user) with ease. I also wonder if XSLT can accept any php code? Any suggestions? M.Mamedov. - Original Message - From: Ignatius Reilly [EMAIL PROTECTED] To: Muhammed Mamedov [EMAIL PROTECTED]; phpdb [EMAIL PROTECTED] Sent: Friday, January 16, 2004 3:41 PM Subject: Re: [PHP-DB] multi-language site Preliminary note: ALL projects should require a CLEAR seperation of code and appearance. Now: To do what you describe, if you present your data as a HTML table, I would suggest retrieving data from the DB as an arra, and using the PEAR HTML_Table class to display them. Very easy to learn and extremely powerful. In addition you can use XSLT if the news are stored as XML strings in the DB. HTH Ignatius _ - Original Message - From: Muhammed Mamedov [EMAIL PROTECTED] To: Ignatius Reilly [EMAIL PROTECTED]; phpdb [EMAIL PROTECTED] Sent: Friday, January 16, 2004 13:57 Subject: Re: [PHP-DB] multi-language site Hello Ignatius, I am working on a project which requires a CLEAR seperation of code and appearance. Think of this: There is a page which lists news from DB in a specific manner (latest 10 added, and next,prev links on the bottom). Of course this requires some PHP code which will retrieve data from DB and display it. Firstly, designers design appearance of the page (in pure HTML/css) and then coders re-code that page embedding pieces of PHP code. What I want to do is to make this process as easy as possible for designers/coders. I am familiar with XML and XSLT, but in practise never used XSL to transform XML... What do you suggest? Waiting for your suggestions. M.Mamedov - Original Message - From: Ignatius Reilly [EMAIL PROTECTED] To: Dan Hewins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 8:03 PM Subject: Re: [PHP-DB] multi-language site I would not consider a DB-based design. I use two approaches (sometimes mixed): 1. Write content in XML files (one per language) and transform them with XSLT. This is nice for mostly content-based sites. 2. Write the complete application in English and translate it with the excellent PHP gettext() extension. Makes it fast, efficient and very cheap to maintain. A better option for web applications. In any case the user's language must be stored in a session variable. HTH Ignatius _ - Original Message - From: Dan Hewins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 18:50 Subject: [PHP-DB] multi-language site Forgive me if this is pedestrian or has been covered before. I'm new to the list and I haven't used PHP too much (yet). Here's my question: I'm looking to use PHP for an upcoming site project where the site needs to be in either English or Spanish. Would PHP be a good approach? I was envisioning having a database with every text bit and image with text in it in two columns, one for English, and one for Spanish. Then each web page would reference some kind of global variable (a cookie?) to determine whether to pull the images and text from the English column or the Spanish column. Does this sound like a good approach? Is PHP capable of something like this? Thanks for any help or suggestions you can give. Dan Hewins -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL query...
Try this SELECT DISTINCT(file_name), Count(file_name) AS cnt FROM $table_name WHERE date BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by cnt; desc Regards, Muhammed Mamedov tmchat.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 1:01 PM Subject: [PHP-DB] SQL query... SELECT DISTINCT(file_name), Count(file_name) FROM $table_name WHERE date BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by ??? desc In the above sql statement, I'm trying to achieve: 1. select all file names, between two dates. 2. list them, and order by the highest number of occurences of count() Basically, it's for a download tool we have, and my boss wants to easily be able to see the top downloaded files. It all works, but not the 'order by' bit... what do I have to order by... it's not 'file_name', and 'order by count(file_name0' causes an error... thoughts? Cheers, Tris... * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Problem, Special String Character...please help
You can encode string before sending it out. Try htmlspecialchars($str, ENT_QUOTES).. before sending string - from PHP manual: The translations performed are: a.. '' (ampersand) becomes 'amp;' b.. '' (double quote) becomes 'quot;' when ENT_NOQUOTES is not set. c.. ''' (single quote) becomes '#039;' only when ENT_QUOTES is set. d.. '' (less than) becomes 'lt;' e.. '' (greater than) becomes 'gt;' - Hope this helps, Muhammed Mamedov tmchat.com - Original Message - From: Ferry CS [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 12:20 PM Subject: [PHP-DB] PHP Problem, Special String Character...please help Hai... I have problem with manipulating the string... How to send the string with special character included to the other pages... For example the string Father Son, when I send into other page the display become Father Example special characters are , +, , , etc How to fix it??? Thanks very much for your kind attention Best Regards, Ferry PHP sample file 1 : string_test.php html ? $title=Father Son; echo the real title : $title; ? br pa href=string_display.php?stitle=? echo $title;?next page/a/p /html file 2 : string_display.php html ? echo in this pagebr; echo the title : $stitle; ? pCould you fix this problem??/p Pthe title should be Father Sonp pthe problem is using the special character ( , +, , , , etc)/p br pa href=string_test.phpback/a/p /html _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Error or installation problem?
Try to edit php.ini file. There you specify the path of MySQL. After you ugraded that path maybe changed, maybe this is the cause of the problem. Regards, Muhammed Mamedov turkmenweb.com - Original Message - From: Chris Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 26, 2003 8:16 AM Subject: [PHP-DB] PHP Error or installation problem? Hi there everyone, I just upgraded my Linux installation of MySQL from 3.23 to 4.0 (Well, the latest production build). In Webmin everything is fine, I can login etc . BUT with PHP 4, the version I used for 3.23 with no modifications (Which may be the problem?) I am having problems connecting tot he server, and with PHPMyADMIN I get the following error: cannot load MySQL extension HELP I am so confused and I need my DB up as soon as possible :-( Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Dilemma (PDA based solution??)
try XHTML or simply do some WAP around it will be the easiest thing... from PDA, in a WAP browser, you will just send needed requests to your current system or maybe you'd like to use J2ME? I am experienced in this this - J2ME rulez 'em all :) Regards, Muhammed Mamedov - Original Message - From: Robert Sossomon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 26, 2003 4:59 PM Subject: [PHP-DB] Dilemma (PDA based solution??) OK folks, I've been working on a quote system for a while and now the boss has added a new twist. He wants to be able to hook a PDA up to it, push a single button, and the system transmit and receive data including: New prices, customers, data, etc... I figure I am going to have to run some MySQL, PHP, Apache on the PDA itself so that all the information can be local, but I was wondering if anyone has had to do this or maybe had some pointers? Thanks, Robert ~~~ I'd love to, but... The President said he might drop in. ~~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remove all instances of a character....
Try this : mysql_query(DELETE FROM YOURTABLE WHERE YOURCOLUMN_NAME=';'); Saygilarla, Muhammed Mamedov - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 1:12 PM Subject: [PHP-DB] Remove all instances of a character I have a MySQL database, with around 500 entries in one table... I've noticed that many entries have an erroneous ';' in the one of the fields. What I need to do, is tell MySQL to go through the ENTIRE table and find any instances of ' ; ' and them delete them... leaving the rest of the data intact. I'll run along to google now, and mysql.org, but it's xmas eve, and I'm feeling lazy.. ;-) Cheers, Tris... * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database Array Question
! - sign adds a negative meaning to the statement.
Thus,
if(!isset($_SESSION['uid'])) means = If (NOT isset($_SESSION['uid'])))
you know that if(statement) will work if statement returns a true
value...so if $_SESSION['uid'] is already set(has some value),
isset($_SESSION['uid']) will also return a true value...
so, by writting if(!isset()) { ...some_actions... }, some_actions will be
executed only if uid session is not set (doesn't contain any value).
Hope this helps,
Muhammed Mamedov
- Original Message -
From: Kieran Hood [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 22, 2003 1:26 PM
Subject: [PHP-DB] Database Array Question
I'm new to PHP and was wondering if there's any better way of retrieving
the records from the query other than using an array (This query will only
return 1 row):
$auth = mysql_query(SELECT username, userlevel, password, email FROM
users WHERE id = '.$_SESSION['uid'].');
while ($row = mysql_fetch_array($auth))
{
$password = $row['password'];
}
Also, can anyone tell me what the relevance of adding '!' is to an if
statement eg.
This:
if(!isset($_SESSION['uid']))
Instead of this:
if(isset($_SESSION['uid']))
Thanks
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Re:Subject: DB, XML and sign
Then thing is that I have a string to play with AFTER form submission.. So if user enters something like this Say hello to Alex Özgür to my PHP file this will be sent like Say hello to Alex Özg#304;r. You see there are 2 ampersands here, and only one should be removed - the one just after Alex . As you say I can use JavaScript on the Browser(Client) side, but it an option I don't want to use. I want everything to be done on Server side to be 100% assured that everything worked fine. One way to do this is maybe using regular expression, so that i.e. say Do not remove ampersand if it is followeb by # sign, 3 letters and ; right aferwards, in any other cases just remove it..what do you think? And what will the reg. expr. be in this case? Any other suggestions? Regards, Muhammed Mamedov - Original Message - From: Neil Smth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, December 19, 2003 2:27 AM Subject: Re:Subject: DB, XML and sign htmlspecialchars() will deal with the following special characters : And so you might find these will be converted into XML entities intact, and prevernt these causing problems. As you pointed out though, users can also enter other values which will cause problems in an XML parser, for example UTF-16 values in a parser expecting UTF-8. I recommend if possible, that you check for XML support in the browser. Then, use 'loadXML' or equivalent from the form field, and place this value.xml in a hidden form field. That way, your users browser will convert any unsafe characters to XML equivalents (usually #12345 format). If XML support fails (use a javascript try catch block or set the XML form field to empty), set another form field so you can switch on htmlspecialchars() at the server if required. Cheers - Neil. At 17:33 18/12/2003 +, you wrote: Message-ID: [EMAIL PROTECTED] From: Muhammed Mamedov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Thu, 18 Dec 2003 18:51:06 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_01CF_01C3C597.E5096E80 Subject: DB, XML and sign Hello everyone, I read input from user, then via XML send it to DB. thing is that when user enters sign XML is no more well-formatted, what causes error. Does anyone has any suggestions on how to remove sign from user input, considering that data entered by users can be multilingual, that is ö character is being converted to some unicode #234; character which also contains sign, but this one doesn't cause any problem - any other user entered signs should be removed or should be translated to unicode #033. Your help will be appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] DB, XML and sign
Hello everyone, I read input from user, then via XML send it to DB. thing is that when user enters sign XML is no more well-formatted, what causes error. Does anyone has any suggestions on how to remove sign from user input, considering that data entered by users can be multilingual, that is character is being converted to some unicode #234; character which also contains sign, but this one doesn't cause any problem - any other user entered signs should be removed or should be translated to unicode #033. Your help will be appreciated. Muhammed Mamedov
Re: [PHP-DB] Hello
Welcome Rodrigo! Start checking php.net for object/clasess check out this mirror site of php.net http://php.oregonstate.edu/manual/en/ref.classobj.php By the way I don't know if we have from Brazil here... M. Mamedov - Original Message - From: Rodrigo Kochenburger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 10:33 PM Subject: [PHP-DB] Hello Hi everybody, i'm new in this list, so let me introduce my self. My name is Rodrigo and i'm from brazil, so sorry if my english isnt correct. let me know know if there's anothers brazilians here. And i'd like to starting using this to ask about some tutorial or something like that to help me with Software Architecture in PHP using Oriented Object Programming. Thanks a Lot. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Another question
Really?
What is the reason for that?...
Muhammed.
- Original Message -
From: Duane Lakoduk [EMAIL PROTECTED]
To: 'Constantin Brinzoi' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, December 15, 2003 3:17 PM
Subject: RE: [PHP-DB] Another question
You can avoid the prompt when using javascript to close the window if you
use this:
function closeit(){
window.opener = top;
window.close();
}
Now, window will close without prompting.
hth,
Duane
-Original Message-
From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 6:15 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another question
Is there a php function that closes a browser window?
I know there is a javascript function (window.close), but I
can't use it
because it complains that the window is not opened by javascript
(window.open).
I looked over the function reference but I didn't find anything about
this problem.
TIA
Constantin Brinzoi
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Another question
Could you provide the code you use for destroying your session?
Because if you destroy it session_unregister($session_name) then no need
for browser closing.
But if you don't destroy it, then it will be destroyed automatically after
you close the browser.. this is how PHP works.
Regards,
Muhammed.
- Original Message -
From: Constantin Brinzoi [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]
Sent: Monday, December 15, 2003 4:05 PM
Subject: Re: [PHP-DB] Another question
The reason is that I want to logout from the system.
I destroyed the session but the session is still there!
So I'm thinking of closing the window for good!
Do you have any ideas how to make it work?
Aurel.
On Mon, 2003-12-15 at 15:25, Muhammed Mamedov wrote:
Really?
What is the reason for that?...
Muhammed.
- Original Message -
From: Duane Lakoduk [EMAIL PROTECTED]
To: 'Constantin Brinzoi' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, December 15, 2003 3:17 PM
Subject: RE: [PHP-DB] Another question
You can avoid the prompt when using javascript to close the window if
you
use this:
function closeit(){
window.opener = top;
window.close();
}
Now, window will close without prompting.
hth,
Duane
-Original Message-
From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 6:15 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another question
Is there a php function that closes a browser window?
I know there is a javascript function (window.close), but I
can't use it
because it complains that the window is not opened by javascript
(window.open).
I looked over the function reference but I didn't find anything
about
this problem.
TIA
Constantin Brinzoi
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Another question
I see.
You use something like this right?
header('WWW-Authenticate: Basic realm=My Realm');
header('HTTP/1.0 401 Unauthorized');
and of course want to get rid of PHP_AUTH_USER and PHP_AUTH_PW variables
which are then return.
Well..this is something different than the session. If you look at PHP
documentation these are represented as globals. So most probably you will
have to unset() them (using $Global['var_name'] maybe .?)
M.Mamedov
- Original Message -
From: Constantin Brinzoi [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, December 15, 2003 4:13 PM
Subject: Re: [PHP-DB] Another question
I destroy the session with:
session_destroy()
The file is deleted from the /tmp directory (which is good) but after
that I want to go on another page (public space) and get rid of
PHP_AUTH_USER and PHP_AUTH_PW.
How can I do it?
On Mon, 2003-12-15 at 16:10, Muhammed Mamedov wrote:
Could you provide the code you use for destroying your session?
Because if you destroy it session_unregister($session_name) then no
need
for browser closing.
But if you don't destroy it, then it will be destroyed automatically
after
you close the browser.. this is how PHP works.
Regards,
Muhammed.
- Original Message -
From: Constantin Brinzoi [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]
Sent: Monday, December 15, 2003 4:05 PM
Subject: Re: [PHP-DB] Another question
The reason is that I want to logout from the system.
I destroyed the session but the session is still there!
So I'm thinking of closing the window for good!
Do you have any ideas how to make it work?
Aurel.
On Mon, 2003-12-15 at 15:25, Muhammed Mamedov wrote:
Really?
What is the reason for that?...
Muhammed.
- Original Message -
From: Duane Lakoduk [EMAIL PROTECTED]
To: 'Constantin Brinzoi' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 3:17 PM
Subject: RE: [PHP-DB] Another question
You can avoid the prompt when using javascript to close the window
if
you
use this:
function closeit(){
window.opener = top;
window.close();
}
Now, window will close without prompting.
hth,
Duane
-Original Message-
From: Constantin Brinzoi [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 6:15 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another question
Is there a php function that closes a browser window?
I know there is a javascript function (window.close), but I
can't use it
because it complains that the window is not opened by javascript
(window.open).
I looked over the function reference but I didn't find anything
about
this problem.
TIA
Constantin Brinzoi
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Very complex query
You can also DISTINCT command instead.
UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
using)
Hope this helps,
M.Mamedov
- Original Message -
From: Justin Patrin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 9:52 AM
Subject: [PHP-DB] Re: Very complex query
Mike U. Petrov wrote:
Hi every1!
Excuse me for maybe offtopic but I need help on mysql database.
I have 4 tables, and here are some important extractions from 'em:
objects{
object_id;
name;
}
users{
user_id;
nick;
date;
}
notes{
user_id;
object_id;
}
object_properties{
object_id;
property_name;
property_value;
}
I need to get EACH object_id from notes with ONLY ONE of corresponding
user_id's. Also for each object I need it's name from objects and
property
from object_properties where property_name = 'foo'. And for each of
obtained
user_id I need it's nick and it's date.
Does anyone know how to do it just by one mysql query?
Thanx...
Mike U. Petrov
Use unique(user_id). And please don't reply to a previous post when
posting a new threadit screws up threading.
--
paperCrane Justin Patrin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Very complex query
Give me exactly the sample table with data and show what you want there.
I will try to help you.
M.Mamedov
- Original Message -
From: Mike U. Petrov [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 10:17 AM
Subject: RE: [PHP-DB] Re: Very complex query
No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I
need ONE user_id per one object_id.
Mike U. Petrov
-Original Message-
From: Muhammed Mamedov [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Very complex query
You can also DISTINCT command instead.
UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am
using)
Hope this helps,
M.Mamedov
- Original Message -
From: Justin Patrin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 9:52 AM
Subject: [PHP-DB] Re: Very complex query
Mike U. Petrov wrote:
Hi every1!
Excuse me for maybe offtopic but I need help on mysql database.
I have 4 tables, and here are some important extractions from 'em:
objects{
object_id;
name;
}
users{
user_id;
nick;
date;
}
notes{
user_id;
object_id;
}
object_properties{
object_id;
property_name;
property_value;
}
I need to get EACH object_id from notes with ONLY ONE of corresponding
user_id's. Also for each object I need it's name from objects and
property
from object_properties where property_name = 'foo'. And for each of
obtained
user_id I need it's nick and it's date.
Does anyone know how to do it just by one mysql query?
Thanx...
Mike U. Petrov
Use unique(user_id). And please don't reply to a previous post when
posting a new threadit screws up threading.
--
paperCrane Justin Patrin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL question
It should be as follows: SELECT * FROM x_table WHERE name Like = %part_of_name% Hope this helps, M.Mamedov - Original Message - From: Constantin Brinzoi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:51 PM Subject: [PHP-DB] SQL question I know it is possible to search a database like this: SELECT * FROM x_table WHERE name=%part_of_name% but I don't know for sure the correct command. Could you tell me the right syntax? TIA Aurel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL question
I am sorry without equal = sign SELECT * FROM x_table WHERE name Like %part_of_name% there are actually three ways to do this: %part_of_name% part_of_name appears anywhere %part_of_namepart_of_name appears at the end art_of_name% part_of_name appears at the begining M.Mamedov - Original Message - From: Muhammed Mamedov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:00 PM Subject: Re: [PHP-DB] SQL question It should be as follows: SELECT * FROM x_table WHERE name Like = %part_of_name% Hope this helps, M.Mamedov - Original Message - From: Constantin Brinzoi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:51 PM Subject: [PHP-DB] SQL question I know it is possible to search a database like this: SELECT * FROM x_table WHERE name=%part_of_name% but I don't know for sure the correct command. Could you tell me the right syntax? TIA Aurel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27.11.2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Creating an autonumber setup
First of all let me tel you that in MySQL you don't have an option to define your autonumber value format. You can use this approach which is flexible: Make users to enter the autonumber format for each of these: Quote, Project,Customer,Supplier,Invoice Quote - user entere Q+ as autonumber for for example. In this case autonumbers for Quotes will be like Q+1, Q+2...etc.. Of course for each of these autonumber format you have to use a seperate table to store these user entered values. Then each time you add a Quote, you will look at that table in order to understand the autonumber format of the Quote, and add next autonumber value(Of course autonumber assigned to quote should be stored in the same row with the current Quote). Here is what I mean: AUTONUMBER_FOFMATS_TABLE - ITEM| USERID | FORMAT | AUTONUMBER_ID (autoincrement) --- Quote 3Q + 1 Project 3P-2 Customer 3 Supplier.. 4 Invoice... ...etc Quote 4Quote # Project 4Project # ... ... QUOTE_TABLE -- QUOTE_ID | USERID | - 13 (QUOTE FORMAT WILL BE Q + somenumber) 24 (QUOTE FORMAT WILL BE Quote + somenumber) Hope this helps. Sincerely, Muhammed Mamedov Richi Watts [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, Could someone explain to me how this could be done? I have seen something similar using Access on a local machine and would like to know if it is posible to do it in PHP and Mysql In a project management web based applicaton using PHP and Mysql I would need to allow the user to create Quote Project Customer Supplier Invoice Each time one of the above will be created it needs to be assigned an autonumber. So If 3 quotes were created today each quote would receive an autonumber, maybe something like the fllowing: yy/MM/dd-01 yy/MM/dd-02 yy/MM/dd-03 Creating the autonumber isn't the problem if I want to have a set way of numbering, however, is it possible for me to allow the user to enter a setup page or something and define the way the autonumbers will look like and be created for quotes, projects, customers, suppliers or invoice. let's say I have five Project Managers each working with a seperate version of the app. The app currently sets each new project created with a default autonumber (let's say yy/MM/dd-01, -02, 03 and so on), however, each Project Manager wants their database to number new projects differently: PM1 = yy/MM/dd-a PM2 = dd/MM/yy-01 PM3= YY- (Number being the amount of projects this year) PM4 = PROJ- (Number being the amount of projects ever) PM5 = P-yyMMdd1 Instead of me creating a different application for each project manager can I allow them to setup their own number system in a set up page? Many thanks for any ideas Richi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Help on a simple SQL problem
Below I include solutions to your problems.
* now I am in Turkey/Istanbul.. I graduated from a University herebut I
am,myself, citizen of Turkmenistan
Muhammed Mamedov
Software Engineer
YTM.com.tr
- Original Message -
From: Ferry CS [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 1:56 AM
Subject: the expalinationRe: need help
Thanks very much for your nice attention.
I really appreciate that..
Oke, I will expalin more detail...
For example I use mysql database
Database = bathroom
Table = inventory
Field=item,date,price
mysql select * from inventory;
item__date__price
soap_1/9/03_100
soap_3/9/03_500
soap_5/9/03_200
toothpaste_1/9/031000
in php editor the script look like:
?
$db_name = bathroom;
$table_name = inventory;
$connection = @mysql_connect(localhost, , ) or die(Couldn't
connect.);
$db = @mysql_select_db($db_name, $connection) or die(Couldn't select
database.);
$sql = SELECT * FROM $table_name Order by item;
$result = @mysql_query($sql,$connection) or die(Couldn't execute
query.);
//how to write the script here to display result on group with subtotal
and
grand total
$tmp = mysql_query(select distinct item from inventory,$connection); //to
select DISTINCT items: soap,toothpaste,etc..
while ($row = mysql_fetch_array($tmp)) {
$it = $row[0]; //will contain one of soap or toothpaste,etc.
$str = SELECT date,price FROM inventory WHERE item='$it' ;
$tmp2=mysql_query($str,$connection);
echo ITEM: .$row[0].br; //will write Item: soap;
echo DATEPRICEbr;
while($row2 = mysql_fetch_array($tmp2) ) { //here I contain all
occurencies of a certain item
echo $row2[0].___.$row2[1];
}
}
//Would you help me with the script (coding)...
?
The result that I love to be display look like :
-
Item: soap
-
Date_Price
1/9/03100
3/9/03500
5/9/03200
Total_800
---
Item: toothpaste
-
Date_Price
1/9/03___1000
Total1000
---
Grand Total__1800
=
Have you understand with my explaination? I hope You will
By the way, where You from, I mean country city?
May I guess? I think You from Kazaktan or Ukrain or may be India..
Am I right? You know, I from Indonesia, South East Asia
Oke, can't wait your reply... thanks very much
Wish You always be happy
Best Regards,
Ferry
- Original Message -
From: Muhammed Mamedov [EMAIL PROTECTED]
To: Ferry CS [EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 12:28 AM
Subject: Re: need help
Hi Ferry,
I couldn't understand your problem exactly. Could you please explain it
in
more detail.
* By the way if you are asking me to help you with ODBC, want to tell
you
that I haven't used it before. I always use Unix based approach with
MySQL
+
PHP .. actually in Windows you can also make the same stuff without
using
ODBC.
Sincerely,
M.Mamedov
- Original Message -
From: Ferry CS [EMAIL PROTECTED]
To: Muhammed Mamedov [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 12:21 AM
Subject: need help
Hi Muhammed..
I knew You from php forum and I see that You great on php and a nice
one
also
My name Ferry from indonesia ..
I have a problem to make report in php
Connect with ODBC
I like to display report look like
-
Item: soap
-
Date_Price
1/9/03100
3/9/03500
5/9/03200
Total_800
---
Item: toothpaste
-
Date_Price
1/9/03___1000
Total1000
---
Grand Total__1800
=
How to make it??
Would You like to help with codeplease
Thanks very much.
Best Regards
Muhammed Mamedov
Software Engineer
YTM.com.tr
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: copy tables between db's
What DBMS are you using? ... Oracle, MySQL or what? If MySQL then you don't have to make it manual with PHP code (I mean copy process) .. use something link PhpMyAdmin - there it is very easy to do it. -- Muhammed Mamedov Software Engineer YTM.com.tr Jeremy [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need to copy some tables from one mysql database to another mysql database on the same server. I looked at the php manual and couldn't find it...I found stuff on mysqlhotcopy, but it doesn't look like that will do what I need it to do, or maybe I'm reading the manual wrong. Can someone please show me how to do this? To be specific, it's just a table with a list of US states in it... table name: states fields: state_id, name, abbreviation Thanks, Jeremy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP Oracle connection across page.
eventhough I've never used Oracle with PHP here is my suggestion:
create a file that will have your DB connection strings and include it in
every PHP file which uses Oracle connection.
EXAMPLE:
[dbCon.php] file
[EMAIL PROTECTED]($o_conn_vars[username], $o_conn_vars[password],
$o_conn_vars[db]);
[myPhpFile.php]
include_once(dbCon.php);
//Write youe queries now.
--
Muhammed Mamedov
Software Engineer
YTM.com.tr
Syho [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have the following problem, please help me. Many thanks.
Script 1:
?php
[EMAIL PROTECTED]($o_conn_vars[username],
$o_conn_vars[password],
$o_conn_vars[db]);
//Parse sql statement
//Execute sql statement.
..
...
require('2.inc');
?
___
2.inc:
// This script will switch the brower to script2.php
html
form name=s_form action=script2.php method =POST
/html
script2.php:
?php
My problem is, how to get back the Oracle database connection in this
script? Please advise.
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
