Sunamena

Members
  • Content count

    75
  • Joined

  • Last visited

Community Reputation

3 Neutral

About Sunamena

  • Rank
    Newbie
  1. Thankyou very much for your reply! Well, I will stick with PDO then. I managed to find a solution to make it work with PDO (and I am happy with that ). I did get error messages, but not anymore. I think the problem was on my end (or i was not patient enough). At the top of my document, to keep it organised i check all my input from the post. For the password i hash with sha1. Should i adopt using password_hash instead?
  2. Hello everyone I have a small problem with my code. I will show the most important parts of it and hope you guys can assist me This is my code: $sql = "SELECT * FROM brusers WHERE userName = '$userName' AND password = '$wachtwoord'"; // Vraag alle resultaten op $stmt = $con -> prepare($sql); $deelStap=mysqli_query($con,$sql); $result=mysqli_fetch_all($deelStap,MYSQLI_NUM); // of: $result=mysqli_fetch_all($deelStap,MYSQLI_NUM); print_r($deelStap); This is the print_r: mysqli_result Object ( [current_field] => 0 [field_count] => 12 [lengths] => [num_rows] => 0 [type] => 0 ) When i print_r($result) i get an empty array. How do i get $result as an array? I am used to using PDO (i like it alot), my PDO code works fine on my localhost: -- Connect with databasw with PDO $db = new PDO('mysql:host=localhost:3307;dbname=handikrap', 'root', 'usbw'); $db -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); --- code $sql = "SELECT userID, userName, type, ban, laatstIngelogd, inlogPogingen FROM users WHERE userName = :userName AND passWord = :wachtwoord"; $stmt = $db -> prepare($sql); $stmt -> bindParam(':userName', $userName, PDO::PARAM_INT); $stmt -> bindParam(':wachtwoord', $wachtwoord, PDO::PARAM_INT); $userName = htmlspecialchars($_POST["userName"]); $wachtwoord = htmlspecialchars(sha1($_POST["wachtwoord"])); $stmt -> execute(); $row = $stmt -> fetch(PDO::FETCH_NUM); but seems to not be supported on the webhost of one.com. Or did i do something wrong? Should i stick with PDO or move on to mySqli? They use MariaDB on one.com. Thanks in advance
  3. The new code should be MySqli $sql="SELECT * FROM nieuws ORDER BY nieuwsID desc"; $deelStap=mysqli_query($con,$sql); $result=mysqli_fetch_all($deelStap,MYSQLI_NUM); $numberInResult = count($result); But how to fetch one?
  4. Hey all, I have created a website on my local host. Now that i try to upload it, i get many errors. Such as this one: $result = $stmt -> fetchAll(PDO::FETCH_NUM); ERROR: Fatal error: Uncaught Error: Call to undefined method mysqli_stmt::fetchAll() in /customers/c/5/e/sunamena.be/httpd.www/eldiemus/nieuws.php:290 Stack trace: #0 {main} thrown in /customers/c/5/e/sunamena.be/httpd.www/eldiemus/nieuws.php on line 290 And will this still be valid? $stmt -> bindParam(':datum', $datum, PDO::PARAM_INT); I also had to change my connection method from $db = new PDO('mysql:host=urlToDatabasel;dbname=DatabaseName', 'DatabaseName', 'NotARealPassword'); $db -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); to $con=mysqli_connect("sunamena.be.mysql", "sunamena_be", "s6X6tyUj", "sunamena_be"); This is still save to use without the setAttribute?
  5. Thanks. This problem has been solved =D
  6. Hello everyone, I have an issue with uploading an image, but i can not seem to figure out what might be the problem. I am new to adding images. I would like to thank you all in advance for your asistance =D This is the PHP code: And this is the form
  7. Hello everyone. The Flexbox design I am currently working on, is working fine as you can see here: http://bronies.be/example/index.html But there is an error on the following pages: http://bronies.be/example/contact.php It does not cover the full width. And even worse here: http://bronies.be/example/404.html It does not even show the aside image. Disclaimer: This is a work in progress. Only parts of the website have been uploaded in order to ask this question. I notice that this happens on pages with little content. But i do not want this to happen, but it does. What am I exactly doing wrong? Thanks in advance for your assistance!
  8. Your code is fine. It works over here. Did you try it in different browsers? I used Chrome. Remember, if you ever visited the page, the color will be selected FROM visited, and not from link. Delete your cookies, close your browser, or try to type a link to a website your sure you have not yet visited.
  9. As dsonesuk sayd: you have to select them and then assign css to them. For example i have <td class="dontShow"> on my website. I do not want this cell to be seen. I have two options in CSS. .dontShow { Display: none; } Or .dontShow { Visibility: hidden; } The difference is, that display none will remove it from your webpage and the visibility will just make it not be there, but it will still take up the space as if it did exist.
  10. Strange something: It does indeed work like this: <head> ,,, <script type="text/javascript"> function insertText(elemID, text) { var elem = document.getElementById(elemID); elem.value += (' ' + text); } </script> ... </head> But i encounter the issues when i do this: <head> ... <script src="js/mylibrary.js"></script> ... </head
  11. Thanks, this works =D it seems that %s% Includes S and s. =D
  12. As soon as i start typing in the textarea and press the image with the onclick command, it stops functioning. Both innerHTML and value put the content IN the textarea, but NOT anymore once any action has been preformed inside the textarea (such as deleted or typed something)
  13. This is currently my Function: function insertText(elemID, text) { var elem = document.getElementById(elemID); elem.innerHTML += text; } And this is my onclick: onclick="insertText('bericht', 'mytext');" What it needs to do is add mytext at the END of the current text in my Textarea. This function works, but as soon as i enter something IN the textarea, the function stops working. Does anyone here know how to solve this issue?
  14. Is a flexbox what you are looking for? With a flexbox you can easily grid content. And i find it easy to get it responsive. Here you can find a step by step guide. https://css-tricks.com/snippets/css/a-guide-to-flexbox/
  15. Is it possible to share the HTML and CSS code required for your entire canvas? That way we can better see and help solve your issue