[PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

2007-03-22 Thread Lasitha Alawatta
Hi All, I have a sql script unable to execute. Because I need to insert double-coats ( ) also to one field(SPParams field). Ones I execuit this using mysql_query($sql), it gives Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING error message. $strSql = ;

[PHP-DB] MySQL Foreign Key Issue

2007-03-25 Thread Lasitha Alawatta
Hello, I have 2 issue, regarding MySQL Foreign Key. I have two tables; Table 01 CUSTOMER column name characteristic SID Primary Key Full_Name Table ORDERS column name characteristic Order_ID Primary Key Order_Date Customer_SID Foreign Key Amount When I run

[PHP-DB] XAMPP InnoDB Issue

2007-03-28 Thread Lasitha Alawatta
Hi All, Any one have experiance on using XAMPP with configure MySQL InnoDB engine. This is my.cnf configuration settings, but it not working = # skip-innodb # Uncomment the following if you are using InnoDB tables

[PHP-DB] Access another server aspx page

2007-04-24 Thread Lasitha Alawatta
Hi All, I need to access .aspx page using .php page. It's like this. 01) I have a login.aspx home.aspx pages in different server (IIS6, already hosted at different location: www.abc.com/login.aspx ). 02) I have the username password for login to the above application

[PHP-DB] Creating all key combinations passwords

2007-05-20 Thread Lasitha Alawatta
Hi All, I'm going to create all key combinations; simple-letter passwords and store those in to MySql DB. Using = a-z (simple letters) Password length = 6 Number of possibilities = 26 x 26 x 26 x 26 x 26 x 26 = 308,915,776 This is my code: ?php for($i=0;$i

[PHP-DB] Get MySql DB diagram

2007-05-27 Thread Lasitha Alawatta
Hi All, Any one knows a free software / tool that can use to gat MySql DB diagram. Like MS SQL 2000, you can get the database diagram. Cheers, Lasitha. DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the

[PHP-DB] Get MySql DB diagram

2007-05-28 Thread Lasitha Alawatta
Hi All, Any one knows a free software / tool that can use to gat MySql DB diagram. Like MS SQL 2000, get database diagram. Cheers, Lasitha. DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named

[PHP-DB] PHP Security Basics - web seminar

2007-05-30 Thread Lasitha Alawatta
Hi All, PHP Security Basics - Must-Knows for Everyone Presenter: John Coggeshall, Zend Solutions Consultant Target audience: Anyone who believes Security is important in Web Application development and deployment Duration: 45 minutes, including QA Security is not just important when

RE: [PHP-DB] PHP Security Basics - web seminar

2007-06-14 Thread Lasitha Alawatta
Hi All, If you would like to download the presentation you can find it here: http://www.zend.com/webinar Reg., Lasitha -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 11:14 AM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: Re: [PHP-DB

RE: [PHP-DB] Zend optimizer question

2007-07-04 Thread Lasitha Alawatta
:44:39 Lasitha Alawatta wrote: Hi All, If we are using encoded php script (by using Zend Guard) then we MUST have to install Zend Optimizer to the web server to run that script file. Otherwise we need not to install Zend Optimizer (no point of having it Zend optimizer). Is above

RE: [PHP-DB] SMS sending script

2007-07-15 Thread Lasitha Alawatta
Hi Asim, To do this, (01) U need to have a SMS gateway (just find a sms gateway service provider). (02) Then they will provide u to URL to pass ur message to them, with receiver's phone number (http - post). 03) Then u can write small php script to send ur data to them. (But need to have

RE: [PHP-DB] SMS sending script

2007-07-15 Thread Lasitha Alawatta
Hi Asim, Read this article http://www.codewalkers.com/c/a/Miscellaneous/Sending-SMS-Thru-HTTP/ Reg., Lasitha DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you must not

[PHP-DB] MySQL- Stored Procedures Views

2007-08-22 Thread Lasitha Alawatta
Hi All, Any body has experience using MySQL Stored Procedures Views with PHP. How is the performance of using SPs in mysql. Lasitha Alawatta Application Developer Destinations of the World Holding Establishment P O Box: 19950 Dubai, United Arab Emirates DOTW DISCLAIMER

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

2007-10-03 Thread Lasitha Alawatta
Hi J, Checkout this, SELECT * FROM tbl_company where id not in (SELECT companyID from tbl_contacts) Regards, Lasitha Alawatta Application Developer Destinations of the World Holding Establishment P O Box: 19950 Dubai, United Arab Emirates ( Ph +971 4 295 8510 (Board) / 1464 (Ext.) 7

[PHP-DB] MySQL Identifying worst-performing codes

2007-10-04 Thread Lasitha Alawatta
Hello friends, There is a tool call idera (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes - Identifies performance bottlenecks such as the worst-performing stored procedures,

Re: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Lasitha Alawatta
Hi TK, Try this, input type=Submit name=butSubmit value=Submit ?php if($_POST['butSubmit']=='Submit') {? disabled=disabled ?php }? Regards, Lasitha -Original Message- From: T K [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 3:09 PM To: php-db@lists.php.net Subject:

RE: [PHP-DB] Re: MySQL Identifying worst-performing codes

2007-10-06 Thread Lasitha Alawatta
Identifying worst-performing codes Lasitha Alawatta wrote: There is a tool call “idera” (SQL diagnostic manager). Basically it is a performance monitoring and diagnostics tool. It has a feature; Identifying of worst-performing codes – Identifies performance bottlenecks

RE: [PHP-DB] Autorunning a file

2007-10-10 Thread Lasitha Alawatta
If u don't have permission to ur command line; Try to solve ur thing by using 01) Meta refresh OR 02) JavaScript - setTimeout() function. Regards, Lasitha -Original Message- From: Alexander [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 7:34 AM To:

[PHP-DB] ER Diagramming tool for MySQL

2007-10-20 Thread Lasitha Alawatta
Hi All, Does anyone know of a GOOD ER Diagramming tool for MySQL? I would preferably a free/open source one. Regards, Lasitha DOTW DISCLAIMER: This e-mail and any attachments are strictly confidential and intended for the addressee only. If you are not the named addressee you

RE: [PHP-DB] ER Diagramming tool for MySQL

2007-10-21 Thread Lasitha Alawatta
[mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2007 1:50 AM To: Lasitha Alawatta Subject: Re: [PHP-DB] ER Diagramming tool for MySQL you could use dbdesign, download in http://superdownloads.uol.com.br/download/140/dbdesigner/ 2007/10/20, Lasitha Alawatta [EMAIL PROTECTED]: Hi All

RE: [PHP-DB] ER Diagramming tool for MySQL

2007-10-23 Thread Lasitha Alawatta
://www.newfreedownloads.com/Software-Developer/Miscellaneous/CASE-Studio-2.html ) 02) Toad (http://www.quest.com/toad-for-mysql/ ) Thanks, Lasitha. From: Rafael Costa Pimenta [mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2007 1:50 AM To: Lasitha Alawatta Subject: Re: [PHP-DB

RE: [PHP-DB] force to download file

2007-12-17 Thread Lasitha Alawatta
Hi , Try with this header. $export_file = YourFileName.xls; ob_end_clean(); ini_set('zlib.output_compression','Off'); header('Pragma: public'); header(Expires: Mon, 26 Jul 1997 05:00:00 GMT); // Date in the past

RE: [PHP-DB] About mysql_connect()

2008-02-06 Thread Lasitha Alawatta
Pls refer http://www.php.net/mysql_connect -Original Message- From: Prabath Kumarasinghe [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 2:07 PM To: php-db@lists.php.net Subject: [PHP-DB] About mysql_connect() Hi All When I stop mysql database whole application will

[PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Lasitha Alawatta
replication. There is a delay (5-7 minutes) of that data replication process. We notice that it's because of MySQL table locking. Your comments are highly appreciated. Many thanks in advance and best regards, Lasitha Alawatta Application Developer Destinations of the World

RE: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Lasitha Alawatta
Oky, Sorry for that.. J From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 8:49 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] MySQL replication delaying issue I did not say: do not ask on this list. I said: you would get

RE: [PHP-DB] MySQL replication delaying issue

2008-02-26 Thread Lasitha Alawatta
Hello, Thanks a LOT... Best Regards, Lasitha From: Thiago Pojda [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 26, 2008 9:51 PM To: Lasitha Alawatta Cc: php-db@lists.php.net Subject: RES: [PHP-DB] MySQL replication delaying issue That's ok, good luck with your problem