cmgmyr
-
Posts
1,278 -
Joined
-
Last visited
Never
Posts posted by cmgmyr
-
-
yeah good one ChaosXero
-
I think that you should be fine with 1 gig
-
try using auto incriment in your table, and not inserting a product id in your php script.
also if you post the code, it would help too :-)
-Chris -
If you have phpMyAdmin it gives you a breakdown of each table and how much space is taken up and a total on the bottom for everything combined.
The amount of space depends on what you are holding in the database. What kind of information are you holding? But I think 1 gig should be enough.
-Chris -
Yeah, I like using it. There are a lot of cool things that you can do with it.
-Chris
-
I agree with everyone's comments so far. I do like the layout and the design. BUT your site is a techy site, why don't you make it more techy looking? More modern looking. Right now it looks fine, but it's looks like a design site, not a techy site.
-Chris -
Well it's a lot better then the first one. You should make the tabs rolloevers of some sort. Also you should narrow your white content section to match the width of your navigation. Also make a footer so the page doesn't just hit the bottom.
-Chris -
On your laptop you would have to go into phpMyAdmin (install it if you haven't) go to export and make sure you get data and structure. Open up phpMyAdmin in 1and1 make a new database, go to sql and import your saved sql from your laptop. Update your config file with the information that 1and1 gives you for their database and you should be all set
-Chris -
I think if you try to tone down the green it would be a little better, it's kinda "in your face" right now.
-
They are like cookies...but not. Cookies are stored on the user's computer and sessions are on the server. So if you have information getting checked all of the time from 2 different sources you shouldn't have anything to worry about.
-
Why don't you combine sessions and cookies. Then you shouldn't have anything to worry about.
-Chris -
Hey, Thanks guys. I knew that paypal had the IPN system, but I never really worked with it before. I saw that zend tutorial, but I was looking for something a little simpler. I signed up as a paypal developer so that I can have sandbox accounts. I guess I just have to jump in right?
Do you guys have any advise in what works and what doesn't?
Thanks again,
-Chris -
Hey all,
I've been all over online looking for some good paypal/php tutorials and couldn't really what I was looking for. Here is what I want to do:
-User comes into the system and has to make a donation
-Makes a donation through paypal
-Completes the payment through paypal
-Script updates my database with the amount
I know I can do this my making a success script, but that only works if the user clicks "return to merchant" which if you close your browser out, it will not update the database.
I know that you can do it, but I haven't found any real good references.
Any ideas or help?
Thanks,
-Chris -
hey no problem, glad it helped you out
-
Here is a great tutorial
http://apachemysqlphp.com/
-Chris -
awesome, no problem!
-Chris -
This is something like you want
http://www.tjkdesign.com/articles/dropdown/default.asp
-Chris -
You can also check out Sweet Titles at http://www.dustindiaz.com/download/ it basically takes whatever you have in the title atribute of a link or image and displays a nice little box.
-Chris -
I think you should try and convert all over to CSS. If you do it like you gave examples for, you are going to have a lot of problems.
-Chris -
Dreamweaver doesn't allow you to see the content of the iframe in design view. You would have to preview it in a browser, that's the only thing you can do.
-Chris -
Also what i've noticed is that IE doesn't like it when you drop the </div> down to the next line. It treats this like a space or a line break in some cases.
Try changing it to this:[code]<div style="width: 180px; padding-left: 5px;">
<div style="float:left; background-image: url('images/menu-title-left.gif');
background-repeat: no-repeat; width: 14px; height: 25px;"></div>
<div style="float:right; background-image: url('images/menu-title-right.gif');
background-repeat: no-repeat; width: 14px; height: 25px;"></div>
<div style="background-image: url('images/menu-title-repeat.gif');
background-repeat: repeat-x; margin:0; padding: 0; padding-top: 8px;
font-weight: bold; font-size: 11pt; color: #fff; height: 17px;">
Main Menu</div>
<div style="clear:both; border: 1px solid #999; background-color: #ddd;">
<ul class="leftmenu">
<li><a href="">Home</a></li>
<li><a href="">About</a></li>
<li><a href="">Guestbook</a></li>
</ul></div>
</div>[/code]
I don't know why it does that, but it does. I had the same problem a while ago and I tried that and it worked. If it doesn't work for you, then just make the top all one image like what moberemk said.
-Chris -
I like the site. Very crisp and clean. I really like the ajax animations too. Maybe when you get done with this version you can make just a standard html - no ajax version so that those 5% of people can view your page.
Looks good.
-Chris -
What do you need done? You can PM me too.
-Chris -
I have olm.net, 1and1.com, and servage.net they all seem to be pretty good. I have different sites on each one that need different things. You just need to find something that works for you.
-Chris
PHP and Paypal
in PHP Coding Help
Posted
donations table:
CREATE TABLE `donations` (
`id` BIGINT NOT NULL AUTO_INCREMENT ,
`UID` BIGINT NOT NULL ,
`item_name` MEDIUMTEXT NOT NULL ,
`item_number` MEDIUMTEXT NOT NULL ,
`payment_status` TEXT NOT NULL ,
`payment_amount` TEXT NOT NULL ,
`payment_currency` TEXT NOT NULL ,
`txn_id` LONGTEXT NOT NULL ,
`receiver_email` MEDIUMTEXT NOT NULL ,
`payer_email` MEDIUMTEXT NOT NULL ,
INDEX ( `id` )
) ENGINE = MYISAM ;
I have a donations part in the users table also.
donation.php
[code=php:0]<?php
echo "<form action=\"https://www.sandbox.paypal.com/cgi-bin/webscr\" method=\"post\">
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\">
<input type=\"hidden\" name=\"business\" value=\"Business Name\">
<input type=\"hidden\" name=\"item_name\" value=\"item name\">
<input type=\"hidden\" name=\"item_number\" value=\"1\">
<input type=\"hidden\" name=\"currency_code\" value=\"USD\">
<input type=\"hidden\" name=\"receiver_email\" value=\"email\">
<input type=\"hidden\" name=\"mrb\" value=\"R-3WH47588B4505740X\">
<input type=\"hidden\" name=\"pal\" value=\"ANNSXSLJLYR2A\">
<input type=\"hidden\" name=\"no_shipping\" value=\"1\">
<input type=\"hidden\" name=\"no_note\" value=\"1\">
<input type=\"hidden\" name=\"notify_url\" value=\"http//www.URL to script/ipn.php?UID=$userid\">
<input type=\"hidden\" name=\"cancel_return\" value=\"http//www.URL to users script/users.php\">
<input type=\"image\" name=\"submit\" src=\"http://images.paypal.com/images/x-click-butcc-donate.gif\" border=\"0\" alt=\"Make payments with PayPal, it's fast, free, and secure!\">
</form>";
?>[/code]
ipn.php
[code=php:0]<?php
include "connect.php";
function ipn_verify($seller_email = '', $item_price = '', $currency = ''){
if(!$_POST){
return array('result' => 0);
}
//seed random generator
mt_srand((double)microtime() * 1000000);
$charset = "abcdefghijklmnopqrstuvwxyz12_-34567890ABCDE_FGHIJKLMNOPQRSTWXYZ";
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';
foreach($_POST as $key => $value){
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}
// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('www.sandbox.paypal.com', 80, $errno, $errstr, 30);
// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_amount = sprintf("%.2f", $payment_amount);
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$trans_details = array('item_name' => $item_name, 'item_number' => $item_number, 'payment_status' => $payment_status, 'payment_amount' => $payment_amount, 'payment_currency' => $payment_currency, 'txn_id' => $txn_id, 'receiver_email' => $receiver_email, 'payer_email' => $payer_email);
if(!$fp){
// HTTP ERROR
}else{
fputs($fp, $header . $req);
while(!feof($fp)){
$res = fgets($fp, 1024);
fclose ($fp);
if((strcmp($res, 'VERIFIED') == 0)){
$failed = 0;
if(($seller_email) && ($seller_email != $receiver_email)){
$failed = 1;
}
if(($item_price) && (sprintf("%.2f", $item_price) < sprintf("%.2f", $payment_amount))){
$failed = 1;
}
if(($currency) && ($currency != $payment_currency)){
$failed = 1;
}
if(!$failed){
$trans_details['result'] = 1;
return $trans_details;
}else{
$trans_details['result'] = 0;
return $trans_details;
}
}elseif(strcmp ($res, 'INVALID') == 0){
$trans_details['result'] = 0;
return $trans_details;
}
}
}
}
$trans_details = ipn_verify('email'); //same e-mail address as above
if($trans_details['result']){
@mysql_query("insert into donations (UID, item_name, item_number, payment_status, payment_amount, payment_currency, txn_id, receiver_email, payer_email) values ('". $_GET['UID'] ."', '". $trans_details['item_name'] ."', '". $trans_details['item_number'] ."', '". $trans_details['payment_status'] ."', '". $trans_details['payment_amount'] ."', '". $trans_details['payment_currency'] ."', '". $trans_details['txn_id'] ."', '". $trans_details['receiver_email'] ."', '". $trans_details['payer_email'] ."')");
$getter = @mysql_fetch_object(mysql_query("SELECT * FROM users WHERE userid='". $_GET['UID'] ."' limit 1"));
$donations = sprintf("%.2f", ($trans_details['payment_amount'] + $getter->donations));
@mysql_query("update users set donations='". $donations ."' where userid='". $_GET['UID'] ."' limit 1");
echo '<center>Thank you for your donation.</center>';
}else{
echo '<center>We\'re sorry but your donation has failed.</center>';
}
include "disconnect.php";
?>[/code]
In my sandbox account I went to Profile>Instant Payment Notification> I enabled it and used http//www.URL to script/ipn.php as the URL and saved it. The payments are going in and out of the right accounts as they should, but it's not updating the database. Am I missing something?
Thanks,
-Chris