PHP - Credit Card Entry Form

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=315057.0

Hey, i have made a silly little tester game just to see if i could, its he http://www.zephni.com/test/pairs its for some guy who is attending college and he was given the assignment to make a game of pairs using PHP to sort the cards and lay them down, and javascript to handle the actual game.

Anyway at the moment, my game sorts out the cards as if they are values from 1 to 52, and picks randomly 18 cards from them. During the game, the cards have to be excatly the same, as in:

if(card_picked1 == card_picked2){
      win pair
}

that means that both cards would have to be the same number AND suit. But in pairs you have to pick the same number but obviously in a different suit. Any way I have been trying some diff code to pick 18 cards from the pack. It picks 9, and then doubles them up but +'s 13 to the card so it is the same number card.

Here is the code

Code: [Select]
<?php

$i = 1;
$total_cards = 18;

#Sorting out cards
$card_sort = range(1,52);

while($i <= ($total_cards/2)){
$pick_card = $card_sort[rand(1,52)];

if($pick_card !== null){
$cards[] = $pick_card;
}
unset($card_sort[$pick_card]);

$i = $i+1;
}

foreach($cards as $card){
echo($card."<br/>");
}

?>

I would of thought that when you unset the number from $card_sort that was picked it would'nt choose it again if($pick_card !== null) but it still chooses the same card twice sometimes. I know I really havent explained this well, but i did my best for 9am...

	$value0 = $_POST['date1'];
    $value1 = $_POST['date2'];
    $value2 = $_POST['date3'];

$sql = "INSERT INTO Datetable (startdate,enddate, total)
VALUES ('$value0','$value1', '$value2')" ;

$result = mysqli_query($sql);

Hi,

I was wondering is it possible to not insert values in MySQL if form entry is left blank? Right now if I dont enter any values in form for my dates than MySQL entry shows 0000-00-00 but I need it not to show anything.

 

Hi, I was just trying to post form data to MySQL and trying to also post value of logged in user? but that code below doesnt work..Do you see a typo? or is it done some other way?

 

$uid =$_SESSION[ "uid" ]; 

$sql = "INSERT INTO Date (uid) VALUES (:uid)"; 
$query= $conn->prepare( $sql ); 
$query->execute( array( ':uid'=>$uid) );

 

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.
 

When there is a duplicate entry in my database, I would like it to go to the another page that indicates the error, rather than the "Error: Duplicate entry 'username' for key 1". It happens if someone is going to join and there is a duplicate entry. I would rather it show one of my customized php pages rather than a black page stating the error.

I've tried to catch the entry with some php code but it bypasses it and continues with the duplicate error.

I would appreciate any direction with this. Thanks!

I spent several hours trying to figure this thing out.  Thought I had it nailed, but still getting duplicate record entries into the MySQL DB when I do NOT want them.   Here's the plot:   People filling out the possible attendance form for a Ham Radio event *sometimes* bring a 2nd person (either a spouse or a friend).  The 2nd person may, or may not, also has a Callsign which I need to put INSERT the same MySQL Callsign column.  In any event, to also identify the 2nd person as coming 'with' the 1st person.   MOST of the attendees are individuals with NO 2nd person.   My entry form has these primary fields:   callsign fullname   AND...   callsign2 fullname2   What I came up with was to process the MySQL INSERT for the primary callsign & fullname into their respective MySQL DB Columns (which works fine), and then........... immediately following the main Query INSERT, to do a substitution type thing depending on whether or not a form entry  was made in the callsign2 field, AND/OR, the fullname2 field.   This partially works, but if there is ONLY a primary callsign and fullname in the form, I'm still getting a duplicate record entry which includes the callsign in the `with` column (which should ONLY take place IF there is a 2nd person indicated).   Confusing?   Here is what I have  been wrestling with to try and accomplish the objective, and now my eyes are glazed over ;-(

// TRICKY PART HERE

// If a 2nd Callsign AND a Fullname

if ($callsign2 != ' ' && $fullname2 != ' ') {

// Still make reference to the primary Callsign in the MySQL DB `with` column

$with = $callsign;

// Assignment to allow 2nd Callsign to be entered in the MySQL `callsign` column

$callsign=$callsign2;
$fullname=$fullname2;

$sql="INSERT INTO `mytable` (`callsign`, `fullname`, `with`)
VALUES ('$callsign', '$fullname', '$with')";

// If NO 2nd Callsign BUT a Fullname

} elseif ($callsign2 = ' ' && $fullname2 != ' ') {

// Make reference to the primary Callsign in the MySQL DB `with` column

$with = $callsign;

$callsign=$callsign2;
$fullname=$fullname2;

$sql="INSERT INTO `mytable` (`callsign`, `fullname`, `with`)
VALUES ('$callsign', '$fullname', '$with')";

} else {

// The only thing I could thing of to (hopefully) NOT make a 2nd entry 
// record in the MySQL DB IF there is NO 2nd person referenced

$with = $callsign;

}

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

This mostly works EXCEPT if only a single (primary) person entry.   The recap the objetives:   1. If ONLY a primary/single person entry on the form:   * callsign & fullname get INSERTed into the `callsign` and `fullname` columns in the DB as ONLY one record entry   2. If BOTH a primary and 2nd person on the form:   A. IF the 2nd person has a Callsign, then the 2nd record entry would be:   *   callsign2 & fullname2 get INSERTed into the `callsign` & `fullname` columns in the 2nd DB as a separate record entry *   callsign of the primary person also gets INSERTED into the `with` column in the same 2nd DB record entry   B. IF the 2nd person does NOT have a callsign, then the 2nd record entry would be:   *  fullname2 gets INSERTed into the `fullname` column in the DB as a separate 2nd DB record entry *  callsign of the primary person also gets INSERTED into the `with` column in the same 2nd DB record entry   I obvioiusly have overlooked something, but just can't seem to figure it out at this point {SIGH}.   Thanks for any enlightenment.   -FreakingOUT      

I am using php to upload a file to my server, and at the same time inserting the files name and url into my mysql database.

$sql = "UPDATE uploads SET name = '$name', url='$target_path'";
    $statement = $dbh->prepare($sql); 
    $statement->execute();

This is working, however, when I upload a new file, rather than making a new entry in my database, it just overwrites the first one.

I'm quite new at mysql so was wondering how I would make it add new entrys instead of overwriting the current one?

I have a table called "colors".  It has 2 columns, id and color.

All I'm trying to do is pull the data into the form, then edit the colors (for example - misspelled, etc.)
Then submit it back to the table.

Here is the code that pulls the data into a form so I can edit it:
Code: [Select]
<form action="adminupdatecolors.php" method="post">

<table width="500" border="1" cellpadding="10">

<tr>
  <td>Color Options:</td>
    <td>
    <?
$result = mysql_query("SELECT * FROM colors");
while ($row = mysql_fetch_assoc($result)) {

echo '<input type="text" name="color[]" value="' . $row['color'] . '"/>' . $row['id'] . '<br />';
}

?>
   </td>
</tr>

   <tr>
  <td>&nbsp;</td>
  <td><input type="Submit" value="Update Colors"></td>
  </tr>
</form>
</table>

Here is my update script:
Code: [Select]
<?php

include("config.php");
include("db.php");

$id=$_POST['id'];
$color=$_POST['color'];

$result = mysql_query("SELECT id FROM colors ORDER BY id DESC LIMIT 0,1");

if ($row = mysql_fetch_assoc($result)) {
$id = $row['id']; 
}
$sql = "DELETE FROM colors WHERE id='$id'";
mysql_query($sql) or die("Error: ".mysql_error());

foreach ($color as $colorvalue) {
$sql2 = "INSERT INTO colors (id,color) VALUES ($id,'$color')";
mysql_query($sql2) or die("Error: ".mysql_error());

}

header("Location: " . $config_basedir . "adminhome.php");

?>

Guys:  What is the way to remove white spaces in front of a form entry ?  Should I use regular expression for this ?  Thanks.

I am trying to set up a item entry page form.png:

Upon submission it shows unsuccessful even though I have checked the fields on mysql table and seem to be good am I missing something?

Code: [Select]
<form action="" method="post" enctype="multipart/form-data" name="Product_Entry">
<TABLE>
<TR>
<TD>Product ID</TD><TD><input name="SKU_ProductID" value="<?php if (isset($_post['SKU_ProductID'])) echo $_POST['SKU_ProductID']; ?>" type="text" size="11" maxlength="11" /></TD>
</TR>
<TR>
<TD>Merchant SKU ID</TD><TD><input name="SKU_MerchSKUID" value="<?php if (isset($_post['SKU_MerchSKUID'])) echo $_POST['SKU_MerchSKUID']; ?>" type="text" size="18" maxlength="30" /></TD>
</TR>
<TR>
<TD>Game Title</TD><TD><input name="Game_Title" value="<?php if (isset($_post['Game_Title'])) echo $_POST['Game_Title']; ?>" type="text" size="40" maxlength="40" /></TD>
</TR>
<TR>
<TD>Platform</TD><TD><input name="Platform" value="<?php if (isset($_post['Platform'])) echo $_POST['Platform']; ?>" type="text" size="20" maxlength="20" /></TD>
</TR>
<TR>
<TD>Genre</TD><TD><input name="Genre" value="<?php if (isset($_post['Genre'])) echo $_POST['Genre']; ?>" type="text" size="11" maxlength="11" /></TD>
</TR>
<TR>
<TD>Weight</TD><TD><input name="Weight" value="<?php if (isset($_post['Weight'])) echo $_POST['Weight']; ?>" type="text" size="7" maxlength="7" /></TD>
</TR>
<TR>
<TD>Supplier</TD><TD><input name="Supplier" Value="<?php if (isset($_post['Supplier'])) echo $_POST['Supplier']; ?>" type="text" size="25" maxlength="25" /></TD>
</TR>
<TR>
<TD>Suppliers Price</TD><TD><input name="Supplier_Price" value="<?php if (isset($_post['Supplier_Price'])) echo $_POST['Supplier_Price']; ?>" type="text" size="10" maxlength="12" /></TD>
</TR>
<TR>
<TD>Cashback</TD><TD><input name="Cashback" value="<?php if (isset($_post['Cashback'])) echo $_POST['Cashback']; ?>" type="text" size="6" maxlength="8" /></TD>
</TR>
<TR>
<TD>Cashback Amount</TD><TD><input name="Cashback_Amount" value="<?php if (isset($_post['Cashback_Amount'])) echo $_POST['Cashback_Amount']; ?>" type="text" size="7" maxlength="11" /></TD>
</TR>
<TR>
<TD><input type="hidden" name="submitted" value="true"/></TD><TD><input name="Submit" type="submit" value="Add_Product" /></TD>
</TR></form></TABLE>

<?php # Product Entry

$page_title = 'Product Entry';

if (isset($_POST['Submit'])) {

$errors = array();

if (empty($_POST['SKU_ProductID'])) {
$errors[] = 'Please enter Product ID.';
} else {
$sid = trim($_POST['SKU_ProductID']);
}

if (empty($_POST['SKU_MerchSKUID'])) {
$errors[] = 'Please enter Merchant SKU.';
} else {
$mid = trim($_POST['SKU_MerchSKUID']);
}

if (empty($_POST['Game_Title'])) {
$errors[] = 'Please enter Game Title.';
} else {
$gt = trim($_POST['Game_Title']);
}

if (empty($_POST['Platform'])) {
$errors[] = 'Please enter Platform.';
} else {
$pl = trim($_POST['Platform']);
}

if (empty($_POST['Genre'])) {
$errors[] = 'Please enter Genre.';
} else {
$ge = trim($_POST['Genre']);
}

if (empty($_POST['Weight'])) {
$errors[] = 'Please enter Weight.';
} else {
$we = trim($_POST['Weight']);
}

if (empty($_POST['Supplier'])) {
$errors[] = 'Please enter Supplier.';
} else {
$sup = trim($_POST['Supplier']);
}

if (empty($_POST['Supplier_Price'])) {
$errors[] = 'Please enter Supplier Price.';
} else {
$sp = trim($_POST['Supplier_Price']);
}

if (empty($_POST['Cashback'])) {
$errors[] = 'Please enter Cashback %.';
} else {
$cb = trim($_POST['Cashback']);
}

if (empty($_POST['Cashback_Amount'])) {
$errors[] = 'Please enter Cashback Amount.';
} else {
$cba = trim($_POST['Cashback_Amount']);
}

if (empty($errors)) {

require_once ('connect.php');

[b]$q = "INSERT INTO `Products` (`SKU_ProductID`, `SKU_MerchSKUID`, `Game_Title`, `Platform`, `Genre`, `Weight`, `Supplier`, `Supplier_Price`, `Cashback`, `Cashback_Amount`) VALUES ('$sid', '$mid', '$gt', '$pl', '$ge', '$we', '$sup', '$sp', '$cb', '$cba')";
$r = @mysql_query ($dbc, $q);

if ($r) { // If it ran OK.

// Print a message:
echo '<h1>Thank you!</h1>
<p>Product Inserted!</p><p><br /></p>';

} else { // If it did not run OK.

// Public message:
echo '<h1>System Error</h1>
<p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>'; 

// Debugging message:
echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>';

} // End of if ($r) IF.

mysqli_close($dbc); // Close the database connection.[/b]
// Include the footer and quit the script:
include ('includes/footer.html'); 
exit();

} else {

echo '<H1>Error!</H1>
<p class="error">The Following error(s) occurred:<br />';

foreach ($errors as $msg) {

echo " - $msg<br />\n";
}

echo '</p><p>Please try again.</p><p><br /></p>';

}

}

?>
If there is anything else needed let me know

I'm looking to open a custom giftcard shop in which I'll be selling giftcards at 75%-95% of the face value. (I usually buy them off ebay cheap and resell them).

I've already got the login system complete by using one I found online. What I'm looking to do now is make the shop section now where I can import a text document with the giftcard #, and Pin number to have them all show up in a list (but have only the first 6 numbers show up and the rest stared out with "***" until purchased, with the option to add each individual one to the cart (checkboxes beside each one).

But I want them to be able to buy them with "credits". Credits being a site currency I'd like to be created. I want users to be able to buy these "credits" with the LibertyReserve API. These credits are to be attached to their login until used up. 1 credit = 1$ LR

I notice Libertyreserve has a sample shop script: http://www.libertyreserve.com/en/home/downloads , but it doesnt exactly have the credit features and cart features I stated above, however I'm sure can be somewhat useful in coding what I need.

Any help would be greatly appreciated, since I have no idea where to start. I'm sure this is basic to some, and well I'm looking to hire someone if they are confident they can complete this quick, otherwise any free feedback would help so much.

Here is the site so far... http://www.eliteids.com/lrstore

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

i want to make virtual money (credits, tokens) whatever you want to call it but make no mistake this is not for profit at this point but i like the concept of visitors having something to do with other members of site for example to kill bordom and create a reason to play games, compete in competetions, it will have to conversion to real money at this point but i wish to do this script using php and mysql and have very basic coding skills in these areas anyone please help me make this script...


reply and let me know if you like this idea


please help me as this is achievable as fb has it and more sites are moving toward these same ideas, even tho fb is real money it is more to do with fun at this point until we do this stage another stage canot proceed it.