Tuesday 17 December 2013

Download Source Code of eKash.net / eKash.ca and eKash.us - A payment processor just like Paypal / Moneybookers

eKash.Net Source Code

eKash.net is an online credit card processing company. We are uploading all source files including Database, Libraries and Documentation about the website. How you can create your own website like ekash.net or use it to understand the flow and data structure of the payment processor.


The website is php/MySQL driven and the script contains all important functionality documentation as well. However, you will have to use ur own bank accounts to integrate with ekash.net and Bank's API. Currently, integration of 3 banks is already live.




Remember, This is Actual backup of eKash.net , ekash.info, ekash.ca by kashmart.com


DOWNLOAD FILES >> CLICK HERE



Remember, This is absolutely free source code of ekash.net. And this source code is neither hacked nor stolen by any means.


Enjoy

Sunday 21 July 2013

How to get Records between two dates in MySQL / PHP when Date Field is of VARCHAR type

How to compare two dates in MySQL


 Some times, we need to compare two dates in a  mysql table but unfortunately date field is VARCHAR type. and you can't use sql commands like following

Select * from table where `fieldone` is between 'date1' and 'date2'

Remember, there is one basic THUMB rule when comparing two dates in mysql table. MySQL only compares Dates in Y-m-d format.
You can't compare dates in any other format than like '2000-03-29'.

So if you want to compare dates in any other format, you first need to convert dates to mysql date format and then compare them. Suppose dates are saved in DB like 19/01/2003 , we can write sql query which can convert d/m/Y format into mysql date format we can use mysql function str_to_date

str_to_date('19/01/2003,'%d/%m/%Y)
// this will convert date to 2003-01-19

so  you can make a query
select * from table where str_to_date('coulumn','%d/%m/%Y) between '2001-01-19' and '2012-04-01'

and this query will return all records between Jan 19,2001 to April 01, 2012 when mysql field type is "Varchar"

Remember the thumb rule : mysql only compares dates in "Y-m-d" format so before comparing dates, first convert the dates to mysql data format

Convert Date format to MySQL Date format in PHP


You can use date() function to convert date from one format to other especially in mysql date format.  here is an example,

$mysql_date = date('Y-m-d', strtotime($original_date));


Tuesday 19 March 2013

Download PHP / MySQL Ecommerce Website Developed in CodeIgniter

PHP/MySQL Shopping Cart developed in CodeIgniter

This is a simple php script to create your own shopping cart website and an easy project for the developers who are new to php and codeIgniter. The database file is also included which you will need to import to your database

How to run the script 

1) Copy "winegate" folder to  www directory of your webserver
2) create new database with a name like "winegate" and import tables from .sql file
3) go to application/config/database.php and update the database Username & Password


http://localhost/winegate -FRONT END
http://localhost/winegate/index.php/admin - ADMIN SECTION
admin user : admin
admin pass : admin

Front End Functionality
  • Create New User
  • Forget Password
  • Browse categories and Products
  • Select a Product
  • Checkout
  • Enter Order Details (Sender & Receiver)
  • Preview Order
  • Confirm Order
 Admin Functionality


  • View & Manage Users
  • View & Manage Categories
  • View & Manage Products
  • View & Manage Orders
This is a basic ecommerce website developed in PHP / MySQL, I hope it would help programmers to learn basics of an ecommerce website development in PHP / codeigniter. The website uses basic codeigniter validation as well.

https://drive.google.com/file/d/0B2_Eh6GZWqMkOHlFdmtZRnFPbnc/edit?usp=sharing




The website is developed using Adobe Dreamweaver 6.1
 **This PHP ECOMMERCE SCRIPT IN CODEIGNITER is absolutely free to modify, share or use in any form as you like.