Software Sarathi ( PHP Link Master )

Magento abandoned cart for guest/unconfirmed users

2013-08-22T23:15:00.001-07:00

http://stackoverflow.com/questions/13584054/magento-abandoned-cart-for-guest-unconfirmed-users

SELECT entity_id, customer_firstname, customer_email, items_count, grand_total, created_at
FROM sales_flat_quote
WHERE entity_id NOT IN (SELECT quote_item_id AS quote_id FROM sales_flat_order_item) 
AND items_count >0
AND customer_email IS NOT NULL
ORDER BY `sales_flat_quote`.`created_at` DESC

http://stackoverflow.com/questions/15148275/when-does-magento-consider-a-cart-to-be-abandoned-wheres-that-time-limit-set




As you probably know the setting is located here:

Admin => system => Configuration => Sales => Checkout => Quote Lifetime (days)

This will add the setting to the database (core_config_data table) with path:

checkout/cart/delete_quote_after

This path is used in the code on:

app/code/core/Mage/Sales/Model/Observer.php line 54

Check the code here.

So when someone is adding something to a cart it will be updated. When a customer logs in and his cart is there it will be updated. When a cart is not updated for the last 30 days. It will be removed.

Extra information:

In case you wonder when this code is used, It is used by the cronjob of magento.

check: App/code/core/Mage/Sales/etc/config.xml line 1732

Check code here.

    
        
            
                0 0 * * *

sales/observer::cleanExpiredQuotes

Hope this helps.

Magento Shopping Cart Abandonment

2013-08-22T02:07:00.001-07:00

All this can be done using Magento, but as you said, this is a very broad question. I'll give answers to the specific topics, but I suggest you take time to study the fundamentals of Magento module development. Here is an excellent tutorial by Alan Storm (read the whole series).

Get list of abandoned carts

In Magento, the cart is simply a wrapper for the sales/quote object, so that is the entity you will be working with.
Instead of adding increments to a abandoned_duration attribute, I suggest simply checking against the updated_at field.

$adapter = Mage::getSingleton('core/resource')->getConnection('sales_read');
$minutes = 15;
$from = $adapter->getDateSubSql(
    $adapter->quote(now()), 
    $minutes, 
    Varien_Db_Adapter_Interface::INTERVAL_MINUTE
);
$quotes = Mage::getResourceModel('sales/quote_collection')
    ->addFieldToFilter('converted_at', $adapter->getSuggestedZeroDate())
    ->addFieldToFilter('updated_at', array('to' => $from));

This will give you a collection (think of it as an array with methods) of all quotes that haven't been updated for 15 minutes. You can iterate over them like an array

foreach ($quotes as $quote) {
    /* @var $quote Mage_Sales_Model_Quote */
}

Magento Cronjobs

In Magento, all cron jobs are listed in the configuration structure. So first you need to add it to the config.xml of your module (refer to the linked tutorial for more information on Magento configuration).
This XML registers a cronjob with Magento.


    
        
            
                */15 * * * *

your_module/observer::processAbandonedCarts Now, whenever Magento runs the cronjob, it will instantiate the class your_module/observer and call the processAbandonedCarts() method.
In order for Magento to process configured cronjobs, you need to set the system up to do so. This consists of two parts: the system configuration and the triggering of the cron jobs.
The system configuration is done in the administrative interface under System > Configuration > System > Cron (Scheduled Tasks)
The triggering consists of setting up a way to periodically execute the cron.php (or cron.sh) script in the Magento root directory. This can be done using a regular crontab entry (man 5 crontab on any decent unix system for more information). Another option preferred by many is to execute the cron.php script through a curl or wget call so the processing user ID matches the regular Magento user ID (i.e. the Apache user). This might be important if APC caching is configured, but this is getting off topic.
However, on topic is that you need to call it often enough so it matches the settings you specify in the administrative interface!
I generally recommend executing the cron.php script every 5 minutes. If there is nothing scheduled it will simply exit.
One really useful extension for Magento when working with cronjobs is Aoe_Scheduler. It adds much of the user interfaces for cronjobs and interactive functionality that should be part of the core system.

Other

Sending the data to a web service is not Magento specific, but rather regular PHP, so I'll wont go into more detail.
To delete a cart, simple call $quote->delete() on the loaded sales/quote instance.
Please ask mor specific questions for further information.

http://stackoverflow.com/questions/9223790/where-to-start-with-magento-shopping-cart-abandonment

Related Link
http://www.magentocommerce.com/magento-connect/anatta-design-abandoned-carts-2536.html

Creating a Downloadable Product in OpenCart

2013-06-03T02:32:00.000-07:00

http://www.inmotionhosting.com/support/edu/opencart/303-creating-a-downloadable-product-in-opencart

http://www.opencarttutorial.com/how-to-setup-your-opencart-catalog/downloadable-products/

At times, you may want to sell a digital product such as an image, audio file, or e-book. This can be easily accomplished in OpenCart. To offer a downloadable product, you'll first have to upload the file within OpenCart and then you'll need to link the file to a product.

Important! Remember to uncheck the "Requires Shipping" checkbox or your customers will be charged shipping fees by mistake.

Uploading Your Digital Product

Log into your OpenCart Dashboard
Go to Catalog > Downloads
Click “Insert” in the upper right corner

Fill in the fields with a download name, Select the file to upload on your local computer, and type in the number of downloads allowed per user purchase

Click “Save”

Linking the download file to a product

Log into your OpenCart Dashboard
Go to Products
Click “Insert” to create a new product or click “Edit” next to an existing product
Click on the “links” tab
Scroll towards the bottom of the page, go to the “Downloads” section and select the file you want to be made available on this product

While still editing this product, click on the “Data” tab and scroll down to the section called “Weight”. Enter a weight of “0” (zero) in the field. This tells OpenCart it is a downloadable product
Click on “Save” in the upper right corner

If you need further assistance please feel free to ask a question in our support center website.

Google DFP setup

2013-01-31T04:01:00.002-08:00

http://www.labnol.org/internet/google-dfp-tutorial/14099/

Compare directories via diff

2013-01-04T02:28:00.001-08:00

diff -rq dirA dirB

diff -qr dirA dirB | grep -v -e 'DS_Store' -e 'Thumbs' | 
sort > diffs.txt

http://hints.macworld.com/article.php?story=20070408062023352

YII framework dynamic Table Model

2012-12-19T01:54:00.002-08:00

/**
* CActiveRecord implementation that allows specifying
* DB table name instead of creating a class for each table.
*
* Usage (assuming table 'user' with columns 'id' and 'name'):
*
* $userModel = DynamicActiveRecord::forTable('user');
* //list existing users
* foreach ($userModel->findAll() as $user)
* echo $user->id . ': ' . $user->name . '
';
* //add new user
* $userModel->name = 'Pavle Predic';
* $userModel->save();
*
* @author Pavle Predic
*/
class DynamicActiveRecord extends CActiveRecord
{
/**
* Name of the DB table
* @var string
*/
protected $_tableName;

/**
* Table meta-data.
* Must redeclare, as parent::_md is private
* @var CActiveRecordMetaData
*/
protected $_md;

/**
* Constructor
* @param string $scenario (defaults to 'insert')
* @param string $tableName
*/
public function __construct($scenario = 'insert', $tableName = null)
{
$this->_tableName = $tableName;
parent::__construct($scenario);
}

/**
* Overrides default instantiation logic.
* Instantiates AR class by providing table name
* @see CActiveRecord::instantiate()
* @return DynamicActiveRecord
*/
protected function instantiate($attributes)
{
return new DynamicActiveRecord(null, $this->tableName());
}

/**
* Returns meta-data for this DB table
* @see CActiveRecord::getMetaData()
* @return CActiveRecordMetaData
*/
public function getMetaData()
{
if ($this->_md !== null)
return $this->_md;
else
return $this->_md = new CActiveRecordMetaData($this);
}

/**
* Returns table name
* @see CActiveRecord::tableName()
* @return string
*/
public function tableName()
{
if (!$this->_tableName)
$this->_tableName = parent::tableName();
return $this->_tableName;
}

/**
* Returns an instance of DynamicActiveRecord for the provided DB table.
* This is a helper method that may be used instead of constructor.
* @param string $tableName
* @param string $scenario
* @return DynamicActiveRecord
*/
public static function forTable($tableName, $scenario = 'insert')
{
return new DynamicActiveRecord($scenario, $tableName);
}
}

YII Framework - Highcharts Extension - datetime issue Resolved

2012-12-06T22:48:00.000-08:00

$this->Widget('ext.highcharts.HighchartsWidget', array(
'options'=>'{
"title": { "text": "MYSQL Replication" },
"xAxis": {
"title": { "text": "Month" },
"type": "datetime",
"dateTimeLabelFormats": {
"day": "%e"
}
},
"yAxis": {
"title": { "text": "Time" },
"type": "datetime",
"dateTimeLabelFormats": {
"hour": "%H"
}
},
"tooltip": {
"xDateFormat": "%Y-%m-%d"
},
"series": [
{ "name": "success", "data": [[x_ms,y_ms],[x_ms,y_ms]],"pointStart": utc_ms, "pointInterval": date_ms},
{ "name": "failure", "data": [[x_ms,y_ms],[x_ms,y_ms]],"pointStart": utc_ms, "pointInterval": date_ms}
]
}'
));

<script src="http://code.highcharts.com/highcharts.js"></script>

SoapUI for ubuntu

2012-12-04T05:32:00.000-08:00

http://askubuntu.com/questions/198896/what-is-a-simple-free-soap-client-gui

You can still use SOAPUI
download the script from here and save it on the disk.
then from a terminal

cd /path-to-directory-where-you-downlaod-it
sudo chmod +x soapUI-x32-4_0_0.sh
sudo ./soapUI-x32-4_0_0.sh

Install and configure OAuth in Ubuntu

2012-11-05T22:42:00.000-08:00

http://djpate.com/2010/10/07/how-to-install-oauth-support-for-php-on-ubuntu/

First of all you need to make sure you already have php-pear and php5-dev.

If you are unsure just run

`1`	`sudo` `apt-get` `install` `php-pear php5-dev` `make`

now run

`1`	`sudo` `pecl` `install` `oauth`

Personnaly I had an error while compiling

`1`	`/usr/include/php5/ext/pcre/php_pcre.h:29: fatal error: pcre.h:`

To fix that just install : libpcre3-dev

`1`	`sudo` `apt-get` `install` `libpcre3-dev`

Once it’s done just add extension=oauth.so at the end of your php.ini (located in /etc/php5/apache2/php.ini) file and restart Apache.

Drupal Blog Page Not Found

2012-09-26T03:33:00.002-07:00

If you have the problem of not being able to see the Blog Module page after enabling it, and you are using Clean URL for your site, then it's *probably* because you have accidentally created a subdomain with the name 'blog' (e.g. http://blog.example.com), or you have a subdirectory named 'blog' on your website's root folder (www, htdocs or public_html). You should be able to see Drupal's Blog Module after you remove the subdomain / subdirectory with that same name.

The reason you cannot view the Blog Module at your website's URL (e.g. http://www.example.com/blog) when you have a subdomain / subdirectory with the same name is because when using Clean URL, Drupal rewrites the Blog Module address (http://www.example.com/?q=blog to http://www.example.com/blog) using .htaccess file. This causes confusion on the webserver, because when we try to access http://www.example.com/blog, it doesn't know which URL it is suppose to display. It could be the URL that Drupal has rewritten, or it could also be the subdirectory that you have in your web root folder.

The same concept also apply with all the URL Aliases that you have created with your Drupal. Make sure you don't have a folder with the same name as your aliases, or else you will get a Page Not Found error.

Wordpress - Exclude images from showing in the_content() - Resolved

2012-09-06T22:52:00.001-07:00

<?php
ob_start();
the_content('Read the full post',true);
$postOutput = preg_replace('/<img[^>]+./','', ob_get_contents());
ob_end_clean();
echo $postOutput;
?>

Ref. Link: http://wordpress.org/support/topic/exclude-images-from-showing-in-the_content

XML Sitemap generation with php and mysql

2012-09-05T03:29:00.000-07:00

<?php
$host = "localhost"; // host name
$user = "user"; // database user name
$pass = "password"; // database password
$database = "dbname"; // database name
// connecting to database
$connect = @mysql_connect($host,$user,$pass)or die (@mysql_error());
// selecting database
@mysql_select_db($database,$connect) or die (@mysql_error());

// default header(don't delete)
header("Content-Type: text/xml;charset=iso-8859-1");
echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';

// mytable = your content table name
$query = @mysql_query("SELECT * FROM mytable");
while($row = @mysql_fetch_array($query)){
// [url] = content url
$url = $row['url'];
// [time] = content date
$date = date("Y-m-d", $row['time']);

// NO CHANGES BELOW
echo
'<url>
<loc>' . $url .'</loc>
<lastmod>'. $date .'</lastmod>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>
';
}
echo '</urlset>';?>

.htaccess code ( Optional )

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule (.*)\.xml(.*) $1.php$2 [nocase]
</IfModule>

Ref: Link: http://www.urphp.com/php-and-mysql-google-sitemap/

Reset Mysql Root Password in Xampp -- Resolved

2012-08-21T06:24:00.003-07:00

Go to your xampp\mysql\bin\ folder
Edit my.ini and insert skip-grant-tables below [mysqld]
Restart MySQL
Set new password for your root user by running UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root' in phpMyAdmin in the mysql database (or just leave it like this if MySQL cannot be accessed from remote hosts)

XAMPP Apache server not working on internal network

2012-07-17T07:03:00.002-07:00

The problem was that the Windows Firewall had port 80 blocked. To fix this, I opened Windows Firewall, clicked Change Settings, went to the Exceptions tab, and then "Add Port". I set Name to "Web Server (TCP 80)", Port Number to 80, and Protocol to TCP and that was it.

Theming the contact form in Drupal 6

2012-06-28T22:34:00.000-07:00

3 Different Ways

1)So I copy page.tpl.php to page-contact.tpl.php and did changes

2)A different method would be to theme the contact form not the whole page.

function YOURTHEMENAME_theme() {
  return array(
    'contact_mail_page' => array(
      'arguments' => array('form' => $form),
    ),         
  );
}functionYOURTHEMENAME_contact_mail_page($form) {
  $output = drupal_render($form);
  $output .= '
'. t('Text to add to bottom of form') .'

';
  return $output;
}
?>

3)Theming the contact form in Drupal 6

PHP Mail Function header to avoid spam issue

2012-06-16T01:07:00.001-07:00

$headers = "From: \"".$from_name."\" <".$from_email.">\n";
$headers .= "To: \"".$to_name."\" <".$to_email.">\n";
$headers .= "Return-Path: <".$from_email.">\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: text/HTML; charset=ISO-8859-1\n";

mail($to, $subject, $message, $headers);

editor auto adds paragraph tag after save article or mod

2012-06-14T03:45:00.001-07:00

In the administrator, go to Extentsions -> Plugin Manager -> Editor-TinyMCE
In "Parameters" panel, find "New Lines"
Change it to "BR Elements"

Web Application Development Process

2012-06-03T23:27:00.001-07:00

Ref: http://www.comentum.com/web-application-development-process.html

Requirements for Developing Web Applications

by Bernard Kohan

1. Roadmap Document: Defining Web Application, Purpose, Goals and Direction

(Performed by client / project owner)
This initial task is an important part of the process. It requires putting together the Web Application project goals and purpose.
This step establishes your project's clear direction and helps you focus on setting and achieving your goal.
The Roadmap Document will specify the Web Application's future plan and objectives with approximate timelines.

2. Researching and Defining Audience Scope and Security Documents

(Performed by client / project owner, or by Comentum, as a fee service)
This task requires researching the audience/users, and prospective clients (if any), and creating an Analytic Report which includes the following approximate assessments:
- Type of audience for usability purposes:
Creating Statistic Reports on the percentage of users: elementary, average, advanced, the audience ages, and gender
- Type and level of access:
Creating an Access Report, specifying users' access of Intranet, Internet, Extranet - single-level, multi-level
- Type of audience for planning the security level:
Creating a Risk Statistical Document based on users' characteristics, zone's fraud level, application's industry security breaches, and history of the audience's security breaches
- Quantitative statistics on audience:
Creating a Potential Visitors Report, broken down by reasonable periodic time frames

3. Creating Functional Specifications or Feature Summary Document

(Performed by client / project owner)
A Web Application Functionality Specifications Document is the key document in any Web Application project. This document will list all of the functionalities and technical specifications that a web application will require to accomplish. Technically, this document can become overwhelming if one has to follow the Functional Specifications rule and detail out each type of user's behavior on a very large project. However, it is worth putting forth the effort to create this document which will help prevent any future confusion or misunderstanding of the project features and functionalities, by both the project owner and developer. A typical functional specification will list every user's behavior, for example:

When a visitor clicks on the "Add to Cart" button from the Product Showcase page, the item is added to the visitor's shopping cart, the Product Showcase page closes and the user is taken to the Shopping Cart page which shows the new item in the cart.

If creating a functional specification document is overwhelming to you, I recommend starting out by creating a Specification Document or Feature Summary Document by either creating the sample screen shots of the web application screens or creating a document that includes a summary list of the application's features, for example:

Product / Inventory Summary Showcase: displays a summary of items for sale, stock number, item name, short description, one photo, price, and Add to Cart button.
Product / Inventory One Item Showcase: displays the detail of one inventory item: stock number, item name, long description, multiple photos (up to 10 photos), price, and Add to Cart button.

4. Third Party Vendors Identification, Analysis and Selection

(Performed by client / project owner)
This task requires researching, identifying and selection of third party vendors, products and services such as:

Web Application Development Company - for detail information: How to Hire a Good Web Application Development Company
Merchant Account and Payment Gateway - for detail information: Guide to Merchant Accounts and Payment Gateways
SSL Certificate (example providers: Verisign, GeoTrust)
Managed Server / Colocation Server Provider - for detail information: Managed Hosting Comparison
Server, Network, Firewall, Load Balancer Equipment (may not needed if using a managed server - example: DELL, Cisco 5520 Load Balancer)
Fulfillment Centers (example: Shipwire)

5. Technology Selection, Technical Specifications, Web Application Structure and Timelines

(Performed by Comentum)
This document is the blueprint of the technology and platform selection, development environment, web application development structure and framework.
The Technical Specifications Document will detail out the technology used, licenses, versions and forecasts.
The Timeline Document will identify the completion dates for the Web Application's features or modules.

6. Application Visual Guide, Design Layout, Interface Design, Wire framing

(Created by the collaboration of the project owner and Comentum)
One of the main ingredients to a successful project is to put together a web application that utilizes a user's interactions, interface and elements that have a proven record for ease of use, and provide the best user experience.
This process starts out by creating the visual guide, wire framing or simply sketching out the user interface and interactions of the web applications by Comentum's Creative and Usability teams of experts.
Once the Application Interface and Interaction Models are approved, Comentum's creative team design the interface for the web application.

7. Web Application Development

(Executed by Comentum's Development Team)
The application's Design Interface is turned over to Comentum's Development Team who take the following steps to develop the project:

Create the Web Application Architecture and Framework
Design the Database Structure
Develop / Customize the Web Application Module, Libraries and Classes
Complete the Development and Implement all Functionalities - Version 1.0

8. Beta Testing and Bug Fixing

(Executed by Comentum's Beta Testers)
Comentum's vigorous quality assurance testing help produce the most secure and reliable web applications.
Version 1.0 of the Web Application is thoroughly tested and any program bugs are addressed and fixed.

World map in Flash

2012-05-31T04:21:00.003-07:00

http://backspace.com/mapapp/#download

Security Checklist for PHP website - Input from $_GET, $_POST, $_COOKIE, and $_REQUEST is considered tainted.

2012-05-14T04:14:00.002-07:00

http://markjaquith.wordpress.com/2009/09/21/php-server-vars-not-safe-in-forms-or-links/

Common example:

<form action="php echo $_SERVER['PHP_SELF']; ?>">

Another example:

<a href="php echo $_SERVER['PHP_SELF']' ?>?foo=bar">link titlea>

Here are my two rules regarding $_SERVER['PHP_SELF'] or $_SERVER['REQUEST_URI'] in forms:

Do not use them
If you use one of them, escape it with esc_url()

Setting Up Virtual Hosts for XAMPP

2012-05-10T04:12:00.000-07:00

Ref: http://sawmac.com/xampp/virtualhosts/

Launch Notepad and open the hosts file located at C:\windows\system32\drivers\etc\hosts. (You may not be able to see the windows folder–some files are hidden by default under Windows. Here are instructions to make those files visible.) On Vista, you’ll also need to have access to change the hosts file. To do that, launch Notepad by right clicking on Notepad from the Start menu and choosing "Run As Administrator." This will give you permission to edit and save the file.

At the end of that file type:
127.0.0.1 clientA.local
127.0.0.1 is how a computer refers to itself—it’s an IP address that points back to the computer, kind of like a computer’s way of saying "ME." The second part (clientA.local) is the "domain" of the virtual host. To visit this domain in a Web browser you’d type http://clientA.local. You don’t have to add the .local part to the hosts files—you could just as easily add 127.0.0.1 clientA and access the site in your Web browser with http://clientA—but I find it helpful for differentiating between a real Web site out on the Internet like clientA.com, and the test sites I have running on my own computer.

Save and close the hosts file. That finishes the first part of this task. You’ve prepared your computer to handle requests to http://clientA.local. Now you need to tell the Web server, Apache, how to handle those requests.

In Notepad open the Apache configuration file located at C:\xampp\apache\conf\extra\httpd-vhosts.conf

At the bottom of that file add:

NameVirtualHost *
  <VirtualHost *>
    DocumentRoot "C:\xampp\htdocs"
    ServerName localhost
  </VirtualHost>
  <VirtualHost *>
    DocumentRoot "C:\Documents and Settings\Me\My Documents\clientA\website"
    ServerName clientA.local
  <Directory "C:\Documents and Settings\Me\My Documents\clientA\website">
    Order allow,deny
    Allow from all
  </Directory>
</VirtualHost>

The first five lines of code turn on the Virtual Host feature on Apache, and set up the C:\xampp\htdocs folder as the default location for http://localhost. That’s important since you need to be able to access the XAMPP web pages at http://localhost/ so that you can use PHPMyAdmin.
The stuff in yellow represents a single Virtual Host. You’ll add one chunk of code just like this for each Virtual Host (or Web site) on your computer
You’ll need to modify the stuff highlighted in blue. The first item — DocumentRoot — indicates where the files for this site are located on your computer. The second part–ServerName — is the name you provided in step 2 above: the virtual host name. For example, clientA.local. The third item — the part — is the same path you provided for the DocumentRoot. This is required to let your Web browser have clearance to access these files.

Save and close the Apache configuration file, and restart Apache from the XAMPP control panel.

Start a Web browser and type a URL for the virtual host. For example: http://clientA.local/.
You should now see the home page for your site.

Xampp with PHP and Oracle from Mysql

2012-05-06T23:57:00.001-07:00

Oracle Based Changes

1. Install oracle any version
2. configure with database creation ( database will create automatically )
3. import mysql tables to oracle
4. Note hostname, username, password and SID.
5. While start the xampp if NLS_LANG error will come for oci8 follow the below steps
a.) run --> regedit --> hkey local machine --> softwares --> oracle --> NLS_LANG key rename or delete

b.) restart system.

PHP Based Changes After Installed Xampp

1. In your XAMPP Start Page, go to phpinfo, look for string oci8. If string found it indicate that connection to oracle is available, otherwise to activate connection do the following steps:
2. Open the currently used php.ini file by looking at the phpinfo, from the XAMPP folder.
3. Find string ;extension=php_oci8.dll. Remove the semicolon (;) ahead of the string to activate the oracle extension.
4. Save the php.ini file.
5. Download the “Instant Client Package – Basic” for Windows from the OTN Instant Client page. Unzip it to c:\instantclient_11_1
6. Edit the PATH environment setting and add c:\instantclient_11_1 before any other Oracle directories. For example, on Windows XP, follow Start -> Control Panel -> System -> Advanced -> Environment Variables and edit PATH in the System variables list.
7. Set desired Oracle globalization language environment variables such as NLS_LANG. If nothing is set, a default local environment will be assumed. See An Overview on Globalizing Oracle PHP Applications for more details.
8. Unset Oracle variables such as ORACLE_HOME and ORACLE_SID, which are unnecessary with Instant Client (if they are set previously).
9. Restart XAMPP (or Start if its not already started).
10. To make sure that connection to oracle database has successfully activated, go to phpinfo. Find string: oci8. If found, then XAMPP can now communicate with Oracle Database.

PHP Based sample connection

$conn = oci_connect('username', 'password', 'host:port/servicename');

$query = 'select table_name from user_tables';

$stid = oci_parse($conn, $query);

oci_execute($stid, OCI_DEFAULT);

while ($row = oci_fetch_array($stid, OCI_ASSOC)) {

foreach ($row as $item) {

echo $item." | ";

}

echo "
\n";

}

oci_free_statement($stid);

oci_close($conn);

ADODB Based Sample Connection

$DB = NewADOConnection("oci8");
$DB->Connect('localhost', 'system', 'system', 'orasrv');

Titanium Appcelerator How to disable separatorColor in table view ?

2012-04-18T23:05:00.002-07:00

Problem resolved in Android windows7

var tableview = Ti.UI.createTableView({
separatorColor: 'transparent'
});

Titanium MVC Framework

2012-04-18T06:33:00.002-07:00

http://johnkalberer.com/2011/09/08/mvc-for-appcelerator/

Titanium Studio install and configure in Windows 7

2012-04-17T06:36:00.000-07:00

1. Download and install Java JDK 1.6.x
2. Download and install android SDK version any with android2.1 API Level 7 ( then you can choose all additional apis )
3. Environmental Variable PATH setup as given below
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.6.0_29\bin;C:\Program Files\Android\android-sdk\tools;

SystemRoot --> Windows will take automatically
4. Download and Install Titanium Studio ( Titanium mobile-sdk will install continually with this )