Member Avatar

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in F:\xampp\htdocs\ajax\server.php on line 55 // Retrieve comments from database $sql = "SELECT * FROM comments"; $result = mysqli_query($conn, $sql); $comments = '<div id="display_area">'; while ($row = mysqli_fetch_array($result)) { $comments .= '<div class="comment_box"> <span class="delete" data-id="' . $row['id'] . '" >delete</span> <span class="edit" data-id="' . $row['id'] . '">edit</span> <div class="display_name">'. $row['name'] .'</div> <div class="comment_text">'. $row['comment'] .'</div> </div>'; } $comments .= '</div>'; ?>

+0 forum 0
Member Avatar

Hello, i have the following code: index.php <form role="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <label for="products">Product</label> <select id="products" name="products" class="user"> <?php require 'data.php'; $products = loadProducts(); foreach ($products as $product) { echo "<option id='".$product['id']."' value='".$product['id']."' selected>".$product['name']."</option>"; } ?> </select> <label for="bundles">Bundle</label> <select id="bundles" name="bundles"> </select> </form> Script <script type="text/javascript"> $(document).ready(function(){ $("#products").change(function(){ var aid = $("#products").val(); $.ajax({ url: 'data.php', method: 'post', data: 'aid=' + aid }).done(function(bundles){ console.log(bundles); bundles = JSON.parse(bundles); $('#bundles').empty(); bundles.forEach(function(bundle){ $('#bundles').append('<option>' + bundle.name + '</option>') }) }) }) }) </script> data.php <?php require 'DbConnect.php'; if(isset($_POST['aid'])) { $db = new DbConnect; $conn = $db->connect(); $stmt = $conn->prepare("SELECT * FROM bundles …

+0 forum 0
Member Avatar

I have a basic html here, where you could just submit the button through an action page, so it inserts the record into the mysql database in phpmyadmin, what I want to know is how to make it auto submit after 5 mins, while setting the blanks fields value into "0" in the database. I am currently using wamp as my local server. Is there a best way how to do this? like using javascript or ajax? this is the html code <h2><font size="6s">GHS Applicant Assessment Tool</font></h2> <h5><font size="5s"><p>This exam is an assessment tool to help us place you in …

+0 forum 0
Member Avatar

I am skilled in Core PHP, JavaScript, Mysql, Ajax, HTML, CSS, jQuery and Codeigniter and having 4+ years of experience in Web Development. I have very vast knowledge in dynamic and static website development.

+0 forum 0
Member Avatar

i wish to send another field together with my FormData, so after i googled it, they said to add append to my form data, done it. but it did not send anything to db including the content of the file. here is my code:- $('#upload_csv').on("submit", function(e){ var data = new FormData(this); data.append('test_filename', file); }); $.ajax({ url:"uploadfileprocess", method:"POST", data:{data,data}, contentType:false, cache:false, processData:false, success: function(data){ alert(data); if(data=='Error1') { alert("Invalid File"); } else if(data == "Error2") { alert("Please Select File"); } else { $('#importfiletodb').html(data); } } }) all the content and the file name should be able to save together when user click …

+0 forum 0
Member Avatar

Hello Coders, I am working on ASP.NET Web Forms. In my page there is a GridView which should have a feature to upload multiple files at the same time to the server. Can you help me in implementing this feature. I want: 1. The files should be uploaded from the GridView on the button click. 2. The upload button should be located on the footer of the GridView. 3. I want to do it in 2 ways - page postback pay and through AJAX. Thank you....

+0 forum 0
Member Avatar

I managed to get a certain PHP variable ($length) that contains the length of a message (stored in a MYSQL-database) to get passed to a javascript variable (var = length) in order to let javascript decide whether or not to show a certain marquee on a HTML-page. Initially I have used the javascript document.write statement to get the output displayed. However, using document-write "kills" the present HTML-page instead of integrating the marquee content into that HTML-page and keeping that HTML-page intact . So I have made some changes and the code I have sofar is the following: <script type="text/javascript"> var …

+0 forum 0
Member Avatar

My code about filterable audio searching, here how can i add Add-To-Cart functionality? code : index.php <?php //index.php include('database_connection.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>Voice Repository</title> <script src="js/jquery-1.10.2.min.js"></script> <script src="js/jquery-ui.js"></script> <script src="js/bootstrap.min.js"></script> <link rel="stylesheet" href="css/bootstrap.min.css"> <link href = "css/jquery-ui.css" rel = "stylesheet"> <!-- Custom CSS --> <link href="css/style.css" rel="stylesheet"> </head> <body> <!-- Page Content --> <div class="container"> <div class="row"> <br /> <div class="col-md-12"> <h2 align="center">Voice Repository Bank</h2> </div> <div class="col-md-3"> <!-- Price --> <!-- <div class="list-group"> <h3>Price</h3> <input type="hidden" id="hidden_minimum_price" value="0" /> <input type="hidden" …

+0 forum 0
Member Avatar

Hello Frds, select box option add new state in add.already same state in condition check already exist using php pdo.please help me.

-1 forum 0
Member Avatar

Here my form auto responce based on drop-down list, <tr> <th>Shipping Cost (Rs) : </th> <td id="findata"></td> <input type="hidden" name="shipping_cost" id="shipping_cost"/> </tr> <tr> Same page Ajax : <script> $(document).ready(function(){ $('#new').on('change',function(){ var zip = $("#zip_postal_code").val(); var country = $("#country").val(); $.ajax({ type: "POST", // url: "ajax_ship_cost_data.php", url: "sp_cost.php", dataType: "text", data: { zip_postal_code: zip, country: country}, success: function(data) { // Check the output of ajax call on firebug console //console.log(data); $('#findata').html(data); $('#shipping_cost').val(data); } }); }); }); </script> The field **Shipping Cost** is auto responce based following field, <tr> <th>I have : </th> <td> <select id="old" name="i_have"> <option value = "select_option">Select Option</option> <option …

+0 forum 0
Member Avatar

I have magento shipping charge code : <?php ob_start(); // require_once(__DIR__ . '/app/Mage.php'); require_once('./../app/Mage.php'); umask(0); ini_set('display_errors',true); ini_set('memory_limit', '1024M'); Mage::app()->loadArea('frontend'); function getShippingEstimate($productId,$productQty,$countryId,$postcode ) { // $quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('default')->getId()); $quote = Mage::getModel('sales/quote')->setStoreId(Mage::app()->getStore('english')->getId()); $_product = Mage::getModel('catalog/product')->load($productId); $_product->getStockItem()->setUseConfigManageStock(false); $_product->getStockItem()->setManageStock(false); $quote->addProduct($_product, $productQty); $quote->getShippingAddress()->setCountryId($countryId)->setPostcode($postcode); $quote->getShippingAddress()->collectTotals(); $quote->getShippingAddress()->setCollectShippingRates(true); $quote->getShippingAddress()->collectShippingRates(); $_rates = $quote->getShippingAddress()->getShippingRatesCollection(); $shippingRates = array(); foreach ($_rates as $_rate): if($_rate->getPrice() > 0) { $shippingRates[] = array("Title" => $_rate->getMethodTitle(), "Price" => $_rate->getPrice()); } endforeach; return $shippingRates; } // echo "<pre>"; // product id, quantity, country, postcode // print_r(getShippingEstimate('14419','1',"IN","642001")); // echo "</pre>"; $results = getShippingEstimate('14419','1',"IN","642001"); // $results = getShippingEstimate('14419','1',"US","99501"); $count = -1; echo "<select>"; foreach ($results as $result): $count++; ?> …

+0 forum 0
Member Avatar

I have predefined value like shipping_weight = 10$, my form consisting two dropdown list, if the dropdown selected based on the selection how to return my ajax value, Index.php : <tr> <th>I have : </th> <td> <select id="old" name="i_have"> <option value = "select_option">Select Option</option> <option value = "three_compact">3 Compact</option> <option value = "three_regular">3 Regular</option> <option value = "three_triple">3 Triple</option> <option value = "five_compact">5 Compact</option> <option value = "five_regular">5 Regular</option> <option value = "five_triple">5 Triple</option> <option value = "seven_compact">7 Compact</option> <option value = "seven_regular">7 Regular</option> <option value = "seven_triple">7 Triple</option> <option value = "nine_compact">9 Compact</option> <option value = "nine_regular">9 Regular</option> <option …

+0 forum 0
Member Avatar

I have dynamic page which is loading and preview page from database retrieved values. I did this with successfully. I want to remove parameters from page url. Note that I only used one parameter in url. My url is something like this. (with parameters) http://ads/ad?this=daihatsu-boon-m700s-new-design-2016-nugegoda-2019-04-05-22-49-04 I tried to remove parameters from url, (it success) then my url look like this, http://ads/ad/daihatsu-boon-m700s-new-design-2016-nugegoda-2019-04-05-22-49-04 To do that I added following codes to htaccess file, RewriteEngine On #RewriteCond %{SERVER_PORT} 80 ReWriteRule ^ad/([a-zA-Z0-9-/]+)$ ad.php?url=$1 ReWriteRule ^ad/([a-zA-Z0-9-/]+)/ ad.php?url=$1 Options +FollowSymLinks -MultiViews # Turn mod_rewrite on #RewriteEngine On RewriteBase / # To externally redirect /dir/foo.php to /dir/foo …

+0 forum 0
Member Avatar

Hi fellas, I hope my first message here comes across more helpful than bothering. I’ve recently launched a WordPress backup plugin - WPvivid Backup/Restore. It contains pretty all basic features that you’ll need to backup/restore you site and is fairly easy to use. And most important, it’s completely free(free update and support). I made it because I realized that there’s still a growing need for the easier and more affordable backup solutions in WordPress community, we hope our plugin can give people a hand. Please check it out at WordPress’ plugin repository: https://wordpress.org/plugins/wpvivid-backuprestore/ Any feedback will be greatly appreciated. Joe

+0 forum 0
Member Avatar

hiii i need your help, i am web developer (fresher). i want display images from database/folder using ajax in codeignater. i try ur source code not working.

+0 forum 0
Member Avatar

I have a very standard code where I use a CRUD interface on my Database. The issue is that every attempt I made to redraw/update the table with the new data [ $('.table').DataTable().draw(); ] has failed miserably. Here is my targeted code: function manageData(key) { var name = $("#countryName"); var shortDesc = $("#shortDesc"); var longDesc = $("#longDesc"); var editRowID = $("#editRowID"); if (isNotEmpty(name) && isNotEmpty(shortDesc) && isNotEmpty(longDesc)) { $.ajax({ url: 'ajax.php', method: 'POST', dataType: 'text', data: { key: key, name: name.val(), shortDesc: shortDesc.val(), longDesc: longDesc.val(), rowID: editRowID.val() }, success: function (response) { if (response != "success") alert(response); else { $("#country_"+editRowID.val()).html(name.val()); …

+0 forum 0
Member Avatar

I'm trying to make SSO like [Yandex](http://yandex.ru/) do. How achive authentication without redirect if user has been already authenticated at another service provider? I am working on SAML, but I could not achieve implementation without a redirect.

+0 forum 0
Member Avatar

Hey guys, Myriad Festival is coming to Brisbane next week and heaps of tech experts both local and international will be speaking there! It's my first time going to an event like this and I'm super excited to hear the industry mentors speak so I thought I'd let you all know so you could buy tickets as well if you were interested! Just search Myriad Brisbane for the extended speaker list, too many goodies to name! Hope to see you there :)

+0 forum 0
Member Avatar

I'd like to get all of a mysql table's col names in a select box, and display the selected column name in a table. I just want to select one column at a time to display it in a single column table. I am assuming this can be done with a single query for all columns because they all will be displayed in the same table format. What I did so far is this: <html> <head> </head> <body> <table id="tbresult"> <tr> <th>Column</th> </tr> <?php include ("config.php"); $sql = "SHOW COLUMNS FROM mytable"; $result = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($result)){ echo "<tr><td>" …

+0 forum 0
Member Avatar

Hi I have problem that cannot show form validation errors in view . I am using ajax to post data to controller. Here is my Controller's Validation part private function _validate() { $this->form_validation->set_rules('Name', 'Name', 'required|alpha'); $this->form_validation->set_rules('CellNo', 'CellNo', 'required|numeric'); $this->form_validation->set_rules('Address', 'Address', 'required'); $this->form_validation->set_rules('Rate', 'Rate', 'required|numeric'); $this->form_validation->set_rules('Advance', 'Advance', 'required|numeric'); $this->form_validation->set_rules('BottlesQty', 'BottlesQty', 'required|numeric'); $this->form_validation->set_rules('DeliveryDay', 'DeliveryDay', 'required'); $this->form_validation->set_rules('DeliveryPerson', 'DeliveryPerson', 'required'); $this->form_validation->set_rules('referenceName', 'referenceName', 'required'); if ($this->form_validation->run() == FALSE) { $errors = validation_errors(); echo json_encode(['error'=>$errors]);} } Here is view with ajax <div id="print-error-msg" class="alert alert-danger " style="display:none"></div> //part of ajax posting to controller var formData = new FormData($('#form')[0]); $.ajax({ url : url, type: "POST", data: formData, …

+0 forum 0
Member Avatar

Greetings to everyone, I am working as a freelance web developer, i have more than 4 years experience in osclass scripts. I am working in the osclass scripts for the past 4 years and have created nearly 67 sites in osclass, and have created many plugins, cuztomized themes, plugin cuztomizations according to the clients need. I saw many of the post was unanswered here regarding the osclass scripts, so i make this new topic those who are wandering for a good programmer for their osclass script, reply me here if you need my support, thanks.

+0 forum 0
Member Avatar

> this is php code for get value while ($row = $activeRiders->fetch(PDO::FETCH_ASSOC)){ $rider_name = $row['RiderName']; $longitude = $row['CurrentLongitude']; $latitude = $row['CurrentLatitude']; $locations[]=array( $rider_name, $latitude, $longitude ); } $markers = json_encode( $locations ); > Jquery function $(document).ready(function() { $('#map').height($('.page-container').height()); $( window ).resize(function() { $('#map').height($('.page-container').height()); }); <?php echo "var markers=$markers;\n"; ?> > Initialize Map map = new GMaps({ el: '#map', lat: 24.8615, lng: 67.0099, zoom: 12, zoomControl : true, zoomControlOpt: { style : 'SMALL', position: 'TOP_LEFT' }, circleOptions: { fillColor: '#ffff00', fillOpacity: 1, strokeWeight: 5, clickable: false, editable: true, zIndex: 1 }, panControl : false, streetViewControl : false, mapTypeControl: false, overviewMapControl: false, …

+0 forum 0
Member Avatar

Hi Dynamic Dependent Select Box last one not working Bank,State,District is working branch ont working please check below code Please help. index.php <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style type="text/css"> .select-boxes{width: 280px;text-align: center;} select { background-color: #F5F5F5; border: 1px double #FB4314; color: #55BB91; font-family: Georgia; font-weight: bold; font-size: 14px; height: 39px; padding: 7px 8px; width: 250px; outline: none; margin: 10px 0 10px 0; } select option{ font-family: Georgia; font-size: 14px; } </style> <script src="jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#country').on('change',function(){ var countryID = $(this).val(); if(countryID){ $.ajax({ type:'POST', url:'ajaxData.php', data:'country_id='+countryID, success:function(html){ $('#state').html(html); $('#city').html('<option value="">Select District</option>'); } }); }else{ $('#state').html('<option value="">Select Bank</option>'); $('#city').html('<option value="">Select State</option>'); …

+0 forum 0
Member Avatar

Hello, I'm having trouble posting JSON to a url using Flask, AJAX and Javascript. Essentially, I would code using a library [Jquery Sortable](https://johnny.github.io/jquery-sortable/) to create a sorted list. From that sorted list I want to post to the server. The problem is that the server does not recieve the JSON post at all (or rather it doesn't know the content type). Now I've experimetned with multipe methods and it has led me to this issue of not posting. The information is posted below: {% extends "base.html" %} {%block title %}{{Title_Program}}{%endblock%} {% block styles %} {{super()}} <!-- In <head> --> <style …

+0 forum 0
Member Avatar

How can I get my current content to slide to the left and bring in new content from the right (after clicking on button 1) when an existing student's username and password are correct, and if it's not correct display error messages that either the username or password isn't correct below each respective textbox .I am thinking about using an if/else condition. Also, how would I load the student's existing account information upon sliding it from the right, if I haven't created the content yet? If I already created the content to be slide in from the right, where do …

+0 forum 0
Member Avatar

Hi, Currently, I am stuck with this problem whereby I do not know how to make my text disappear with a click of radio button event. To start with, the data is being drawn out using Store Procedure and the data appeared inside the textboxes when user selected a item in a dropdownlist. But, I need to make the text go away if user decided to press on a radio button say Yes. Any tips on how to do this kind of code would be most appreciated. Tks.

+0 forum 0
Member Avatar

I need to validate a name field to validate if the name field is empty and if the name existed in my database. If it passes both the validation(the user has input a name that is not existed in my database), then the form will be submitted. The problem is with my validation of name existed in my database. I used ajax and even though I used e.preventDefault() to stop the form from submitting if the name existed in the success block, it just pops up an alert "name existed" and proceed to submit the form. Please help. index.jsp <%@ …

+0 forum 0
Member Avatar

/* initialize the calendar -----------------------------------------------------------------*/ var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); /* selects the events to load in the calendar -----------------------------------------------------------------*/ $.ajax({ url: 'process.php', type: 'POST', data: 'type=fetch', async: false, success: function(response){ json_events = response; } }); $('#calendar').fullCalendar({ //events: [{"id":"14","title":"New Event","start":"2015-01-24T16:00:00+04:00","allDay":false}], events: JSON.parse(json_events), utc: true, defaultView: 'agendaWeek', header: { left: 'prev,next today', center: 'title', right: 'month,agendaWeek,agendaDay' }, editable: true, droppable: true, slotDuration: '00:30:00', timezone: 'local', eventReceive: function(event){ var title = event.title; var start = event.start.format("YYYY-MM-DD[T]HH:mm:SS"); $.ajax({ url: 'process.php', data: 'type=new&title='+title+'&startdate='+start+'&zone='+zone, type: 'POST', dataType: 'json', success: function(response){ event.id = response.eventid; …

+0 forum 0
Member Avatar

I got two dropdowns in each product in my cart. When i select my both option my class on success is not updating the cost. It only updates when i refresh the page, i dont want to refresh my page to get the cost. this is my script... $(document).ready(function() { $('.fabric, .size').on('change', sendData); function sendData() { var id = $(this).data("id"); var fabricID = $('.fabric[data-id=' + id +']').val(); var sizeID = $('.size[data-id=' + id +']').val(); if ( fabricID !== "" && sizeID !== "") { $.ajax({ type : 'GET', url : 'calculates.php', dataType : 'json', data : { prod_id:id, fabric_id: fabricID, …

+0 forum 0
Member Avatar

Guys i'm trying to get data joined from two tables. I have a select options dropdowns with Fabrics names the other has sizes. I am wondering how i will make my dropdown changes the values for each fabric in each size and multiply for the amount of fabric selected. this is my fabric table, tecido is Fabrics(this table name is almofadas): [Table picture](http://i.stack.imgur.com/8ZXVg.png) This is my price table, only a part of it (this table name is valores_almofadas): [Table picture](http://i.stack.imgur.com/sr5KM.png) This is my checkout.php UI: [My UI](http://i.stack.imgur.com/6Zc0H.png) Lemme explane it better... First thing, is the user has to select a …

+0 forum 0

The End.