[PHP] Webmall with Paypal & IPN

[B1QB0SS]

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

Spoiler:

And the Admin Panel

Spoiler:

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:

/*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

[MentaL]

[MaDenGo]

Awesome step but add more descreptions about how to install include pics and about your web mall
Thanks for ur share

[B1QB0SS]

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

[heavensro]

i want help for fix that error And if you can upload backup from websitedb

[B1QB0SS]

i want help for fix that error And if you can upload backup from websitedb

look at the last comment i posted + make sure you have php_pdo_odbc.dll enabled in your php.ini file

i recommend using ZendServer 8.5 PHP 5.6

[DSilkroad Srovn]

you can share db webDB

eror: Connection failed: could not find driver

[B1QB0SS]

you can share db webDB

check first post i'm so sorry i forgot to add the tables in the rar (rofl)

[DSilkroad Srovn]

fix bro ?

[B1QB0SS]

fix bro ?

make sure the php_pdo_odbc.dll is uncommented in your php.ini

[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

[RenePunik]

Finally, something good and important. thanks for your work.

[B1QB0SS]

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

[CandyQ]

Finally, something good and important. thanks for your work.

his work O.o

[B1QB0SS]

his work O.o

yes? !

[elmagico123]

Why this file "cacert.pem" Encrypted ?