Buying Items using Paypal
this is my first time using PDO i decided to make something hopefully useful
Features:
PDO::ODBC Database Connection
easy to understand code
protect against ';select delete fuckbitchhimoron;--'
items stored in a table
logs stored in another table (Thank you Captain Obvious)
if you found any ';select delete fuckbitchhimoron;--' exploits that actually work let me know and i'll fix it
NOTE: Coded in 1 hour if there's anything that doesn't work i'll fix it else i dont need comments like "SHITTY CODE" "POOR CODED" etc..
Download is in Attachmeeeents
Tables
Spoiler:
Code:
/*Navicat SQL Server Data Transfer
Source Server : SQL
Source Server Version : 100000
Source Host : localhost\SQLEXPRESS:1433
Source Database : WebsiteDB
Source Schema : dbo
Target Server Type : SQL Server
Target Server Version : 100000
File Encoding : 65001
Date: 2016-02-13 07:54:26
*/
-- ----------------------------
-- Table structure for _donateItems
-- ----------------------------
DROP TABLE [dbo].[_donateItems]
GO
CREATE TABLE [dbo].[_donateItems] (
[itemname] varchar(50) NOT NULL ,
[itemCode] varchar(50) NOT NULL ,
[itemPrice] varchar(10) NULL ,
[itemImage] varchar(8000) NULL ,
[itemDescription] varchar(200) NOT NULL ,
[itemPlus] int NULL ,
[uniqueID] varchar(50) NULL ,
[quantity] varchar(50) NULL
)
GO
-- ----------------------------
-- Table structure for _donateItemsLog
-- ----------------------------
DROP TABLE [dbo].[_donateItemsLog]
GO
CREATE TABLE [dbo].[_donateItemsLog] (
[id] int NOT NULL IDENTITY(1,1) ,
[username] varchar(50) NOT NULL ,
[txnID] varchar(50) NOT NULL ,
[PAID] varchar(50) NOT NULL ,
[Status] varchar(50) NOT NULL ,
[payerEmail] varchar(50) NOT NULL ,
[charname] varchar(50) NOT NULL ,
[datepaid] datetime NOT NULL ,
[itemCode] varchar(50) NOT NULL ,
[itemUniqueID] varchar(50) NOT NULL ,
[itemPlus] varchar(50) NOT NULL
)
GO
DBCC CHECKIDENT(N'[dbo].[_donateItemsLog]', RESEED, 8)
GO
-- ----------------------------
-- Indexes structure for table _donateItemsLog
-- ----------------------------
-- ----------------------------
-- Primary Key structure for table _donateItemsLog
-- ----------------------------
ALTER TABLE [dbo].[_donateItemsLog] ADD PRIMARY KEY ([id])
GO
12-02-16
MaDenGo
Re: [PHP] Webmall with Paypal & IPN
Awesome step but add more descreptions about how to install include pics and about your web mall
Thanks for ur share
12-02-16
B1QB0SS
Re: [PHP] Webmall with Paypal & IPN
Quote:
Originally Posted by MaDenGo
Awesome step but add more descreptions about how to install include pics and about your web mall
Thanks for ur share
open "sql" folder create a new database for the website call it whatever you want i prefer "WebsiteDB" add these tables in the database and you're done
make sure the php_pdo_odbc.dll is uncommented in your php.ini
13-02-16
DSilkroad Srovn
Re: [PHP] Webmall with Paypal & IPN
not work Connection failed: SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- - - Updated - - -
php_pdo_odbc.dll enabled
13-02-16
RenePunik
Re: [PHP] Webmall with Paypal & IPN
Finally, something good and important. thanks for your work.
14-02-16
B1QB0SS
Re: [PHP] Webmall with Paypal & IPN
Quote:
Originally Posted by DSilkroad Srovn
not work Connection failed: SQLSTATE[IM002] SQLDriverConnect: 0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- - - Updated - - -
php_pdo_odbc.dll enabled
check your database connection in include/config.php make sure all info are correct
15-02-16
CandyQ
Re: [PHP] Webmall with Paypal & IPN
Quote:
Originally Posted by RenePunik
Finally, something good and important. thanks for your work.