Jump to content
#StayAtHome ×

techker

Members
  • Content Count

    809
  • 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. Hey guys i need to echo this: Up to know i tried lots of combos but can seem to get the Array correctly? it echos : but the [ needs to be at results.... Thx for the help
  2. That works great..love your php style...not there yet...lol
  3. 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!
  4. 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>";
  5. 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>"; ?>
  6. 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 >"; }
  7. Credits stay the same even do the echo says 2 credits from to ...
  8. thats odd i logout login works but after that does not work anymore..even if i logout again...unless its a cash issue..
  9. ok odd it seems to be working now!lol.must of been my session was expirerd?let me test to see Thx!!
  10. im echoing the correct POST credits: 2 Updated! new owner: 36 from owner: 18
  11. 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 >"; ?>
  12. 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
  13. 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;
  14. 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();
×
×
  • 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.