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

Hi This is Praveen, I am working since 8years as a FrontEnd Developer with strong Knowledge in below mentioned Skills HTML 4 HTML 5 CSS CSS 3 JavaScript jQuery Bootstrap 3 and Bootstrap 4 Angular 2 to 8 React PWA (Angular and React) Require JS KnockOutJS NodeJS Magento 2 FrontEnd

Member Avatar
+0 forum 2
Member Avatar

Hi, While I have some basic js coding skills and a few APIs uses in the past, I get stuck with one because it basically contains 3 calls. All async. Step 1 is pushing a file to the service and get back an ID in return. Step 2 is requiring a specific operation on the previously pushed file thanks to the ID Step 3 is downloading the result The fact is that I need to ensure all of these steps are individually ok before calling the next API endpoint. And exit if something went wrong. I am having hard times …

Member Avatar
+0 forum 1
Member Avatar

I want to create a price-comparison website/web application and join affliate programs.My problem is, when I want to join for a company's affliate program,seems like every company asks for my website. How can I create a price-comparison website if I am not an affliate of any company?Can I create a price-comparison site without being an affliate of any company, is it legal?In this way I will not have access to their developer api, so I can get prices using web-scraping techinuqes.I actually did it with a shopping website but although my small web app (running on local host actually) waited for 20 seconds …

Member Avatar
+0 forum 2
Member Avatar

Hi, I have to pass string entered in the input text to server method calling through jquery ajax. But its not going through. can please somebody tell me what i m doing wrong here. Below is the code: [CODE]$.ajaxSetup({ cache: false //timeout: 1000000 }); function concatObject(obj) { strArray = []; //new Array for (prop in obj) { strArray.push(prop + " value :" + obj[prop]); } return strArray.join(); } //var Eid = "stephen.gilroy1"; function testCAll() { //var ntid = $('#Eid').val(); $.ajax({ type: "POST", url: "Testing.aspx/SendMessage", //data: "{'ntid':'stephen.gilroy1'}", //working data: "{'ntid': $('#Eid').val()}", contentType: "application/json; charset=utf-8", dataType: "json", success: function(result) { alert(result.d); resultData …

Member Avatar
+0 forum 6
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

Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select again another value which is female,then how the first value(Male) will be replace by second value (Female) in the database using **PHP and Ajax**, please give me an easy solution

Member Avatar
+0 forum 2
Member Avatar

Does anyone here know MVC well enough to teach me or know of a great tutorial I can read? I'm a Senior C#, ASP.NET Web Developer at my core but since I've been under employed for a few years I have not had the chance to learn MVC. Also interested in React or similar javascript libraries as well as Boot Strap.

Member Avatar
+0 forum 4
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

Hello Guy's ! how to make a webpage load faster with a video inside the page?

Member Avatar
+0 forum 2
Member Avatar

Hello all wanted guidance on CMS(Content Management System) to be able to work with REST API for integrating REST API as needed for performing needed tasks.Kindly guide me with same

Member Avatar
+0 forum 2
Member Avatar

**hello When I push submit the page refresh. Any suggestions to stop refresh ? I'm assuming it's something to do with the submit button but I can't figure it out this is my script :** <form id="form1" class="form-horizontal" method="POST" action=""> <input type="hidden" name="action" value="ajouter_reservation" /> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="myModalLabel">Ajouter une reservation</h4> </div> <div class="modal-body"> <div class="form-group"> <label for="start" class="col-sm-2 control-label"> date debut </label> <div class="col-sm-10"> <input type="text" name="start" class="form-control" id="start" readonly> </div> </div> <div class="form-group"> <label for="end" class="col-sm-2 control-label">date fin </label> <div class="col-sm-10"> <input type="text" name="end" class="form-control" id="end" readonly> </div> </div> > <div …

Member Avatar
+0 forum 2
Member Avatar

Hi, I have a form which consists a dynamic dependent dropdown and I want to maintain the entered data into the fields after the form is saved or edited. For an example: <input type="text" name="serial" value="<?php echo $serial;?>"> Similary i need to get the value in my dropdown as well. Hope there is a solution for this. Below is my code. ## ajax.js ## $(document).ready(function() { $("#brand").change(function() { var Brand_ID = $(this).val(); if(Brand_ID != "") { $.ajax({ url:"SR.php", data:{b_id:Brand_ID}, type:'POST', success:function(response) { var resp = $.trim(response); $("#model").html(resp); } }); } else { $("#model").html("<option value=''>----Select Model----</option>"); } }); }); ## Dropdown …

Member Avatar
+0 forum 2
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

Hai Frds, My question is i have create select box using state,district,city and town.select state box click add option select box change text box add/edit in text box add tha value save in state select box. How do please help me

Member Avatar
+0 forum 1
Member Avatar

browser application to draw, print the text. in programming language typescript. in not found google source... help! Help me find I need source code

Member Avatar
+0 forum 1
Member Avatar

I'm working on site preloader. I need help to animate div width on every image load **Concept** Check every image in container is loaded. On every image load increase width of loader in percent to match **100% loader width** ( 100% of viewport) on last image load. After last image is loaded loader will be 100% of viewport & run any function suppose **function a() { }** I think more than one **.animate();** functions needed. Is any need to use `(g = parseInt(c / a.length * 100) ` to increase width **End** Script code hints (it's uncomplete I'm working on …

Member Avatar
+0 forum 2
Member Avatar

Hello everyone, I am new to this daniweb community and I really hope you guys will help me with this as I am baffled at what I couldn't come up with or was it not possible to do that? I want to have a checkbox on either PHP page or on modal like I did below to be checked, then save (submit), and stored in the mysql database so users can have ability to hide or show the product's description every time we go there without it coming back when the page refresh or whatever...Is there any possible that it …

Member Avatar
+0 forum 2
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

Need help to scroll when mouse wheel is used. Scroll Up or Down as per mouse action. I'm trying to create `moveDown()` & ` moveUp()` function, to scroll according mouse wheel action On scroll, remove class of current div :- `.active` and add class :- `.active` to scrolled div(div in viewport), by default first div has class `.active`. Following is my code structure. **HTML** <div class="wrap"> <div class="pane active"><h1>pane_1</h1></div> <div class="pane"><h1>pane_2</h1></div> <div class="pane"><h1>pane_3</h1></div> <div class="pane"><h1>pane_4</h1></div> <div class="pane"><h1>pane_5</h1></div> <div class="pane"><h1>pane_6</h1></div> </div> **CSS** .wrap { height: 100vh; width: 100vw; position: absolute; display: inline-block; margin: 0 auto; top: 0; left: 0; background: #D88C2A; …

Member Avatar
+0 forum 2
Member Avatar

I'm recently trying to upload images without page refreshing. To do that I had identify ajax. My server side programing language is php. So I tried and success with it, but it's refreshing page. So I change that code after do research. But it shows error. Please help me with this. **This is my html form and it's file name is *index.php*** <form method="post" enctype="multipart/form-data" id="formUploadFile"> <label>Select single file to upload:</label> <input type="file" name="files[]" multiple="multiple" /> <input type="submit" value="Upload File" name="btnSubmit"/> </form> **In the same *index.php* page I opened `<script></script>` tag and put following code.** <script> $(document).ready(function (e) { $('#formUploadFile').on('submit', …

Member Avatar
+0 forum 1
Member Avatar

I found some examples of custom function. By checking code of some websites I created my custom function, but I'm unable to use it. How to call & use following functions? goHome: function goHome(e) { //TimelineMax code //TweenMax code } openWork: function openWork(e) { //TimelineMax code //TweenMax code } openAbout: function openAbout(e) { //TimelineMax code //TweenMax code } goToProjects: function goToProjects() { //TimelineMax code //TweenMax code }

Member Avatar
+0 forum 1

The End.