Jump to content

afallingpanda

Members
  • Posts

    33
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

afallingpanda's Achievements

Member

Member (2/5)

0

Reputation

  1. your all a bunch of retards, im out, go fuck ur mothers
  2. okay so ive just reported your post and i will see to blocking you on this site some how, reason being you have absolutely no knowledge in fixing this so you are just posting complete junk for god knows what reason, "Do something to solve this your self" = you absolute idiot, wtf you think i been doing for last 2 days. "instead of whining about what to do"= err this is a forum where people ask for help, if you dont like it then get out. and also, i showed you a picture of the query running and outputting the records, so again dont ask for code that is already pretty much had evidence shown to, It is not duplicate data because its the only data thats in there ( i delete them all one by one) . next time, dont pretend like you CAN solve problems when you clearly dont even know what your talking about. To all others: sorry about the above, his just really annoyed me, i would appreciate if you could help me out. thanks
  3. IVE SHOWN YOU CODE. Tell me what code you want to see and il show you.
  4. because i went into the database my self and saw that they were entered as ones, what information do you need, that i can tell you, all the field types are there. and they are all INT apart from "username" ,"system", and "reference" aka "verified" If you read my whole post and clicked on the link, you wouldnt of asked the question of how i know the ones are produce, just like previously where you didnt read my previous thread and thought i was using PDO and not PDOStatement
  5. obviously there are not any errors lol, otherwise i would of solved it. SO I CANT CHECK FOR ERRORS IN MY CODE!
  6. the ones im not using bound params for is game_id, mode_id, map_id
  7. a) what is a database table definition? b) no chance.
  8. hello guys, so i have an interface that inserts data into a mysql database with PDO. so i am binding params, however not everything in my query is binded, as some of them are just ints which i entered my self (see below): $query = $pdo->prepare('INSERT INTO leaderboards (rank, username, rounds, players, last_round_time, system, verified, game_id, mode_id, map_id) VALUES (?, ?, ?, ?, ?, ?, ?, 3, 1, 8)'); $query->bindValue(1, $rank); $query->bindValue(2, $username); $query->bindValue(3, $rounds); $query->bindValue(4, $players); $query->bindValue(5, $lastroundtime); $query->bindValue(6, $system); $query->bindValue(7, $reference); $query->execute(); Now as you can see the game_id,mode_id,and map_id are the ones which i set the value of in the query. here is the result in the table: http://gyazo.com/93facff162aa944043176c31119eb16b As you can see all the data is succesfully inserted depending on what the user types into the interface, but the last 3 columns are for some reason "1" and not the ones i put in the query? Why is this? please help? mabey some syntax fault?
  9. Hello guys, so let me give some information, i have a database which is storing some information, and im building a simple search feature which just searches for particular things in the database. however something is not working, here is my code and the results: if (isset($_POST['usernamesearch'], $_POST['gamesearch'], $_POST['modesearch'], $_POST['mapsearch'])){ $usernamesearch = $_POST['usernamesearch']; $gamesearch = $_POST['gamesearch']; $modesearch = $_POST['modesearch']; $mapsearch = $_POST['mapsearch']; class Leaderboarded{ public function fetch_all(){ global $pdo; global $usernamesearch; global $gamesearch; global $modesearch; global $mapsearch; $query = $pdo->prepare('SELECT * FROM leaderboards WHERE username="?" AND game_id="?" AND mode_id="?" and map_id="?"'); $query->bindValue(1, $usernamesearch); $query->bindValue(2, $gamesearch); $query->bindValue(3, $modesearch); $query->bindValue(4, $mapsearch); $query->execute(); return $query->fetchAll(); } } $leaderboarded = new Leaderboarded; $leaderboardeds = $leaderboarded->fetch_all(); <table cellpading=0 cellspacing=0 border=1> <tr> <th>playerID</th> <th>Username</th> <th>Rank</th> <th>System</th> <th>Wins</th> <th>Losses</th> <th>Kills</th> <th>Returns</th> <th>Verified</th> <th>Revives</th> <th>Downs</th> <th>Taints</th> <th>Rounds</th> <th>players</th> <th>LastRoundTime</th> <th>TotalTime</th> <th>mode_id</th> <th>map_id</th> <th>game_id</th> </tr> <?php foreach ($leaderboardeds as $leaderboarded){ ?> <tr> <td><?php echo $leaderboarded['player_id']; ?></td> <td><?php echo $leaderboarded['username']; ?></td> <td><?php echo $leaderboarded['rank']; ?></td> <td><?php echo $leaderboarded['system']; ?></td> <td><?php echo $leaderboarded['wins']; ?></td> <td><?php echo $leaderboarded['losses']; ?></td> <td><?php echo $leaderboarded['kills']; ?></td> <td><?php echo $leaderboarded['returns']; ?></td> <td><?php echo $leaderboarded['verified']; ?></td> <td><?php echo $leaderboarded['revives']; ?></td> <td><?php echo $leaderboarded['downs']; ?></td> <td><?php echo $leaderboarded['taints']; ?></td> <td><?php echo $leaderboarded['rounds']; ?></td> <td><?php echo $leaderboarded['players']; ?></td> <td><?php echo $leaderboarded['last_round_time']; ?></td> <td><?php echo $leaderboarded['total_time']; ?></td> <td><?php echo $leaderboarded['mode_id']; ?></td> <td><?php echo $leaderboarded['map_id']; ?></td> <td><?php echo $leaderboarded['game_id']; ?></td> </tr> <?php } ?> </table> </div><?php } } ?> Now.. this is what is outputted on the screen: http://gyazo.com/1cdd7548ee4b01c85dd4c4ca5dbdaf24 As you can see i think the problem is that the last part where the data is ment to be outputted, isnt working. but why? any help will be very appretiated, thanks
  10. right yes, but when i looked into wordpress it seems it makes me want to sign up to a new domain and what not just for a blogging site, im wanting just a script or something i can download onto my EXISTING sites and just to add it to one of my pages.
  11. hello guys, so im in need of some help today, basically in my website i am making a page called "news" in which staff members can make announcement/posts/blogs or whatever you want to refer to it as, i would give an example but pretty much i think people know what i mean. now the problem is i could build mabey a cms and just link it in through a database, but because im on a short time rate, i was wondering is there any sort of free addons i can install via my control panel (cpanel from hostgater) or any existing scripts that can do this. thanks so much
  12. UPDATE: Ive added this code to make the fade in happen: <script> $(document).ready(function(){ $(document).ready(function(){ $("#div1").fadeIn(5000); $("#div11").fadeIn(5000); $("#div12").fadeIn(5000); $("#div13").fadeIn(5000); $("#div2").fadeIn(7000); $("#div22").fadeIn(7000); $("#div23").fadeIn(7000); $("#div24").fadeIn(7000); $("#div3").fadeIn(9000); }); }); </script> and it fades in my images AND text in google chrome, but in internet explorer only my text fades in, my images wont fade in. HOW do i make it work on internet explorer too?
  13. so ive got some text on my site and i was wondering how i would make that text fade in when the page is loaded. i dont mind if its jquery or js thanks in advanced.
×
×
  • 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.