Jump to content

techker

Members
  • Content Count

    808
  • Joined

  • Last visited

Community Reputation

0 Neutral

About techker

  • Rank
    Prolific Member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. That works great..love your php style...not there yet...lol
  2. would you know why it dow's one more than en what i ask?is it the select i did?that would calculate 0 as 1? great example il try it out.again thx for the help!
  3. even with a different approach same thing if i put 1 it updates 2 for ($h = 1; $h <= $CreditCount; $h++) echo "<option value='$h'>$h</option>"; echo "</select>";
  4. Uhh stupid me lol So first issue was that i forgot to add AND Status != 'Used' . so it would update a used code..that is why i would not see it .. But the issue i have now is that if i select 1 credit it puts 2 is it because it is like an array that 0 is 1 so it would do 0 then 1 so gives 2? have a feeling it is this: its were i add the user.it gets the amount of credits the user has(code) and puts them in a select for his to select the amount to transfer so he knows how many he can transfer.. $range = range(1,$CreditCount); foreach ($range as $cm) { echo "<option value='$cm'>$cm</option>"; } echo "</select>"; ?>
  5. same issue very odd...it does not update at all... require_once 'config/dbconnect.php'; $userid = strip_tags($_GET['user']); $subid = strip_tags($_GET['newUser']); $cr = strip_tags($_GET['cr']); $userida = $DBcon->real_escape_string($userid); $subida = $DBcon->real_escape_string($subid); $cra = $DBcon->real_escape_string($cr); $stmt = $DBcon->prepare("UPDATE Codes SET UserID = ? WHERE UserID = ? LIMIT ?"); $stmt->bind_param('iii', $subida, $userida, $cra); $stmt->execute(); if(!$stmt->execute()) { echo "Error: " . mysqli_error($DBcon); }else{ echo "Success adding user : $subida with : $cra "; echo "<meta http-equiv=Refresh content=1;url=Subseller.php?success=1 >"; }
  6. Credits stay the same even do the echo says 2 credits from to ...
  7. thats odd i logout login works but after that does not work anymore..even if i logout again...unless its a cash issue..
  8. ok odd it seems to be working now!lol.must of been my session was expirerd?let me test to see Thx!!
  9. im echoing the correct POST credits: 2 Updated! new owner: 36 from owner: 18
  10. ya its odd..why is it not working for me.... ini_set("display_errors", 1); header("Refresh: 30"); require_once 'config/dbconnect.php'; $userid = $_POST['OwnerID']; $subid = $_POST['SubID']; $cr = $_POST['credits']; $stmt = $DBcon->prepare("UPDATE Codes SET UserID = ? WHERE UserID = ? LIMIT ?"); $stmt->bind_param('iii', $subid, $userid, $cr); $stmt->execute(); echo "$userid<br /><br /><em>$cr Updated! $subid</em><br /><br />"; echo "<meta http-equiv=Refresh content=1;url=SwapC.php?success=1 >"; ?>
  11. not sure how to export it..lol so basically: CID Value DateIn Status . UserID . DateSold 1 . 24242 2019-11-11 . 0 5 null 2. 24243 2019-11-11 . 0 5 null 3 . 24244 2019-11-11 . 0 5 null 4 . 24245 2019-11-11 . 0 3 null 5 . 24246 2019-11-11 . 0 3 null 6. 24246 2019-11-11 . 0 4 null 7 . 24246 2019-11-11 . 0 4 null user is 5 . want to give 2 codes(value) to user 3 any value(code) should be : CID Value DateIn Status . UserID . DateSold 1 . 24242 2019-11-11 . 0 5 null 2. 24243 2019-11-11 . 0 3 null 3 . 24244 2019-11-11 . 0 3 null 4 . 24245 2019-11-11 . 0 3 null 5 . 24246 2019-11-11 . 0 3 null 6. 24246 2019-11-11 . 0 4 null 7 . 24246 2019-11-11 . 0 4 null
  12. what do you need?? CREATE TABLE `Codes` ( `CID` int(11) NOT NULL, `Value` varchar(100) NOT NULL, `DateIn` varchar(25) NOT NULL, `Status` varchar(25) NOT NULL, `UserID` varchar(25) NOT NULL, `DateSold` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  13. no lol CID Value DateIn Status UserID DateSold i tried: but stays at same.. $userid = mysqli_real_escape_string($DBcon, $_POST['OwnerID']); $subid = mysqli_real_escape_string($DBcon, $_POST['SubID']); $cr = mysqli_real_escape_string($DBcon, $_POST['credits']); $stmt = $DBcon->prepare("UPDATE Codes SET UserID = ? WHERE UserID = ? LIMIT ? "); $stmt->bind_param('iii', $subid, $userid, $cr); $stmt->execute();
  14. also tried $size = count($_POST['credits']); $i = 0; while ($i < $size) { $UserIDa= $_POST['OwnerID'][$i]; $NewRIda = $_POST['SubID'][$i]; $query = "UPDATE Codes SET UserID= '$UserIDa' WHERE UserID = '$NewRIda'"; mysqli_query($DBcon,$query) or die ("Error in query: $query"); echo "$UserIDa<br /><br /><em>Updated!</em><br /><br />"; ++$i; } table code is set id value userid status dateSold
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.