76 Discussion / Question Topics

Remove Filter
Member Avatar for patk570

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 when choosing but on the image i would like for it to display the username so other people know its …

Member Avatar for rproffitt
0
1K
Member Avatar for patk570

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": "hip hop singer/actress", "dead": { "@value": "y" }, "cause": "Burned to death in a plane crash", "ddate": { "date": "2001-08-25" …

Member Avatar for alan.davies
0
2K
Member Avatar for patk570

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] fname: John lname: Doe driverCode: DOEJ [1] fname: Mary lname: Smith driverCode: SMIMA more info etc I am trying to …

Member Avatar for ndeniche
0
3K
Member Avatar for patk570

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 the info and have it display. However, when i try and get the comparison to work it just sits there …

Member Avatar for jkon
0
396
Member Avatar for patk570

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 i am getting the same values multiple times returned even though the object array length is 8, i am getting …

Member Avatar for Kannu_2
1
455
Member Avatar for patk570

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 is, do i need to create a formula for each state? or can i do 1 formula and have it …

Member Avatar for patk570
0
513
Member Avatar for patk570

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 being divided by 10000, but I know its not... E.G. 50506/1000 = 50.506 in my jquery problem, it is coming …

Member Avatar for patk570
0
333
Member Avatar for patk570

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 like normal, However, When I try to populate the data in the table, nothing shows but the headings. Here is …

0
218
Member Avatar for patk570

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 here is my code var deviceId = ""; api.call("Get", { typeName : "DutyStatusLog", search : { deviceSearch : { driver …

Member Avatar for rproffitt
0
5K
Member Avatar for patk570

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 website that uses this exact same code, and its working like normal. I am getting the `var id` to load …

Member Avatar for patk570
0
5K
Member Avatar for patk570

Hey everyone, I got bored one day and created this little jem. There are no issues with it, but it may help somone out later on down the road if they have a simple project that needs to be completed. Everything is on one pages and includes elements …

Member Avatar for patk570
2
3K
Member Avatar for patk570

So i have a simple script nothing to big, but im already getting an unexpected "updateTime" $sql = "UPDATE users SET last_login = NOW() "; $updateTime = $this->db_connection->exec($sql); THis is my first time using PDO and I am already getting errors after 2 lines...

Member Avatar for jstfsklh211
0
285
Member Avatar for patk570

Cannot get this to refresh. My code is below. I am propably doing something silly, but I cannot figure it out... var auto_refresh = setInterval( function(e) { var email = '<?php echo $_SESSION['user_email']?>'; console.log(email); e.preventDefault(); $.ajax({ type : 'GET', url : 'count_record.php', // in here you should put your query …

Member Avatar for michael.dewitt.716
0
225
Member Avatar for patk570

Hey everyone, I have a site that has a customer account, right now it looks like crap and i need an idea on how to style it. Right now I am using Bootstrap, but I want to move away from it and try something else. My issue is, I have …

Member Avatar for patk570
0
206
Member Avatar for patk570

I am trying to populate the data in a modal via AJAX, but i am unsure how to do so. The link right now is `<a href="viewmessage.php?id='.$row['ID']'">View</a>` Since there is only 1 Message in the Database, the number is 70. I have seen multiple things online but I am not …

Member Avatar for patk570
0
8K
Member Avatar for patk570

I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 …

Member Avatar for cereal
0
410
Member Avatar for patk570

I have a code that is working to show images and description. But I am trying to get it to loop through 3 pictures wide, then loop again. and display them, I am going to add pagination to the script, but before i do that i need it to loop. …

Member Avatar for patk570
0
458
Member Avatar for patk570

Hey everyone, I have a MYSQLI statement that i would like to add pagination to. I would like to have it set to 5 per page, and not have a negative value if you are on page 1 (disables back link) Every tutorial i have been seeing allows for a …

Member Avatar for patk570
0
661
Member Avatar for patk570

Guys, i am getting an unexpected T_While Error on my code, I cannot figure it out. can you help? ` <?php` $sql = "SELECT id, u_name, u_email, subj, phone FROM tb_cform "; $result = $conn->query($sql); echo '<table><tr><th>Name</th><th>Email</th><th>Subjec</th><th>Phone</th></tr>'; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "<tr><td>".$row["u_name"]."</td><td>".$row["u_email"]."</td><td>".$row["subj"]."</td><td>".$row["phone"]."</td></tr>"; …

Member Avatar for diafol
0
392
Member Avatar for patk570

Hey Everyone, I am looking for possibly a CRM that can be used for multiple items: 1. Invoicing 2. Credit Card Processing 3. Front End Website 4. Customer Area/Members Pages 5. Admin Area 6. Integrate with Quickbooks? 7. Manage Employees (Time and Sales) 8. Inventory Management Any advice would be …

Member Avatar for gottaloveit
1
189
Member Avatar for patk570

hey everyone, I am looking for a website template that is mobile responsive, with a header and 3 columns. in the left and right column there will be 3 items in each with a fixed height on each. the middle column needs to be adaptable to move without affecting the …

Member Avatar for patk570
0
295
Member Avatar for patk570

Hey guys, I have a code on excel, that will count the critera if there is more than one box filled out. =COUNTIF(C5:D14,"<>0") But now i am converting this code to jquery and i cannot figure it out. on my page, there is a toggle button, yes/no selector for autopay, …

Member Avatar for Airshow
0
527
Member Avatar for patk570

Hello everyone, Have a code that works well but I need it to open to the right on hover. Right now its going below the element and making my page look bad. Here is the code i have: <style type="text/css"> .hide_img3 { display: none; } .hide_img3 { background: none repeat …

Member Avatar for sudhir869939
0
2K
Member Avatar for patk570

I have a code: $data=$_SESSION['title']; $view=$con->query("select flower.*, mystash.* from flower,mystash where mystash.name like '%$data%' OR flower.name like '%$data%' ORDER BY name ASC"); $check=$view; if($check!="") { while($descri=mysqli_fetch_object($view)) { I am trying to get the name from each table `flower` and `mystash` each have a column in there of `name` I am …

Member Avatar for kimhanu
0
247
Member Avatar for patk570

Hello, I have an array that returns city and state in this format: Detroit,MI I want it to be shown as Michigan/Detroit is there any way of doing this? Here is my foreach code: foreach ($i['popularCities'] as $a => $value) { echo '<li>' . $value . '</li>' . PHP_EOL; } …

Member Avatar for diafol
0
164
Member Avatar for patk570

Hello, I am looking for a script to add items to a database that can be found in the my account section, The table in the database is structured: id | user_id | slug I want to use the ajax to update and remove it later on down the road …

Member Avatar for matrixdevuk
0
3K
Member Avatar for patk570

Hello, I am trying to get this to loop through all the available items in a database and return the results. <?php $qry = mysqli_query($con,"SELECT * FROM `favorites` WHERE `username` = '$id'") or die(mysqli_error($con)); while($rowa = mysqli_fetch_array($qry)) { $slugname = $rowa['slug_name']; $url = $rowa['slug']; echo '<a href="'.$url.'>'.$slugname.'</a>"'; } ?> I …

Member Avatar for patk570
0
120
Member Avatar for patk570

Hello, I am getting a weird error when i try to run this array: //leafly api keys $appID ='Blah'; $appKEY = 'blah'; //init curl $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, "http://data.leafly.com/strains/".strtolower($data)); //change the strain dynamically of course for your app curl_setopt($ch,CURLOPT_HTTPHEADER,array('APP_ID:'.$appID,'APP_KEY:'.$appKEY)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $output = curl_exec($ch); //Clean it into an …

Member Avatar for broj1
0
1K
Member Avatar for patk570

Hello, I found this script and have used it for my login system. http://www.wikihow.com/Discussion:Create-a-Secure-Login-Script-in-PHP-and-MySQL I have changed some variables but none the less its the same. I am trying to create a reset password script here is what i tried so far: function resetPassword(){ //Main Info $id = $_POST['id']; $email …

Member Avatar for patk570
0
318
Member Avatar for patk570

I have a url that is `filemgr.php` when a user navigates to lower levels of said file manager it shows up as `filemgr.php#userfiles/username/Images` Is there a way to just have it show up as `filemgr.php ` with out the rest of the url showing? I am open to .htaccess editing …

Member Avatar for diafol
0
343
Member Avatar for patk570

Hey Guys, I am looking for a file manager that will allow me to customize the top level folder( to the user that is logged in) as the top level. The folder structure should be something like username Folder 1 Sub folder 1.1 Sub folder 1.2 Folder 2 Sub Folder …

Member Avatar for pritaeas
0
477
Member Avatar for patk570

I have 2 input fields that when a user inputs the date in say mm-dd-yyyy format, i would like to have it automatically change to yyyy-mm-dd (ISO 8601 Date Format) the input fields are very simple: <div class="form-group"> <label for="purchase_date">Purchase Date <font size="-3">(Year-MM-DD) format</font></label> <input type="text" name="purchase_date" class="form-control" placeholder="Purchase Date"> …

0
138
Member Avatar for patk570

Hello, I am working on some code that does a remote call to a licensing server to validate whether the license is valid, invalid, expired and suspended. I have a login code that is using prepared statements: function login($email, $password, $mysqli) { // Using prepared statements means that SQL injection …

Member Avatar for jstfsklh211
0
275
Member Avatar for patk570

I have a code that i want to throw an error if there is no items to delete or if there is items it proceeds with deleting the items, here is what i have so far: if (isset($_REQUEST['removeall'])){ if($_REQUEST['removeall'] == 1){ mysqli_query($mysqli,"DELETE FROM assets WHERE cust_id = $custID AND del_flag …

Member Avatar for Fernando_4
0
194
Member Avatar for patk570

Hey everyone, I have navbar from boostrap, I am trying to get the flags to append to the bottom/hang from the bottom of the nav on right side. [Link](https://www.assets.patrickspcrepair.com/gotya/simple-sidebar.html) to the site. The flags are just basic but i need to set the css style to "hang" from the navbar …

Member Avatar for patk570
0
231
Member Avatar for patk570

Hey guys, I have a script that switches between tabs..It works perfectly, but what i am needing is a way for the script to stop when I have my mouse on the tab or content for the tab. I am using bootstrap and here is my [fiddle](http://jsfiddle.net/patk570/5hk6R/) with the working …

Member Avatar for Troy III
0
4K
Member Avatar for patk570

Hello everyone, I am trying to get a code that will check the length of the a 'key' that will be generated in xxxxx-xxxxx-xxxxx-xx format. I need it to verify that it meets the requirements. I do not need it to validate on the server, but i do need it …

Member Avatar for JorgeM
0
408
Member Avatar for patk570

I am not sure why this is not working, Its setting the flags perfectly but will not update events... if(isset($_REQUEST['del'])){ if($_REQUEST['del'] == 1){ $asset_id = $_REQUEST['assetID']; $sql = "UPDATE assets, events SET assets.del_flag=1 , events.del_flag=1 WHERE assets.id='$asset_id' AND events.asset_id='$asset_id'" or die(mysqli_error($mysqli)); if ( $mysqli->query($sql) ) { $addevent1 = "INSERT INTO …

Member Avatar for patk570
0
142
Member Avatar for patk570

Hi everyone, I am working on a site, just one page with all the information on it. What happens now is when I scroll down the page, and I get past the navbar, it gets fixed to the top like I want. Its all working fine, but my question is, …

Member Avatar for patk570
0
137
Member Avatar for patk570

Hi, I have 2 fields that are used for date. In my fucntion, i have it format the date into Y-m-d format, $purchase_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['purchase_date'])); $warranty_end_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['warranty_end_date'])); But when I enter a date into it, it just puts 0000-00-00 I thought this was the correct format, but seems to …

Member Avatar for patk570
0
1K
Member Avatar for patk570

Hi guys, I am trying to get the last_insert_id() from the table above, that way when it sends the query and is successful, it then updates the events table with timestamp, id , asset type and asset id from the insert code. I am currently using the max(id) but its …

Member Avatar for patk570
1
2K
Member Avatar for patk570

I am trying to do a count of all types in there(hardware and software) I thought i had the correct structure...but I guess i am wrong... $count = mysqli_query($mysqli, "SELECT COUNT(*) AS total_count FROM assets WHERE cust_id=$custID AND (asset_type='hardware' AND asset_type='software') "); echo mysqli_error($mysqli); $count = mysqli_fetch_object($count); $count = $count->total_count; …

Member Avatar for patk570
0
162
Member Avatar for patk570

Hello, I have a function that is working to generate the navigation bar, it grabs the parents and the "childs" and displays them but I have noticed that it is not closing the ul, li tags properly. I will attach a screen shot below. My code is this: <? include …

Member Avatar for patk570
0
223
Member Avatar for patk570

Hello, I am looking for a calendar to use with my website that I can add tasks/appointments into the db and have them show on the calendar. I would like to edit on the fly either by using a page to create the task/appointment or via the calendar using ajax. …

Member Avatar for patk570
0
198
Member Avatar for patk570

Hello everyone, I have a code to display images in a table for a specific ticket. I am needing the table to be 4 columns wide then repeat until there is no more images to show. Here is my code: <?php $folder = "images/ticket_images/".$_REQUEST['ticketid']."/"; $filetype = '*.*'; $files = glob($folder.$filetype); …

Member Avatar for patk570
0
179
Member Avatar for patk570

Hello everyone, I am looking for a banner/slider for both images and text. I want to be able to display 3 articles that are attached to the blog I am making and have them rotate, Here is an image of where the content will go. ![47dd24c076f663f88f6d78c35f640cc9](/attachments/small/3/47dd24c076f663f88f6d78c35f640cc9.PNG "align-left") I would like …

Member Avatar for patk570
0
394
Member Avatar for patk570

Hello, I have a form that i would like to convert from JS onClick to AJAX, Here is my form: <form action="" method="post" name="filter"><input id="All" onClick="if(document.forms['filter'].elements['All'].checked)window.location.href='?page=1&amp;filter=All&amp;perpage=10'" name="All" type="checkbox" /><label style="background:#008080; font-size:small" for="All">All</label> <input id="Pending" style="background:#FF6262" onClick="if(document.forms['filter'].elements['Pending'].checked)window.location.href='?page=1&amp;filter=Pending&amp;perpage=10'" name="Pending" type="checkbox" /><label style="background:#FF6262; font-size:small" for="Pending">Pending</label> <input id="Complete" style="background:#7BCC70" onClick="if(document.forms['filter'].elements['Complete'].checked)window.location.href='?page=1&amp;filter=Complete&amp;perpage=10'" name="Complete" type="checkbox" /><label style="background:#7BCC70; …

Member Avatar for Airshow
0
489
Member Avatar for patk570

Hi Guys, I would like to highlight the current day on this php script, can you help me figure out a simple way to do this? <?php $monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); if (!isset($_GET["m"])) $_GET["m"] = date("n"); if (!isset($_GET["y"])) $_GET["y"] = …

Member Avatar for diafol
0
378
Member Avatar for patk570

Hello everyone, I have a table that i want to limit to 10 results per page and have a simple pagination script to generate the next 10 results. I have tried many different options, but alas it does not work. here is what I have so far. <tbody> <? //specify …

Member Avatar for patk570
0
176
Member Avatar for patk570

I have a simple login script that I want to test if the password is in temp status or not, if it is, then I want it to take them to changepass.php instead of index.php as seen below... but it doesnt take you to changepass.php it take you right to …

Member Avatar for phorce
0
102

The End.