• Member Avatar for patk570
    patk570

    Replied To a Post in I need to declare a variable and use it for my edit button updateID

    Instead of contactid in the php code on the bottom change it “ticketnumber” or use a ‘if(isset….. )‘ code
  • Member Avatar for patk570
    patk570

    Began Watching I need to declare a variable and use it for my edit button updateID

    I have a subform called "Contacts" embedded on my "Tickets" page. I want to create an edit button to jump to my contacts_edit.php page and use the 'ContactEntryNumber' (the unique …
  • Member Avatar for patk570
    patk570

    Replied To a Post in updating names not values

    Echo $sql in your first statement and see what values are being submitted. See if any are null or not being converted to strings that is unrecognizable.
  • Member Avatar for patk570
    patk570

    Replied To a Post in php variable issue

    one thing is where is the new status coming from? is it coming from the URL? if so, you can have something like: <!DOCTYPE html> <html> <body> <?php <?php if(isset($_GET['status'])){ …
  • Member Avatar for patk570
    patk570

    Began Watching php variable issue

    I need to add variable called $new_status, but its not being recognised on php, any suggestions. $sendData = '{ "messages" : [ { "content" : "Your order is $new_status.", } …
  • Member Avatar for patk570
    patk570

    Replied To a Post in updating names not values

    $sql = "UPDATE payfile set amtpaid = '', late ='', hudpay ='', paidsum ='', datepaid ='', latechg = '', secdep = '', damage = '', courtcost = '', nsf = …
  • Member Avatar for patk570
    patk570

    Began Watching updating names not values

    > Hi guys, I blinked and got lost. All I want to do is copy Payfile to Pmtfile and then update records in Payfile that have been paid(amtpaid !=''). The …
  • Member Avatar for patk570
    patk570

    Marked Solved Status for Add Elements to Static Picture

    Hi Everyone, I am looking for a way to add a username to confirm a seat choice for certain weeks, I already have the PHP Code to confirm the seat …
  • Member Avatar for patk570
    patk570

    Gave Reputation to rproffitt in Add Elements to Static Picture

    Let's check out this tutorial -> https://www.w3schools.com/howto/howto_css_image_text.asp
  • Member Avatar for patk570
    patk570

    Created Add Elements to Static Picture

    Hi Everyone, I am looking for a way to add a username to confirm a seat choice for certain weeks, I already have the PHP Code to confirm the seat …
  • Member Avatar for patk570
    patk570

    Began Watching Add Elements to Static Picture

    Hi Everyone, I am looking for a way to add a username to confirm a seat choice for certain weeks, I already have the PHP Code to confirm the seat …
  • Member Avatar for patk570
    patk570

    Created Use jQuery Autocomplete to populate from multidimenisonal JSON array

    I have a JSON array that has multidimensions to it: { "@id": "a", "@label": "A", "drecord": [ { "@id": "aaliyah", "@rdate": "2001-08-25", "@lease": "bh05", "name": { "surname": "Aaliyah" }, "job": …
  • Member Avatar for patk570
    patk570

    Began Watching Use jQuery Autocomplete to populate from multidimenisonal JSON array

    I have a JSON array that has multidimensions to it: { "@id": "a", "@label": "A", "drecord": [ { "@id": "aaliyah", "@rdate": "2001-08-25", "@lease": "bh05", "name": { "surname": "Aaliyah" }, "job": …
  • Member Avatar for patk570
    patk570

    Replied To a Post in accessing data on MultiLevel Json Array

    This is what is returned
  • Member Avatar for patk570
    patk570

    Replied To a Post in accessing data on MultiLevel Json Array

    Hi, thanks for the reply, i updated my code as follows: var jsonArray = results; var li; for(var i in jsonArray){ var objectInstance = jsonArray[i]; for(var j in objectInstance.drivers) { …
  • Member Avatar for patk570
    patk570

    Created accessing data on MultiLevel Json Array

    Hey everyone, I have a JSON array that pulls data, its an immense amount of data that i use. It is a multilevel array eg: dateTime: 2018-12-04T10:30:45:222z comments:"" +Driver[0] [0] …
  • Member Avatar for patk570
    patk570

    Began Watching accessing data on MultiLevel Json Array

    Hey everyone, I have a JSON array that pulls data, its an immense amount of data that i use. It is a multilevel array eg: dateTime: 2018-12-04T10:30:45:222z comments:"" +Driver[0] [0] …
  • Member Avatar for patk570
    patk570

    Marked Solved Status for I know Im Close,..But I have a JS Problem

    I have a code that pulls a JSON response, and I need to compare times from now() and a previous when the timestamp was created. I am able to pull …
  • Member Avatar for patk570
    patk570

    Created I know Im Close,..But I have a JS Problem

    I have a code that pulls a JSON response, and I need to compare times from now() and a previous when the timestamp was created. I am able to pull …
  • Member Avatar for patk570
    patk570

    Began Watching I know Im Close,..But I have a JS Problem

    I have a code that pulls a JSON response, and I need to compare times from now() and a previous when the timestamp was created. I am able to pull …
  • Member Avatar for patk570
    patk570

    Replied To a Post in Cannot display ID in my view page **i can view name, address, contact No, L

    are you passing the `id` variable in the link to the page? When you do a $_REQUEST['id'] its looking for `?id=1 or ?id=testuser` in the link from the previous page.
  • Member Avatar for patk570
    patk570

    Began Watching Cannot display ID in my view page **i can view name, address, contact No, L

    <?php require('db.php'); include("auth.php"); $id=$_REQUEST['id']; $query = "SELECT * from new_record where id='".$id."'"; $result = mysqli_query($con, $query) or die ( mysqli_error()); $row = mysqli_fetch_assoc($result); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> …
  • Member Avatar for patk570
    patk570

    Replied To a Post in php,mysql

    Whats the error? and you are also wide open to [SQL Injection](https://www.w3schools.com/sql/sql_injection.asp). After `$qur` put `or die("Mysqli Error: " $qur");`
  • Member Avatar for patk570
    patk570

    Began Watching php,mysql

    Hi Friends i am trying to isert this data to mysql database. However I cannot get this done because I do not know what is happening. I would appreciate any …
  • Member Avatar for patk570
    patk570

    Replied To a Post in question: Do i need to do a formula for each state calculation

    Here is where i got to so far. CaclulateTaxGallons = function() { $('tr.IFTAtable').each(function(i, el) { var $this = $(this), $miles = $this.find('[name="stateMiles\\[\\]"]'), $mpg = $this.find('[name="mpg\\[\\]"]'), c = parseFloat($miles.val()), q = …
  • Member Avatar for patk570
    patk570

    Replied To a Post in question: Do i need to do a formula for each state calculation

    I am trying to figure out this loop for the math statement, I am completely lost on how to do it based on each state. Here is my fiddle on …
  • Member Avatar for patk570
    patk570

    Replied To a Post in Simple Jquery Math issue

    when i populated the number...i had a localization string `.toLocaleString()` and it was messing up the number. Once i removed the `.toLocaleString()` it fixed it and its now working beautifully. …
  • Member Avatar for patk570
    patk570

    Marked Solved Status for Simple Jquery Math issue

    Guys and gals, I am trying to do a simple LITTLE DIVIDE problem using jQuery its getting the values, but when its returning the results, it as if they are …
  • Member Avatar for patk570
    patk570

    Created Simple Jquery Math issue

    Guys and gals, I am trying to do a simple LITTLE DIVIDE problem using jQuery its getting the values, but when its returning the results, it as if they are …
  • Member Avatar for patk570
    patk570

    Began Watching Simple Jquery Math issue

    Guys and gals, I am trying to do a simple LITTLE DIVIDE problem using jQuery its getting the values, but when its returning the results, it as if they are …
  • Member Avatar for patk570
    patk570

    Replied To a Post in question: Do i need to do a formula for each state calculation

    but that still isnt what i am wondering, Each `input` is going to have a state eg: `<td><input type="text" readonly="readonly" class="WV calcTax" /></td>` `<td><input type="text" readonly="readonly" class="PA calcTax" /></td>` `<td><input …
  • Member Avatar for patk570
    patk570

    Replied To a Post in question: Do i need to do a formula for each state calculation

    Okay, so ill make it a text box where they put the value they get from the feds., but my main focus, is how would i calculate each row of …
  • Member Avatar for patk570
    patk570

    Replied To a Post in question: Do i need to do a formula for each state calculation

    Hello rproffitt, We are a trucking company, the taxes are basically going to hard coded into a PHP Database, I know that they will change and I will be responsibe …
  • Member Avatar for patk570
    patk570

    Created question: Do i need to do a formula for each state calculation

    Hey everyone, I have a table, that is going to used to calculate IFTA, its a fueltax calculator populated by each state and the rate of each state. My question …
  • Member Avatar for patk570
    patk570

    Began Watching question: Do i need to do a formula for each state calculation

    Hey everyone, I have a table, that is going to used to calculate IFTA, its a fueltax calculator populated by each state and the rate of each state. My question …
  • Member Avatar for patk570
    patk570

    Replied To a Post in Do i need $each() if i have for loop in JS?

    another screenshot
  • Member Avatar for patk570
    patk570

    Replied To a Post in Do i need $each() if i have for loop in JS?

    here is the output
  • Member Avatar for patk570
    patk570

    Replied To a Post in Do i need $each() if i have for loop in JS?

    Hi PTY, here is my Fiddle its just showing the js code i am using. [Fiddle](https://jsfiddle.net/15ppzrzv/1/)
  • Member Avatar for patk570
    patk570

    Created Do i need $each() if i have for loop in JS?

    Question, I have a `$each(array, function());` and within that statement, i have a` for` loop , Is it safe to be doing this? and could this be the reason that …
  • Member Avatar for patk570
    patk570

    Began Watching Do i need $each() if i have for loop in JS?

    Question, I have a `$each(array, function());` and within that statement, i have a` for` loop , Is it safe to be doing this? and could this be the reason that …
  • Member Avatar for patk570
    patk570

    Marked Solved Status for Using DataTable.net to display JS array values from API

    6 ●4 I have a code that displays an array from GeoTab SDK, I am able to get the array to display in the console.log, and it populates the results …
  • Member Avatar for patk570
    patk570

    Created Using DataTable.net to display JS array values from API

    6 ●4 I have a code that displays an array from GeoTab SDK, I am able to get the array to display in the console.log, and it populates the results …
  • Member Avatar for patk570
    patk570

    Began Watching Using DataTable.net to display JS array values from API

    6 ●4 I have a code that displays an array from GeoTab SDK, I am able to get the array to display in the console.log, and it populates the results …
  • Member Avatar for patk570
    patk570

    Created convert JSON.stringify to HTML Table

    Hey everyone, I have a script that does an API call, the results are displayed in a json array, but i am trying to break them down into HTML tables …
  • Member Avatar for patk570
    patk570

    Began Watching convert JSON.stringify to HTML Table

    Hey everyone, I have a script that does an API call, the results are displayed in a json array, but i am trying to break them down into HTML tables …
  • Member Avatar for patk570
    patk570

    Marked Solved Status for SCRIPT438: Object doesn't support property or method 'ajax'

    Hey everyone, this code below is giving me a weird error, Script 438: Object doesn't support property or method 'ajax'. I am testing this in Microsoft Edge, but...I have a …
  • Member Avatar for patk570
    patk570

    Replied To a Post in SCRIPT438: Object doesn't support property or method 'ajax'

    It was something completely stupid, I was using the slim version of jQuery CDN, instead of the full version. It was a simple mistake that was overlooked until i went …
  • Member Avatar for patk570
    patk570

    Replied To a Post in SCRIPT438: Object doesn't support property or method 'ajax'

    Hi rproffitt, I am unable to run this on chrome either, its throwing the error that $.ajax is not a function??? I never heard of this.
  • Member Avatar for patk570
    patk570

    Created SCRIPT438: Object doesn't support property or method 'ajax'

    Hey everyone, this code below is giving me a weird error, Script 438: Object doesn't support property or method 'ajax'. I am testing this in Microsoft Edge, but...I have a …
  • Member Avatar for patk570
    patk570

    Began Watching SCRIPT438: Object doesn't support property or method 'ajax'

    Hey everyone, this code below is giving me a weird error, Script 438: Object doesn't support property or method 'ajax'. I am testing this in Microsoft Edge, but...I have a …

The End.