PHP Mysql Accounting & Bookkeeping
PHP Mysql Accounting & Bookkeeping:
Journal Entry
Under Construction
1. Main Menu   2. Customers   3. Items   4. Ledger  
5. PayPal   6. Download  

This is the PHP Mysql Accounting & Bookkeeping software we have been writing for our current operating business.
We are currently using a much updated version and as time permits we will add the modified code to this website.
This Paypal module was thrown together in about 3 hours.


EXAMPLE:
Total Paypal Spent: $38,038
Total_Net $150
Total Shipping & Handling: $1,664
Total - S&H: $36,374
Total - (S&H + Deposits): $26,159
Total - per month: $4,756
Total_Deposits $10,215
Total_Fee $297
Paypal Fees: 3%
DateNameItem TitleGrossFeeNetBalanceShipping and Handling Amount
6/12/2007 Name 1. Misc treadmill, circuit boards, controllers, switches -246.66 0.00 -82.22 0.00S&H $ 7.50
6/11/2007 Name 3. Parallax Board of Education (BOE) & BS2 Stamp Package -251.67 0.00 -83.89 0.00S&H $ 17.00
6/8/2007 Name 5. +37.47 0.00 12.49 12.49S&H $
6/8/2007 Name 6. 30 Filter Capacitors Recap Kit For AC~DC Tube Radios -101.85 0.00 -33.95 0.00S&H $ 9.00
6/8/2007 Name 8. SIEB & MEYER 26.44.14 SERVO MOTOR CONTROLLER LOGIC CARD -82.05 0.00 -27.35 0.00S&H $ 25.37
6/5/2007 Name 10. -37.47 0.00 -12.49 0.00S&H $
6/5/2007 Name 11. +37.47 0.00 12.49 12.49S&H $
6/5/2007 Name 12. Lot of 866 51S 125 volt 3 amp fuse 125V 3A -29.4 0.00 -9.80 0.00S&H $ 4.81
6/5/2007 Name 14. HUGE LOT 200 PC ECG + NTE ELECTRONIC COMPONENTS -224.64 0.00 -74.88 0.00S&H $ 0.00
6/5/2007 Name 16. PHP MySQL Website Programming: Problem - Design - Solut -22.38 0.00 -7.46 0.00S&H $ 4.25
6/5/2007 Name 18. Core Php Programming by Leon Atkinson (1999) -37.47 0.00 -12.49 0.00S&H $ 6.00
6/5/2007 Name 20. PHP GAME PROGRAMMING w/ CD 2004 SHIPS FAST!! -65.94 0.00 -21.98 0.00S&H $ 9.99
6/5/2007 Name 22. GBB 5A GBB5 Ceramic Fuse 1/4" X 1&1/4" lot of 5 -303.33 0.00 -101.11 0.00S&H $ 6.60
6/4/2007 Name 24. -1785 0.00 -595.00 0.00S&H $
6/2/2007 Name 26. -55.02 0.00 -18.34 0.00S&H $ 0.00
6/1/2007 Name 28. +5.79 0.00 1.93 1.93S&H $
6/1/2007 Name 29. Gelman adj power supply with timer -93 0.00 -31.00 0.00S&H $ 16.00
6/1/2007 Name 31. BUSSMANN SEMICONDUCTOR FUSE FWH-100B 100 AMP NIB -132.75 0.00 -44.25 0.00S&H $ 6.00
6/1/2007 Name 33. Sencore SG165 AM-FM-Stereo Analyzer *LOOK* -258.3 0.00 -86.10 0.00S&H $ 26.11
6/1/2007 Name 35. Duffers Scientific 8140 Weld Program Monotor Welder -364.98 0.00 -121.66 63.37S&H $ 21.71
5/25/2007 Name 36. Kogi l4ax 14.1" inch LCD VGA Flat Panel Monitor BAD NR -100.5 0.00 -33.50 185.03S&H $ 17.00
5/23/2007 Name 37. Unix Shell Programming Tools by Dave Medinets (1999) -38.82 0.00 -12.94 218.53S&H $ 3.99
5/20/2007 Name 38. NSK ESA Drive Controllers lot of 3 used -200.49 0.00 -66.83 231.47S&H $ 13.28
5/19/2007 Name 39. -27.51 0.00 -9.17 298.30S&H $ 0.00
5/15/2007 Name 40. EsterLine Angus Power Master IIIB with Accessories -449.85 0.00 -149.95 307.47S&H $ 0.00
5/15/2007 Name 41. Exceltronic Watt Transducer Model XL5C5A4 Input 500 W -522.15 0.00 -174.05 457.42S&H $ 24.05
5/12/2007 Name 42. 10uf 400V Hi Temp Radial Electrolytic Caps - 10pcs -36.75 0.00 -12.25 631.47S&H $ 2.50
5/12/2007 Name 43. lot (100) BIPOLAR electrolytic capacitors 4.7 ufd 50 v -49.56 0.00 -16.52 643.72S&H $ 6.85
5/12/2007 Name 44. CRT Monitor Swingarm desk/Machine Mount Heavy Duty -118.5 0.00 -39.50 660.24S&H $ 24.50
5/8/2007 Name 45. Shopping Cart -522 0.00 -174.00 699.74S&H $ 14.00
5/3/2007 Name 46. +0.42 0.00 0.14 873.74S&H $
5/2/2007 Name 47. +2700 -26.40 873.60 873.60S&H $
5/1/2007 Name 48. software licence(s) -59.97 0.00 -19.99 0.00S&H $ 0.00
4/29/2007 Name 50. -108.06 0.00 -36.02 0.00S&H $ 0.00
4/28/2007 Name 52. -89.85 0.00 -29.95 0.00S&H $
4/28/2007 Name 54. 2 Axis General Electric Servo Drive -150 0.00 -50.00 0.00S&H $ 30.00
4/28/2007 Name 56. NEMATRON CORPORATION ICC-5000-PC1X -205.35 0.00 -68.45 0.00S&H $ 18.46
4/28/2007 Name 58. METRONIX ARS-310/5 SERVO DRIVE 230V RDC16 -138 0.00 -46.00 0.00S&H $ 15.00
4/28/2007 Name 60. 25 PC SEIBERCO INC ELECTRONIC COMPONENTS E-1013 V1.0 -35.16 0.00 -11.72 0.00S&H $ 6.73
4/26/2007 Name 62. Shopping Cart -522 0.00 -174.00 0.00S&H $ 14.00
4/25/2007 Name 64. Progeny DEBIAN LINUX DISTRIBUTION ~ 4 CDs+400 Page Book -53.52 0.00 -17.84 0.00S&H $ 7.95
4/25/2007 Name 66. 3 DVD Debian GNU/Linux 4.0 r0 stable etch x86-64 64 bit -47.88 0.00 -15.96 0.00S&H $ 9.98
4/25/2007 Name 68. * SOCAPEL AC SOCASIN SERVO ST1 80-310 Automation -752.85 0.00 -250.95 0.00S&H $ 100.00
4/25/2007 Name 70. Debian Linux 4.0 etch / 3 DVD Set (i386 or AMD64) -14.94 0.00 -4.98 62.19S&H $ 3.99
4/25/2007 Name 71. LOT FANUC SPINDLE REPAIR PARAMETER MANUALS DOODSAN -141 0.00 -47.00 67.17S&H $ 12.00
4/25/2007 Name 72. NEW Microsoft Windows XP Professional Pro Full with SP2 -398.7 0.00 -132.90 114.17S&H $ 15.95
4/25/2007 Name 73. Nematron Color Industrial Workstation IWS-1510 -199.83 0.00 -66.61 247.07S&H $ 16.62
4/22/2007 Name 74. -27.51 0.00 -9.17 313.68S&H $ 0.00
4/21/2007 Name 75. NEW - Out of the Fertile Crescent by Ballydowse -50.1 0.00 -16.70 322.85S&H $ 2.75
4/20/2007 Name 76. +1050 -10.45 339.55 339.55S&H $
4/19/2007 Name 77. MuRata Cermet Trimmer Potentiometer Kit 5mm - POG5AN -97.38 0.00 -32.46 0.00S&H $ 12.47
4/18/2007 Name 79. -27.51 0.00 -9.17 0.00S&H $ 0.00
4/11/2007 Name 81. HY62256ALP-10 / 62256-10 / Static RAM REFURBS -89.4 0.00 -29.80 0.00S&H $ 6.05
4/11/2007 Name 83. SCN2661CC1N28 / SCN2661 / 2661 / Signetics IC -130.38 0.00 -43.46 0.00S&H $ 8.46
4/11/2007 Name 85. 74LS641 Octal Bus/Line Transceiver ( QTY 100 ea ) -179.88 0.00 -59.96 0.00S&H $ 8.00
4/11/2007 Name 87. STAEFA CONTROL SYSTEMS NRK16 CONTROLLER,USED -78 0.00 -26.00 0.00S&H $ 6.00
4/10/2007 Name 89. 5pk-74F244 DIP IC -27.6 0.00 -9.20 0.00S&H $ 6.20
4/10/2007 Name 91. $ SOCAPEL BA4 60-80-310 SERVO -195 0.00 -65.00 0.00S&H $ 20.00
4/10/2007 Name 93. WWE: Royal Rumble Complete Anthology Box Set BRAND NEW (qty=1) -597 0.00 -199.00 0.00S&H $ 18.45
4/10/2007 Name 95. AI Roboform Pro -149.55 0.00 -49.85 22.69S&H $ 0.00
4/6/2007 Name 96. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 72.54S&H $ 0.00
3/31/2007 Name 97. +0.06 0.00 0.02 0.02S&H $
3/29/2007 Name 98. Aluminum Electrolytic Capacitor Hi-Volt Radial Kit # -513 0.00 -171.00 0.00S&H $ 41.00
3/29/2007 Name 100. NSK TORQUE CONTROLLER/MOTOR DRIVE (qty=1) -149.85 0.00 -49.95 0.00S&H $ 16.95
3/26/2007 Name 102. STAEFA SM II Tool A Smart II Sevice Tool - chrgr cables -207.6 0.00 -69.20 3.32S&H $ 9.20
3/24/2007 Name 103. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
3/20/2007 Name 104. Sencore Vacuum Tube and Transistor checker model TC28 -352.44 0.00 -117.48 0.00S&H $ 10.00
3/19/2007 Name 106. +104.97 0.00 34.99 34.99S&H $
3/16/2007 Name 107. -524.4 0.00 -174.80 0.00S&H $ 0.00
3/13/2007 Name 109. -1860 0.00 -620.00 0.00S&H $
3/12/2007 Name 111. ABI ChipMaster Compact IC Tester -2751 0.00 -917.00 0.00S&H $ 12.00
3/11/2007 Name 113. -27.6 0.00 -9.20 27.38S&H $ 0.00
3/9/2007 Name 114. HEAVY METAL DVD COLLECTOR'S SERIES FACTORY SEALED -65.85 0.00 -21.95 36.58S&H $ 4.00
3/9/2007 Name 115. Pink Floyd - The Wall (1999, DVD)====like new=== -41.97 0.00 -13.99 58.53S&H $ 5.00
3/8/2007 Name 116. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
3/8/2007 Name 117. Nematron Operator Interface Control Panel IWS-1001 -124.23 0.00 -41.41 0.00S&H $ 31.42
3/8/2007 Name 119. Duffers Current Analyzer 290 NR -72.72 0.00 -24.24 0.00S&H $ 23.25
3/8/2007 Name 121. DIT MCO 200-B2 Operational & Maintenance Manual -69 0.00 -23.00 0.00S&H $ 8.00
3/8/2007 Name 123. NEMATRON CORPORATION ICC5031-74310300 OPERATOR PANEL -114.09 0.00 -38.03 0.00S&H $ 18.04
3/8/2007 Name 125. HEATHKIT TRAINER, VIDEO TEST EQUIPMENT, ELECTRONIC MISC -193.95 0.00 -64.65 7.87S&H $ 11.85
3/7/2007 Name 126. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
3/7/2007 Name 127. Monitor Analizer Repair Sencore Model CR70 $1000 -452.97 0.00 -150.99 0.00S&H $ 50.00
3/3/2007 Name 129. 2) EL.GE Servodrive Azionamento AZE-CC4Q DC Servo Drive -1500 0.00 -500.00 0.00S&H $ 0.00
3/2/2007 Name 131. HVAC Engineering CD Books FREE S/H -24 0.00 -8.00 0.00S&H $ 0.00
3/2/2007 Name 133. Buffalo 120GB LinkStation Network Storage HD-H120LAN -589.35 0.00 -196.45 0.00S&H $ 16.50
3/2/2007 Name 135. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 73.56S&H $ 0.00
3/1/2007 Name 136. +3.12 0.00 1.04 1.04S&H $
2/28/2007 Name 137. Acme 350VA transformer motor control 480x120 -56.97 0.00 -18.99 0.00S&H $ 9.00
2/28/2007 Name 139. BI-POLAR ELECTROLYTIC 2.2UF-50VOLT 105 DEG. 20 PCS -18.9 0.00 -6.30 0.00S&H $ 2.10
2/28/2007 Name 141. NEMATRON MODEL IWS-2623 INDUSTRIAL WORKSTATION -148.5 0.00 -49.50 0.00S&H $ 22.50
2/28/2007 Name 143. Innoventions SIMCHECK Plus Advanced Memory Tester -150 0.00 -50.00 0.00S&H $ 0.00
2/28/2007 Name 145. ALLEN BRADLEY CONTROL CIRCUIT TRANSFORMER .250KVA -60.03 0.00 -20.01 0.00S&H $ 20.00
2/26/2007 Name 147. -567 0.00 -189.00 0.00S&H $
2/24/2007 Name 149. ALTAMA US Military Desert Boots 11n or 13r +46.17 -0.75 14.64 29.28S&H $ 15.38
2/23/2007 Name 150. ALTAMA US Military Desert Boots 11n or 13r +46.17 -0.75 14.64 14.64S&H $ 15.38
2/23/2007 Name 151. -300 0.00 -100.00 0.00S&H $
2/23/2007 Name 153. ATP Advanced Test Products P51 PC TEST STATION VuData -222 0.00 -74.00 53.56S&H $ 45.00
2/23/2007 Name 154. Westronics DDR10 Multipoint Chart Recorder -318 0.00 -106.00 127.56S&H $ 30.00
2/23/2007 Name 155. Boardwalker 103 - IC Tester -798.66 0.00 -266.22 233.56S&H $ 36.32
2/21/2007 Name 156. NEW PINK 2GB 2 GB 2G MP3 MP4 VIDEO-PHOTO-AUDIO PLAYER -161.85 0.00 -53.95 499.78S&H $ 12.95
2/19/2007 Name 157. 50 LM393N Dual Comparators, Low Offset Voltage, DIP,NOS -53.55 0.00 -17.85 553.73S&H $ 7.90
2/19/2007 Name 158. Global Specialties Model 1300 DC power supply -77.43 0.00 -25.81 571.58S&H $ 15.81
2/19/2007 Name 159. Elenco Precision XP-580 DC Power Supply Quad Power -170.31 0.00 -56.77 597.39S&H $ 30.60
2/14/2007 Name 160. Mc-70 Treadmill Motor Controller..Free Shipping -214.05 0.00 -71.35 654.16S&H $ 0.00
2/14/2007 Name 161. Vintage AM/FM Radio W/ Intercom system -47.97 0.00 -15.99 725.51S&H $ 15.00
2/13/2007 Name 162. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 741.50S&H $ 0.00
2/13/2007 Name 163. +1200 -11.90 388.10 668.98S&H $
2/12/2007 Name 164. -27.6 0.00 -9.20 280.88S&H $ 0.00
2/11/2007 Name 165. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 290.08S&H $ 0.00
2/11/2007 Name 166. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 217.56S&H $ 0.00
2/11/2007 Name 167. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 145.04S&H $ 0.00
2/10/2007 Name 168. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 72.52S&H $ 0.00
2/8/2007 Name 169. Micro Concepts Data I/O Style IC EPROMS RAMS Tester -2591.85 0.00 -863.95 0.00S&H $ 24.95
2/7/2007 Name 171. Seiberco AIM 5000 LX Series and Sensorimotor - New! -821.1 0.00 -273.70 0.00S&H $ 23.70
2/7/2007 Name 173. Treadmill Procond Motor Controller Repair MC-70 MC70 +225 -2.48 72.52 72.52S&H $ 0.00
2/7/2007 Name 174. AuctionSniper.com-Auto -60 0.00 -20.00 0.00S&H $ 0.00
2/6/2007 Name 176. SEIBERCO Model 2305-010 Stepper Motor Driver W/Power -330 0.00 -110.00 0.00S&H $ 10.00
2/6/2007 Name 178. Icon Image Nordic Proform Reebok Treadmill Controller -237 0.00 -79.00 0.00S&H $ 9.00
2/2/2007 Name 180. eBay Seller Fees -490.59 0.00 -163.53 0.00S&H $ 0.00
2/1/2007 Name 182. Huntron 5100DS troubleshooting system ( Tested ) ready -2700 0.00 -900.00 0.00S&H $ 100.00
2/1/2007 Name 184. +0.24 0.00 0.08 72.60S&H $
1/31/2007 Name 185. Treadmill Procond Motor Controller Repair MC70 MC-70 +225 -2.48 72.52 72.52S&H $ 0.00
1/29/2007 Name 186. WESTRONICS DDR10 CHART RECORDER, USED -282 0.00 -94.00 0.00S&H $ 19.00
1/29/2007 Name 188. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/26/2007 Name 189. 9" Inch Monochrome POS or PC Computer Monitor CRT -94.59 0.00 -31.53 0.00S&H $ 11.53
1/26/2007 Name 191. HUGE LOT 100+ Staefa Controls Smart I VAV Controllers -225 0.00 -75.00 0.00S&H $ 0.00
1/25/2007 Name 193. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/23/2007 Name 194. -225 2.48 -72.52 0.00S&H $
1/22/2007 Name 195. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/22/2007 Name 196. B&K 545 circuit analyzer w/ manual, Huntron MP10 probes -2475.93 0.00 -825.31 0.00S&H $ 29.76
1/21/2007 Name 198. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/18/2007 Name 199. LabVolt Lab-Volt Transmitter TX Bendix Snchro Receiver -61.86 0.00 -20.62 0.00S&H $ 10.63
1/17/2007 Name 201. +32.94 0.00 10.98 10.98S&H $
1/17/2007 Name 202. Exel XLS28C16AP-200 28C16 2816 EEPROM 16K (2K x8) NEW -91.5 0.00 -30.50 0.00S&H $ 1.00
1/17/2007 Name 204. BK PRECISION IC TESTER MODEL 560 -408.78 0.00 -136.26 0.00S&H $ 20.00
1/15/2007 Name 206. -116.25 0.00 -38.75 106.29S&H $
1/15/2007 Name 207. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 145.04S&H $ 0.00
1/12/2007 Name 208. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/12/2007 Name 209. AMERITEC T1 BULK CALL GENERATOR -314.91 0.00 -104.97 0.00S&H $ 75.00
1/9/2007 Name 211. 512mb DDR2 533mhz PC2 4200 HP/PC Ram Free Shipping ! -314.97 0.00 -104.99 0.00S&H $ 5.00
1/9/2007 Name 213. Lambda DC Power Supply Model LP-534-FM 0-120 Vdc -309 0.00 -103.00 0.00S&H $ 15.00
1/9/2007 Name 215. HUNTRON TRACKER #1000 -460.08 0.00 -153.36 0.00S&H $ 25.86
1/9/2007 Name 217. Nematron IWS-113 Controler -108 0.00 -36.00 36.52S&H $ 10.00
1/9/2007 Name 218. +225 0.00 75.00 0.00S&H $
1/7/2007 Name 219. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/4/2007 Name 220. 5x Wireless USB Adapter 802.11g Free Ship "Lot of 5" -255 0.00 -85.00 0.00S&H $ 0.00
1/4/2007 Name 222. Nematron IWS-2013 Industrial Workstation with Monitor -89.46 0.00 -29.82 42.70S&H $ 22.83
1/4/2007 Name 223. Treadmill Procond Motor Controller Repair Service MC70 +225 -2.48 72.52 72.52S&H $ 0.00
1/4/2007 Name 224. Treadmill Procond Motor Controller Repair Service MC70 +225 0.00 75.00 0.00S&H $ 0.00
1/4/2007 Name 225. SENCORE Oscilloscope Waveform Analyzer SC61 -373.5 0.00 -124.50 0.00S&H $ 22.00
1/3/2007 Name 227. TENMA 72-1095 VARIABLE ISOLATION TRANSORMER -360 0.00 -120.00 0.00S&H $ 25.00
1/3/2007 Name 229. Kokusai 94135 Controller (qty=1) -59.97 0.00 -19.99 0.00S&H $ 10.99
1/3/2007 Name 231. Pinball Video Arcade IC Tester Model #Prufer-20 -251.25 0.00 -83.75 0.00S&H $ 17.38
1/3/2007 Name 233. Applied Microsystems EC7000 ICE, 68020,68HC11,80186/188 (eBay: 300062772820) -179.4 0.00 -59.80 0.00S&H $ 34.80


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
<?
######################################################################

# Open Database Connection
#
######################################################################
$DB_HOST "localhost";
$DB_USER "root";
$DB_PASS "";
$DB_DB "ier";
$db= @mysql_pconnect $DB_HOST $DB_USER $DB_PASS );
@
mysql_select_db $DB_DB )  or die ( "DATABASE ERROR!" );
######################################################################
$table "paypal";

$result mysql_query("SHOW FIELDS FROM $DB_DB.$table");
$Paypal_i 0;
//echo "<HR>Database:$DB_DB TABLE:$table<BR>";

while ($row mysql_fetch_array($result)) 
 {
 
//echo $row['Field'] . "-" .$row['Type'] . "<BR>";
 
$Paypal_Field[$Paypal_i] = $row['Field'];
 
$Paypal_Type[$Paypal_i] = $row['Type']; 
 
$Paypal_i++; 
 }
?>
<LINK rel="stylesheet" type="text/css" title="bluesilver" href="/xampp/www/1Repair/blueSilver.css">
<style type="text/css"> <!-- A:hover {color:#0000ff} --></style>
</head>
<!-- End Header -->    
<body bgcolor="ffffff" link="FFFFFF" vlink="FFFFFF" topmargin="3" leftmargin="5" marginwidth="5">
<?


$post_with_threads_query 
mysql_query("SELECT * FROM paypal");
$jobs .= "<table border=1>";
            
$jobs .= "<tr><th>";
       
$jobs .= "<span class=\"postdetails\">" ;                                                
            
$jobs .= 'Date';
            
$jobs .= "</th><th>";                             
            
$jobs .= 'Name';
            
$jobs .= "</th><th>";                             
            
$jobs .= 'Item Title';
            
$jobs .= "</th><th>";
            
$jobs .= 'Gross';
            
$jobs .= "</th><th>";     
            
$jobs .= 'Fee';
            
$jobs .= "</th><th>";     
            
$jobs .= 'Net';
            
$jobs .= "</th><th>";     
            
$jobs .= 'Balance';
            
$jobs .= "</th><th>";     
            
$jobs .= 'Shipping and Handling Amount';     
            
$jobs .= "</th>";     
            
$jobs .= "</tr>";

while (
$post_with_threads mysql_fetch_array($post_with_threads_query))
        {
        
$total_++;
    
//Gross, Fee, Net
       
$Gross stripslashes($post_with_threads['Gross']);
         
$Fee stripslashes($post_with_threads['Fee']);
          
$Net stripslashes($post_with_threads['Net']);
          
$ShippingandHandlingAmount stripslashes($post_with_threads['Shipping and Handling Amount']);
     
     if(
$Gross 0){$Total_Spent $Total_Spent $Gross;}
     
         
$Total_Fee $Total_Fee $Fee;
          
$Total_Net $Total_Net $Net;
          
$Total_ShippingandHandlingAmount $Total_ShippingandHandlingAmount $ShippingandHandlingAmount;

     
     if(
$post_with_threads['Name'] != "Bank Account")
{          
            
$jobs .= "<tr><td>";
       
$jobs .= "<span class=\"postdetails\">" ;                                                
            
$jobs .= $post_with_threads['Date'];
            
$jobs .= "</td><td>";
            
$jobs .= $post_with_threads['Name'];
            
$jobs .= "</td><td>.";                             
            
$jobs .= $post_with_threads['Item Title'];
            
$jobs .= "</td><td>";
     if(
$Gross 0){            $jobs .= "<font color=red><b>".$post_with_threads['Gross'] . "</b></font>"$Total_Deposits $Total_Deposits $Gross;}
//     else{$jobs .= $post_with_threads['Gross']."<BR>".$Total_Spent;}
     
else{$jobs .= $post_with_threads['Gross'];}     
            
$jobs .= "</td><td>";     
            
$jobs .= $post_with_threads['Fee'];
            
$jobs .= "</td><td>";     
            
$jobs .= $post_with_threads['Net'];
            
$jobs .= "</td><td>";
            
$jobs .= $post_with_threads['Balance'];          

            
$jobs .= "</td><td>S&H $";     
            
$jobs .= $post_with_threads['Shipping and Handling Amount'];
            
$jobs .= "</td></tr><tr>";
}     
     
     
     
     
     
    }
$jobs .= "</table>";    

echo 
"<BR>Total Paypal Spent: $" $Total_Spent;
echo 
"<BR>Total_Net $" $Total_Net;
echo 
"<BR>Total Shipping & Handling: $" $Total_ShippingandHandlingAmount;

echo 
"<HR>Total_Deposits $" $Total_Deposits ;
echo 
"<BR>Total_Fee $" $Total_Fee;
echo 
"<BR>%" . ($Total_Fee/$Total_Deposits 100);
echo 
"<HR>";
echo 
$jobs;    




<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
<?
echo "Need to edit before use!<HR>";
$sql 'TRUNCATE TABLE `paypal` removes all data';
echo 
$sql;
exit;

######################################################################

# Open Database Connection
#
######################################################################
$DB_HOST "localhost";
$DB_USER "root";
$DB_PASS "";
$DB_DB "ier";
$db= @mysql_pconnect $DB_HOST $DB_USER $DB_PASS );
@
mysql_select_db $DB_DB )  or die ( "DATABASE ERROR!" );
######################################################################
$table "paypal";

$result mysql_query("SHOW FIELDS FROM $DB_DB.$table");
$Paypal_i 0;
//echo "<HR>Database:$DB_DB TABLE:$table<BR>";

while ($row mysql_fetch_array($result)) 
 {
// echo $row['Field'] . "<BR>";
 
$Paypal_Field[$Paypal_i] = $row['Field'];
 
$Paypal_Type[$Paypal_i] = $row['Type']; 
 
$Paypal_i++; 
 }
?>
<LINK rel="stylesheet" type="text/css" title="bluesilver" href="/xampp/www/1Repair/blueSilver.css">
<style type="text/css"> <!-- A:hover {color:#0000ff} --></style>
</head>
<!-- End Header -->    
<body bgcolor="ffffff" link="FFFFFF" vlink="FFFFFF" topmargin="3" leftmargin="5" marginwidth="5">
<?
$sql 
'TRUNCATE TABLE `paypal`';
mysql_query($sql)or die(mysql_error());

$handle fopen("Download.csv""r");
while ((
$data fgetcsv($handle1000",")) !== FALSE
  {
  
$num count($data)-1;
  
$query create_query($table,$Paypal_i,$Paypal_Field ,$num ,$data);
  echo 
$query "<HR>";
  
mysql_query($query)or die(mysql_error() ."<hr> ".__LINE__);
  
$query '';  
  }
fclose($handle); 
                



function 
create_query($table,$DB_Table_count,$DB_Table_Fields,$Insert_Values_Count,$Insert_Values_Content)
{
echo 
"<p> $DB_Table_count fields in database table!<br /></p>\n";
echo 
"<p> $Insert_Values_Count fields in Values Data! <br /></p>\n";


$limit $DB_Table_count ;
$query "INSERT INTO ".$table." (";
      for (
$i2 0$i2 $DB_Table_count$i2++) 
         {
            
$dis $DB_Table_Fields[$i2];
            if(
$i2 != $limit)
       
                    {    
$query .= "`" ;                $query .= $dis ."`"", ";                    }
            else
                    {        
$query .= "`" ;                    $query .= $dis ."`""" ;                    }     
        }
            
$query .= ")VALUES(" ;

$limit $Insert_Values_Count ;
for (
$i2 0$i2 $Insert_Values_Count$i2++) 
         {
             
$dis addslashes($Insert_Values_Content[$i2]);
             
$query .= "'" ;              
             
$query .= $dis;
      
             if(
$i2 != $limit)
               {                  
$query .= "', ";                  }
          else
               {                  
$query .= "');";                  }
        }
return 
$query;    
}



-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 13, 2007 at 08:04 PM
-- Server version: 4.1.14
-- PHP Version: 5.0.5
-- 
-- Database: `ier`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `paypal`
-- 

CREATE TABLE `paypal` (
  `Date` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Time` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Time Zone` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Name` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Type` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Status` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Currency` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Gross` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Fee` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Net` varchar(99) collate latin1_general_ci NOT NULL default '',
  `From Email Address` varchar(99) collate latin1_general_ci NOT NULL default '',
  `To Email Address` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Transaction ID` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Counterparty Status` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Shipping Address` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Address Status` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Item Title` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Item ID` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Shipping and Handling Amount` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Insurance Amount` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Sales Tax` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Option 1 Name` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Option 1 Value` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Option 2 Name` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Option 2 Value` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Auction Site` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Buyer ID` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Item URL` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Closing Date` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Escrow Id` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Invoice Id` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Reference Txn ID` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Invoice Number` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Custom Id` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Receipt ID` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Balance` varchar(99) collate latin1_general_ci NOT NULL default '',
  `Contact Phone Number` varchar(99) collate latin1_general_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Linecard

Manufactures repaired
A   B-C   D-E   F-H   I-K   L   M   N-O   P   Q-R   S   T   U-Z