Monday, August 27, 2012

Configure Xdebug with phpDesigner


1. Create a file with the name info.php in htdocs folder

<?php
phpinfo();
?>

2. Check the version of PHP that you had installed / using .
















3. Go to http://xdebug.org/download.php 

4. Download the correct version of the xDebug extension dll
In this case, I had downloaded php_xdebug-2.2.1-5.4-vc9.dll





5.  Copy the downloaded file and paste it in the following folder
 D:\PHP\XAMPP\php\ext

6. Ope the file D:\PHP\XAMPP\php\php.ini

7. Find the word / text "[xDebug]"

8. Paste the following lines of code just below the above searched tag
zend_extension="./ext/php_xdebug-2.2.1-5.4-vc9.dll"
xdebug.remote_enable=true
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9000
xdebug.remote_handler=dbgp
xdebug.profiler_enable=1
xdebug.dump.*
xdebug.profiler_output_dir=D:\PHP\Program Files\XDebugCache

 9. Restart the apache server

10. Start debugging in phpDesigner


Happy debugging !

Friday, August 24, 2012

CodeIgniter Tutorial and Sample Application Links

Here are the few links i found on the web for CodeIgniter tutorial/sample application:

http://video.derekallard.com/
http://godbit.com/article/introduction-to-code-igniter

http://www.mrforbes.com/wordpress/2007/05/13/a-quick-code-igniter-and-query-ajax-tutorial/

http://www.maestric.com/wiki/doku.php?id=php:codeigniter_template

http://68kb.com/2007/10/28/templating-with-codeigniter/

http://swik.net/codeigniter+Tutorial

http://www.michaelwales.com/2007/09/live-tutorial-codeigniter-blog/

http://mini-app.peccavi.com/page/docs

http://www.jimohalloran.com/2007/09/23/building-a-complete-codeigniterapplication-part-2/

http://pr0digy.com/category/mootools/

http://pr0digy.com/archives/

http://www.alexajax.com/

http://bleakview.orgfree.com/obsession/

http://www.4webby.com/freakauth/tutorials/using-zend-framework-omponents-in-code-igniter

http://www.4webby.com/freakauth/tutorials/ci-swift-mailer

http://www.ngcoders.com/php/pquery-for-code-igniter-v-15x/

http://www.glossopteris.com/journal/post/table-relationships-in-ci

http://simplepie.org/

http://www.phpinsider.com/php/code/ContentFeeder/

http://www.ciforge.com/CodeIgniter_ApiDocs_1.4.1/
You can find more links here:
http://www.blinklist.com/tag/codeigniter/

http://swik.net/codeigniter



Fore more result google with the exact keyword below
site: code igniter tutorial
site: code igniter ajax
site: code igniter jquery
site: code igniter xajax
site: code igniter mootool

Note: this content is taken from the website 
http://rakibulislam.wordpress.com/2007/11/07/codeigniter-tutorailsample-application-links/

Thanks to Rakibulislam for providing such wonderful list.


Wednesday, August 22, 2012

How to handel postback event in php

Method 1.

if (!isset($_POST)) {
    
//code here


Method2.

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
  
// handle POST here

Monday, June 25, 2012

Joining String


DECLARE @categories varchar(1000)
SET @categories = NULL
SELECT @categories = COALESCE(@categories + ',','') + CONVERT(VARCHAR(20),WIndApplicationID) FROM dbo.WIndApplications
WHERE WIndFormTypeID = 4

PRINT @categories


SELECT ',' + CONVERT(VARCHAR(20),WIndApplicationID)
FROM dbo.WIndApplications
WHERE WIndFormTypeID = 4
FOR XML PATH('')

Tuesday, May 15, 2012

Component with CLSID XXX failed due to the following error: 80070005 Access is denied


Issue:
Component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

[5/11/2012 2:02:45 PM] Error: Excel Extraction Failed :- Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

Solution:
1. In DCOMCNFG, right click on the My Computer and select properties.
2. Choose the COM Securities tab
3. In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for <Machine_name>\Users.
4. In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for <Machine_name>\Users