Skip to content
View in the app

A better way to browse. Learn more.

Web Designer Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

inlinedivblock

Members
  • Joined

  • Last visited

Solutions

  1. inlinedivblock's post in How to Import Excel Data To MySQL Using PHP was marked as the answer   
    you could try putting all the existing roll's in an array!
    So you can make array from existing "rollno"
     
    Then you can use this php function if (in_array($rollno, $rollarray)) etc...
    http://uk1.php.net/in_array
  2. inlinedivblock's post in Sorry to keep posting was marked as the answer   
    <?php $mysqli = new mysqli(); $text = $mysqli->real_escape_string($_GET['term']); $query = "SELECT * FROM products WHERE productcodes LIKE '%$text%' ORDER BY productcodes ASC"; $result = $mysqli->query($query); while($row = $result->fetch_assoc()) { ?> <script> $("input[type='text'][name='quantity']").keyup(function () { var value = $(this).val('<?php echo $row['qty']?>'); }).keyup(); $("input[type='text'][name='ponumber']").keyup(function () { var value = $(this).val('<?php echo $row['ponumber'] ?> '); }).keyup(); </script> <?php } ?>  
    This is with JQUERY it is the simplest solution i can come up with, it targets the INPUT fields with the relevant name that you have used and fills it in from the results returned on the search. You may want to limit results to 1 on the mysql query,
    $row[''] <--- inside here you need to call the correct fiield name, not sure what you called them in your database, i just guessed
     
    But this should help you understand how to fill it in live?
     
    see it working here in theory http://jsfiddle.net/hdhJw/
  3. inlinedivblock's post in mysql_real_escape_string() Advice was marked as the answer   
    mysql_real_escape_string(); will stop a majority of issues, also will your form be open to anyone? or staff who have to fill in a form?
     
    Are you going to be doing error checking? such as making sure that where you put QTY that only numbers will be accepted and not letters and so on....
  4. inlinedivblock's post in All Text boxes post to database except this one plz help was marked as the answer   
    $proddesc=$_POST['productdescription']; to $proddesc=$_POST['proddesc']; the names in the input didnt match!

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.