[PHP-DB] KEYBOARD
May pls. help me. Can anybody guide me whether virtual keyboard can be made using PHP. Actually i am developing a site for our internal use where we will not give keyboard to user, the data can be entered by help of touchscreen pasted on the monitor. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [PHP-DEV] KEYBOARD
May pls. help me. Can anybody guide me whether virtual keyboard can be made using PHP. Actually i am developing a site for our internal use where we will not give keyboard to user, the data can be entered by help of touchscreen pasted on the monitor. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] number format
hello, may pls. suggest me how i can retreive number before decimal and after decimal. for example 123456.7. I want to store 123456 in a variable and 7 in another. also how can i force the user by validations so that he can only enter data in this format only i.e. 123456.7. thanks with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] number format
hello, may pls. suggest me how i can retreive number before decimal and after decimal. for example 123456.7. I want to store 123456 in a variable and 7 in another. also how can i force the user by validations so that he can only enter data in this format only i.e. 123456.7. thanks with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Institute
Hi to all, May you pls. suggest me a good institute for learning PHP AND MYSQL in and around Delhi or Noida (INDIA). preferably Noida. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to add UPDATE,DELETE for inventory management system using sqlite db
yes you can add more submit buttons like save and give name them as update, select etc. etc. if i had in your place, i do the following:- for example - when user clicks on update buttons than one page should be opened asking information i.e. what fields he want to update etc. etc. and on a clicking a submit button which should be placed on the same page may be named as update, the data is updated. with best wishes balwant -Original Message- From: Aravalli Sai [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 3:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] how to add UPDATE,DELETE for inventory management system using sqlite db hi i had designed an user interface for inventory management system using sqlite db.i had used 'SAVE' button so far for inserting values into the database from the user. now i want to add some other buttons such as UPDATE,SELECT,DELETE...to the interface... can some one giv me an idea for doing this... thanks in advance regards, sai __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- 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] PHP Javascript
hi to all, can anybody guide me how to embed php script into javascript. actually i am using a function in javascript and want that when this fuctions is called than some values to be stored in php session so that the values can be displayed in next page. thanks with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] printer dialouge box
how i can open the printer dialouge box of browser in PHP. pls. help. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: I can't seem to get Max() to work
can anybody advise if there is any command so that MAX can be found in the data entered the columns. i mean to say suppose i have three columns col1 col2 col3 in a table now the MAX value to find from col1, col2, col3. with best wishes balwant -Original Message- From: David Robley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 10:54 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: I can't seem to get Max() to work On Thu, 28 Oct 2004 14:35, Chris Payne wrote: Hi there everyone, I can?t seem to get the below to work with PHP and MySQL: $sql = SELECT MAX(FoodItemNumber) FROM menuitemsubs; What am I doing wrong? I need the highest number from the column FoodItemNumber, but it doesn?t return anything unless I change the MAX() to a * and I don?t want that I need it to be the MAX() number as it isn?t an auto-increment field. Works a treat for me; au_linkid is a smallint which is not autoincrement, nd not indexed at all. mysql select max(au_linkid) from categ_link; ++ | max(au_linkid) | ++ |540 | ++ 1 row in set (0.03 sec) FoodItemNumber is an integer type? -- David Robley I Have To Stop Now, My Fingers Are Getting Hoarse! -- 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] Books
I found PHP and MySQL for Dynamic Web Sites (by Larry Ullman) very useful and quick guide as it gives many example also. i learned PHP from this book only. another book (which i have not yet seen but many people have recommended me) is PHP BLACK BOOK by peter moulding. Also friend, pls. do one favour for me, after finalsing the book may pls. also inform me the name for my reference. with best wishes balwant -Original Message- From: Huy Ton That [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 10:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Books Can anyone recommend me any good books that they return to for both information learning PHP maybe MySQL and/or reference? -- 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] pdf
hi all, i want to how i can save the data retrieved from mysql through php in pdf format. thanks for your help in advance. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] refresh the page on back
first of all excuse me for putting the non related question in this forum. but i am sure someone will help me. i want that whenever users press the browser back button, the page should be refreshed and than displayed. thanks for your help in advance. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ip address
i tried the $_SERVER['REMOTE_ADDR'] it is giving ip address of server which is hosting the webpage not the user's ip address. pls. suggest how can IP address of an user can be obtained. with best wishes balwant -Original Message- From: Philip Thompson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 30, 2004 3:45 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: getenv() alternative Oh, before I get a slew of emails about this one, I think I figured it out: $_SERVER['REMOTE_ADDR'] I knew it couldn't have been that difficult... brain fart! Sorry for wasting your time. ~Philip On Sep 29, 2004, at 5:02 PM, Philip Thompson wrote: Hi all. I am needing to obtain the IP address of a user who logs into the system. I tried to use `getenv(REMOTE_ADDR)`, however, this function does not work in ISAPI mode, which is what I am running. Is there an alternative to obtaining the IP address? I have looked around, but I cannot seem to find anything. Thanks in advance, ~Philip -- 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] User Activities
hi may pls. help me i am using PHP and MYSQL. is there any command through which i can record which user modifiyed the data through which command (insert / update / delete etc.) on which time and date in a table in mysql. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB]
excuse me pls., i am putting a question which is not related to this forum but i am sure somebody will help me i want to know whether in PHP submenu can be created under menu so that user put his mouse over the menu and submenu automatically displayed. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] session
Execuse me, i know i am not putting my question in right mail forum but i trust that many of you can give me the right answer. also request you to kindly give me email add. of mailing list where this type question should be put up. i am using session_cache_limiter(public); in one of my webpages, now when i click on logout (where i used session_destroy() function), it works well but when i press back button of brower it comes to my same page from where i logged out. i can not remove the session_cache_limiter(public) because i am using this function to remember data. is there any other option so that after logout the back button could not show the same page. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] select command denied to user
pls. help. i have grant all to one of my tables made in mysql. now when i want to retrieve the data through PHP, following error is coming = select command denied to user: '[EMAIL PROTECTED]' for table 'timeframe' = pls. advise what went wrong. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] select command denied to user
pls. help. i have grant all to one of my tables made in mysql. now when i want to retrieve the data through PHP, following error is coming = select command denied to user: '[EMAIL PROTECTED]' for table 'timeframe' = pls. advise what went wrong. with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to show this querry
try this SELECT start_date, end_date, project_title from tablename where month(start_date)=09 and year(start_date)=04 this will show only the data pertaining to 09 month and 04 year. hope this will resolve your problem. with best wishes balwant -Original Message- From: peppe [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 2:45 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] how to show this querry Hi , I have a problem with showing a query I have a table project with start date end date and project title I want to show only the projects that they are given in table for that month, for example project that starts 06-09-04 and ends 09-09-04 or ends 12-02-05 but nt the projects that starts 06-10-04 Any help will be appreciated -- 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] Sum
hi, i am developing a webpage by using PHP for inserting / displaying data on daily basis and storing the database in Mysql. now i want to make one report which gives sum on monthly basis. my table is containining two fields 1) date (in -MM-DD format) 2) unit_consumed (integer) with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] retrieved data from mysql to be shown in spreadsheet
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadsheet (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] retrieved data from mysql to be shown in spreadsheet
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] retrieved data from mysql to be shown in spreadsheet
May pls. advise me. I am developing a page using PHP for entering the data into tables made in mysql. I want that when user click on Reports button the data (which will retrieve from mysql) should be shown in Spreadshee (Calc) of Open Office. Pls. tell how it can be done. balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB]different heading
pls. help me. i have made one webpage where user for getting a report checks the checkbox as per his requirement and accordinly only that data is retrieved from mysql. i used array and loop for getting the data. now my problem is that by default column name (of mysql table) is displayed as heading let me explain suppose the column name of mysql table is == Enter_Date, Opening_Units etc. etc. than date is displayed under Enter_Date and Opening_Units i want to use different heading than column_name (even if underscore sign (_) between Opening_Units is removed i will be happy) but keep in my mind that i have many columns. thanks for your help. balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP5 not loading mysql.dll and mysqli.dll
may be you have not uncommented extension_dir=c:/php/ext/ (Directory in which the loadable extensions (modules) reside) please check. balwant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 3:47 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP5 not loading mysql.dll and mysqli.dll I've been trying to install mysql. I installed that new PHP5 that just came out with the zip file. I configured in php.ini where the .dll files are: c:/php/ext/. Then I uncommented php_mysql.dll and php_mysqli.dll. When I restarted apache 1.3.31, my server, it said that it could not find those files in c:/php/ext/. EX) PHP Startup: Unable to load dynamic library 'c:/php/ext/php_mysql.dll' - the specified module could not be found. Though the file is right there. So then I did research and found that those files needed libmysql.dll and libmysqli.dll to load. However, those files are already sitting nice and cozy in c:/php, and I copied them to c:/php/ext just in case. What's the problem? -- 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] Check Boxes
can somebody advise me i want to use checkboxes on my website, i want that if user selects some checkboxes (there will be more than 20 checkboxes), checkbox's value will be stored in variables and than SELECT query command will be run using these variables through PHP. but my problem is that in SELECT query command after each column name comma (,) is required and if i use the same than it is displaying You have an error in your SQL syntax near 'FROM form' at line 1 pls. help. balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Check Boxes
i am using following coding $a1 = $_POST['ch1']; $a2 = $_POST['ch2']; $a3 = $_POST['ch3']; if ($a1 or $a2 or $a3) { $query = SELECT $a1, $a2, $a3 FROM form; [EMAIL PROTECTED] ($query); } Enter_Dateinput type=checkbox name=ch1 value=Enter_Date Opening_Unitsinput type=checkbox name=ch2 value=Opening_Units Unit_Consumedinput type=checkbox name=ch3 value=Unit_Consumed -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 5:43 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Check Boxes balwantsingh wrote: can somebody advise me i want to use checkboxes on my website, i want that if user selects some checkboxes (there will be more than 20 checkboxes), checkbox's value will be stored in variables and than SELECT query command will be run using these variables through PHP. but my problem is that in SELECT query command after each column name comma (,) is required and if i use the same than it is displaying You have an error in your SQL syntax near 'FROM form' at line 1 How about showing us some code kind of hard to help without that... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL denying access to everything...Part 2
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'password' with grant option; try this out balwant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 12:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL denying access to everything...Part 2 Ok, thanks to many people's help, I have managed to install MySQL right and login as root with no password. However, MySQL will not allow to log in to my databases as root. Is this normal, because when I try it brings back the old access denies: [EMAIL PROTECTED] thing. So I thought maybe I just have to figure out how to create accounts, and then configure them to be all access. I have read the manual on creating accounts, but for some reason it doesn't work. Here is how it goes: I access mysql.exe and put in this: mysql GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' Then I hit enter. It starts me off with an indented down arrow and I finish the GRANT command. - IDENTIFIED BY 'password' WITH GRANT OPTION; Then I hit enter. IT gives me another down arrow. I hit enter again and again and again and all it does is give me more indented down arrows... What now? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php