把sql读取的数据用echarts显示出来_course

用echarts制作的地图，各省份有不同的数据要显示，数据是在sql数据库中读取的

如何完成从数据库中取值，后在网页中根据数据绘制动态折线图？_course

因为这是一个健康管理的系统，需要根据用户选择的日期范围，获取不定条数的数据，然后根据数据，日期在前端绘制成折线图。 我现在是用的springmvc框架，绘制折线图用的是ichart.js，因为需要在J

php数据库到javascript图表_course

<div class="post-text" itemprop="text"> <p>How to replace my javascript datapoints to my mysql database? My array x and y ??? i have trouble in plotting my mysql database...</p> <p>ex.</p> <pre><code>array("x" =&gt;(HERE), "y" =&gt;HERE), by database $row['year']; &lt;?php $dataPoints = array( array("x" =&gt; 946665000000, "y" =&gt; 40), array("x" =&gt; 978287400000, "y" =&gt; 20), array("x" =&gt; 1009823400000, "y" =&gt; 100), array("x" =&gt; 1041359400000, "y" =&gt; 300), array("x" =&gt; 1072895400000, "y" =&gt; 500), array("x" =&gt; 1104517800000, "y" =&gt; 500), array("x" =&gt; 1136053800000, "y" =&gt; 400), array("x" =&gt; 1167589800000, "y" =&gt; 400), ); ?&gt; &lt;div id="chartContainer" style="height: 370px; width: 100%;"&gt;&lt;/div&gt; &lt;script&gt; window.onload = function () { var chart1 = new CanvasJS.Chart("chartContainer", { animationEnabled: true, title:{ text: "Number of Enrollees by Year" }, axisY: { title: "Students in numbers", valueFormatString: "#", suffix: "", prefix: "" }, data: [{ type: "spline", markerSize: 5, xValueFormatString: "YYYY", yValueFormatString: "##0. Enrolees", xValueType: "dateTime", dataPoints: &lt;?php echo json_encode($dataPoints, JSON_NUMERIC_CHECK); ?&gt; }] }); chart1.render(); } &lt;/script&gt; </code></pre> <blockquote> <p>Its just a template from chartjs.com</p> <p>Please help me guys form database php to javascript...</p> </blockquote> </div>

用JavaScript调用mysql数据库查询_course

<div class="post-text" itemprop="text"> <p>I am trying to query a database but I don't want it to do it when the page loads. I want it to query during execution of a javascript function. How do I do this? Below is my code. I have tried just adding php tags in the middle of the function and calling <em>loadAvailableReservations()</em> but it returns with an error even when I close the script tags. </p> <pre><code>&lt;?php $servername = "localhost"; $username = "root"; $password = "root"; $dbname = "fbla"; function loadAvailableReservations() { $conn = new mysqli($servername, $username, $password, $dbname); if ($conn-&gt;connect_error) { die("Connection failed: " . $conn-&gt;connect_error); } $sql = "SELECT id, name, date FROM availableReservations"; $result = $conn-&gt;query($sql); if ($result-&gt;num_rows &gt; 0) { // output data of each row while($row = $result-&gt;fetch_assoc()) { echo "&lt;br&gt; id: ". $row["id"]. " - Name: ". $row["name"]. " " . $row["date"] . "&lt;br&gt;"; } } else { echo "0 results"; } $conn-&gt;close(); } ?&gt; &lt;html&gt; &lt;/head&gt; &lt;meta name="viewport" content="width=device-width"&gt; &lt;script src="http://code.jquery.com/jquery-1.7.js"&gt;&lt;/script&gt; &lt;link rel="stylesheet" media='screen and (min-width: 0px) and (max-width: 298px)' href="css/unsuported.css" /&gt; &lt;link rel="stylesheet" media='screen and (min-width: 298px) and (max-width: 552px)' href="css/small.css" /&gt; &lt;link rel='stylesheet' media='screen and (min-width: 552px) and (max-width: 806px)' href='css/medium.css' /&gt; &lt;link rel='stylesheet' media='screen and (min-width: 806px) and (max-width: 9999999px)' href='css/regular.css' /&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="header-div"&gt; &lt;a href="index.html" id="header-div-a-regular"&gt;Mountain Springs Family Entertainment Center&lt;/a&gt; &lt;a href="index.html" id="header-div-a-small"&gt;Mountain Springs FEC&lt;/a&gt; &lt;div id="header-div-menubutton"&gt; &lt;hr id="hr-1"&gt; &lt;hr id="hr-2"&gt; &lt;hr id="hr-3"&gt; &lt;/div&gt; &lt;ul&gt; &lt;li&gt;&lt;a href="#specials/events" onclick="return specialsEventsAppend()"&gt;Specials/Events&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="#bookit" onclick="return bookitAppend()"&gt;Book it!&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="#schedule" onclick="return scheduleAppend()"&gt;Schedule&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;/div&gt; &lt;div id="mobileMenu-div" style="display:none"&gt; &lt;center&gt; &lt;ul id="mobileMenuUl"&gt; &lt;li id="ulfirstli"&gt;&lt;a href="#about" onclick="return specialsEventsAppend()"&gt;Specials/Events&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="#bookit" onclick="return bookitAppend()"&gt;Book it!&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="#schedule" onclick="return scheduleAppend()"&gt;Schedule&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;/center&gt; &lt;/div&gt; &lt;div id="maincontent-div"&gt; &lt;p id="unsuported-p"&gt;Sorry but this screen resolution is unsuported :/&lt;p&gt; &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; &lt;script&gt; jQuery(document).ready(function() { $('#header-div-menubutton').live('click', function(event) { toggleMobileMenuDiv(); }); function toggleMobileMenuDiv() { $('#mobileMenu-div').slideToggle("fast"); } }); function mobileMenu() { var div = document.getElementById('mobileMenu-div'); } function specialsEventsAppend() { var div = document.getElementById('maincontent-div'); //clears everything in the div div.innerHTML = ""; //puts the content into the div div.innerHTML = div.innerHTML + 'Extra stuff'; } function bookitAppend() { var div = document.getElementById('maincontent-div'); div.innerHTML = ""; div.innerHTML = div.innerHTML + '&lt;center&gt;&lt;div id="bookit-div"&gt;&lt;p&gt; January 20&lt;sup&gt;th&lt;sup&gt;&lt;div id="bookit-list"&gt;&lt;/div&gt;&lt;/div&gt;&lt;center&gt;&lt;center&gt;&lt;div id="bookit-div"&gt;&lt;p&gt; January 21&lt;sup&gt;st&lt;sup&gt;&lt;div id="bookit-list"&gt;&lt;/div&gt;&lt;/div&gt;&lt;center&gt;&lt;center&gt;&lt;div id="bookit-div"&gt;&lt;p&gt; January 22&lt;sup&gt;nd&lt;sup&gt;&lt;div id="bookit-list"&gt;&lt;/div&gt;&lt;/div&gt;&lt;center&gt;&lt;center&gt;&lt;div id="bookit-div"&gt;&lt;p&gt; January 23&lt;sup&gt;rd&lt;sup&gt;&lt;div id="bookit-list"&gt;&lt;/div&gt;&lt;/div&gt;&lt;center&gt;'; } function scheduleAppend() { var div = document.getElementById('maincontent-div'); div.innerHTML = ""; div.innerHTML = div.innerHTML + '&lt;center&gt;&lt;h3&gt;Days available for reservations&lt;/h3&gt;&lt;/center&gt;&lt;center&gt;&lt;table&gt;&lt;tr&gt;&lt;th&gt;Day&lt;/th&gt;&lt;th&gt;Time&lt;/th&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Sunday&lt;/td&gt;&lt;center&gt;&lt;td&gt;Closed&lt;/td&gt;&lt;/center&gt;&lt;/tr&gt;&lt;td&gt;Monday&lt;/td&gt;&lt;center&gt;&lt;td&gt;8:00-11:00&lt;/td&gt;&lt;/center&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Tuesday&lt;/td&gt;&lt;center&gt;&lt;td&gt;8:00-11:00&lt;/td&gt;&lt;/center&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Wensday&lt;/td&gt;&lt;center&gt;&lt;td&gt;8:00-11:00&lt;/td&gt;&lt;/center&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Thursday&lt;/td&gt;&lt;center&gt;&lt;td&gt;8:00-11:00&lt;/td&gt;&lt;/cetner&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Friday&lt;/td&gt;&lt;center&gt;&lt;td&gt;10:00-11:00&lt;/td&gt;&lt;/center&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/center&gt;'; } &lt;/script&gt; </code></pre> </div>

如何在javascript中打印数据库中的数据_course

<div class="post-text" itemprop="text"> <p>i want to print date column from database in javascript code </p> <p>this is the original javascript code i want to change date countdown</p> <pre><code>&lt;script type="text/javascript"&gt; $(document).ready(function() { $('#countdown').countdown('2017/07/10 06:32:11', function(event) { $(this).html(event.strftime('%H:%M:%S')); }); }); &lt;/script&gt; </code></pre> <p>and this code after edit : </p> <pre><code>&lt;?php $count = $DB_con-&gt;prepare("SELECT * FROM `auction` WHER ORDER BY id DESC"); $count-&gt;execute(); foreach ($count-&gt;fetchAll() as $rowL) { ?&gt; &lt;script type="text/javascript"&gt; $(document).ready(function() { var countdw; countdw = = &lt;?php echo $rowL['dateauction']; ?&gt; $('#countdown').countdown(document.write(countdw), function(event) { $(this).html(event.strftime('%H:%M:%S')); }); }); &lt;/script&gt; &lt;?php } ?&gt; </code></pre> </div>

php文件与mySql数据库使用Javascript html_course

<div class="post-text" itemprop="text"> <p>So I am trying to get create a HTML that uses javascript, PHP, and CSS. I am having issues figuring out how to get the PHP that pulls in my database to post on the website with a click of a button using a javascript function. I have tried to setup jquery and ajax but I just can't seem to get it to work. Everything is connected as it should be. I have googled and googled and tried many things so figured I would post and see if someone can help me out. If I post the PHP file into my HTML it works properly but I have multiple querys that I want associated with a button. If I can just get one button to work I should be good to go. Thank you.</p> <p><strong>JS</strong></p> <pre><code>function mad_hosp(str) { if(str == 0){ document.getElementById("output").innerHTML = "Error."; return; } else { var xmlhttp = new XMLHttpRequest(); xmlhttp.onreadystatechange = function() { if (this.readyState == 4 &amp;&amp; this.status == 200) { document.getElementById("output").innerHTML = this.responseText; } }; xmlhttp.open("GET", "madison_narc.php?", true); xmlhttp.send(); } } </code></pre> <p><strong>Here are my buttons in HTML</strong></p> <pre><code>&lt;div class="navbar"&gt; &lt;a href="#home"&gt;Home&lt;/a&gt; &lt;a href="#news"&gt;News&lt;/a&gt; &lt;div class="dropdown"&gt; &lt;button class="dropbtn"&gt;Dropdown &lt;i class="fa fa-caret-down"&gt;&lt;/i&gt; &lt;/button&gt; &lt;div class="dropdown-content"&gt; &lt;button onclick="main_hosp()"&gt; &lt;a href=("#") class="button"&gt;Huntsville Hospital&lt;/a&gt; &lt;/button&gt; &lt;button onclick="W&amp;C_hosp()"&gt; &lt;a href=("#") class="button"&gt;Womens and Childrens Hospital&lt;/a&gt; &lt;/button&gt; &lt;button onclick="mad_hosp()"&gt; &lt;a href=("#") class="button"&gt;Madison Hospital&lt;/a&gt; &lt;/button&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;p&gt;Waiting for the location to be selected... &lt;id="output"&gt;&lt;/p&gt; </code></pre> <p><strong>PHP</strong></p> <pre><code> &lt;?php $sql = "SELECT currentinventoryaudit.MedId as MedID, (currentinventoryaudit.MedDescription) as MedicationDescription, sum(currentinventoryaudit.CurrentCount) as TotalOnHand, 'MadisonNarcVault' as StationName FROM currentinventoryaudit where currentinventoryaudit.StationName like ('%CW101296%') and currentinventoryaudit.MedDescription not like ('key%') and currentinventoryaudit.MedDescription not like ('%zz-%') and currentinventoryaudit.MedDescription not like ('%alp%') group by 2 order by 2 asc;"; $result = mysqli_query($conn,$sql); $resultCheck = mysqli_num_rows($result); echo "&lt;table&gt; &lt;tr&gt; &lt;th&gt;MedID&lt;/th&gt; &lt;th&gt;Medication Description&lt;/th&gt; &lt;th&gt;Total On Hand&lt;/th&gt; &lt;th&gt;Station Name&lt;/th&gt; &lt;/tr&gt;"; if($resultCheck &gt; 0) { while ($row = mysqli_fetch_assoc($result)){ echo"&lt;tr&gt;"; echo "&lt;td&gt;" . $row['MedID']."&lt;/td&gt;"; echo "&lt;td&gt;" . $row ['MedicationDescription']."&lt;/td&gt;"; echo "&lt;td&gt;" . $row ['TotalOnHand']."&lt;/td&gt;"; echo "&lt;td&gt;" . $row ['StationName']."&lt;/td&gt;"; echo "&lt;/tr&gt;"; } echo "&lt;/table&gt;"; } ?&gt; </code></pre> </div>

通过PHP从数据库输出PDF并通过Javascript显示_course

<div class="post-text" itemprop="text"> <p>I'm trying to display a PDF file that I stored in my database as a BLOB file. Although I have tried a couple of ways I still can't seem to get it right.</p> <p>Here is how I (try to) download a PDF file from my database:</p> <pre><code>function fillArrays(){ $idArray = array(); $sql = "SELECT oglas_id,slika,prioriteta FROM deska WHERE deska.datumz &lt;= CURRENT_DATE AND deska.datumk &gt;= CURRENT_DATE;"; $result = mysqli_query($GLOBALS['conn'],$sql); $resultCheck = mysqli_num_rows($result); if($resultCheck&gt;0){ while($row = mysqli_fetch_assoc($result)){ array_push($GLOBALS['idArray'],$row['oglas_id']); $b64Doc = chunk_split(base64_encode(file_get_contents($row['slika']))); // THIS LINE! $file = "data:application/pdf;base64,".$b64Doc; // THIS LINE! array_push($GLOBALS['imgArray'],$file); // THIS LINE! array_push($GLOBALS['prArray'],$row['prioriteta']); } }else{ die("Oops there seems to be an error(arr)"); } } </code></pre> <p>The code I've marked "THIS LINE!" should put all my PDF files from the database into an array of PDF files called <code>$imgArray</code>. Then I <code>json_encode</code> the array and assign it to the <code>imgArray</code> variable in JavaScript:</p> <pre><code>var imgArray = &lt;?php echo json_encode($imgArray) ?&gt;; </code></pre> <p>And finally, I try to display the same PDF file 4 times in a table created via JavaScript. (I call <code>createTable()</code> in main PHP file):</p> <pre><code>var idArray = window.idArray; var imgArray = window.imgArray; var prArray = window.prArray; var screenH = screen.height/2.1; var screenW = screen.width/2.1; var tdW; var tdH; function createTables(){ if(idArray.length&gt;2){ rows=2; cols=2; tdW='100%'; tdH='100%'; }else if(idArray.length==2){ rows=1; cols=2; tdW='100%'; tdH='100%'; }else if(idArray.length==1){ tdW='100%'; tdH='100%'; } var table = ''; for(var r=0;r&lt;rows;r++){ table += '&lt;tr&gt;'; for(var c=0;c&lt;cols;c++){ table += '&lt;td style="max-width:'+tdW+';max-height:'+tdH+';" id="c'+c+r+'"&gt;'; table += '&lt;embed src="'+imgArray[1]+'" type="application/pdf" style="max-height:'+screenH+';max-width:'+screenW+';"&gt;'; table += '&lt;/td&gt;'; } table += '&lt;/tr&gt;'; } document.write("&lt;table&gt;"+table+"&lt;/table&gt;"); } </code></pre> <p>See at the bottom of the code where I try to embed the pdf file. Output on the site is this:</p> <p><a href="https://i.stack.imgur.com/B7tCJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/B7tCJ.png" alt="enter image description here"></a></p> <p>The language is Slovene and it says that the PDF file is corrupted.</p> </div>

基于Javascript函数值，通过PHP检索数据库数据_course

<div class="post-text" itemprop="text"> <p>I am getting a place name to this file using GET. Then I am converting the place name into latitude and longitude.</p> <p>I want to display some data from the database, based on the latitude and longitude, but I am unable to send the latitude and longitude variables from JS to PHP.</p> <p>I also tried Ajax, but that also didn't work, because PHP loads before the script. Correct me if I am wrong.</p> <p>Any kind of help will be appreciated.</p> <pre><code>&lt;?php $user_latitude $user_longitude $result=$con-&gt;query("SELECT *, ( 6371 * acos( cos( radians($user_latitude) ) * cos( radians( lat ) ) * cos( radians( lon ) - radians($user_longitude) ) + sin( radians($user_latitude) ) * sin( radians( lat ) ) ) ) AS distance FROM Location HAVING distance &lt; 100 ORDER BY distance LIMIT 0 , 10"); for($x=0;$x&lt;$result-&gt;num_rows;$x++){ $row=$result-&gt;fetch_assoc(); echo "&lt;div class='result-data'&gt;"; echo $row["name"]; echo "&lt;/div&gt;"; } ?&gt; &lt;script&gt; $(function() { geocoder = new google.maps.Geocoder(); alert($_GET('location')); var address = $_GET('location'); address=address+',Delhi,India'; alert(address); geocoder.geocode( { 'address': address}, function(results, status) { if (status == google.maps.GeocoderStatus.OK) { latitude=results[0].geometry.location.lat(); longituderesults[0].geometry.location.lng(); alert("Latitude: "+results[0].geometry.location.lat()+latitude); alert("Longitude: "+results[0].geometry.location.lng()+longitude); } else { alert("Geocode was not successful for the following reason: " + status); } }); }); function $_GET(param) { var vars = {}; window.location.href.replace( /[?&amp;]+([^=&amp;]+)=?([^&amp;]*)?/gi, // regexp function( m, key, value ) { // callback vars[key] = value !== undefined ? value : ''; } ); if (param) { return vars[param] ? vars[param] : null; } return vars; } &lt;/script&gt; </code></pre> </div>

在javascript函数中对数据库执行php插入_course

<div class="post-text" itemprop="text"> <p>I'm having a page <strong>home.php</strong> which has a button '<strong>UPDATE</strong>'.<br> 1. <em>onclick</em> function of '<strong>UPDATE</strong>' should call a javascript function '<strong>write()</strong>'.<br> 2. 'write()' function get's the username and a value - both from the session (php comes in use here) and write it to a database.</p> <p>Here is the code : <strong>home.php</strong></p> <pre><code>&lt;html&gt; &lt;head&gt; &lt;title&gt; Sample Page &lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;script&gt; function write(){ &lt;?php include("dbConnect.php"); // connection works perfectly with other php files // gets 'latestValue' from session variable // gets 'username' from session variable // updates 'patients' table with the latestValue, against the username $query = "UPDATE patients SET lastLDNId = '$_SESSION[latestValue]' WHERE username='$_SESSION[username]'"; $result = mysqli_query($con, $query); ?&gt; } &lt;/script&gt; &lt;input type="button" onclick="write()" value="UPDATE"&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>When i run the code and checking by Inspecting element, I'm getting the following error in the function write(), as the browser interprets it</p> <pre><code>function writeLDN(lDNId){ &lt;br /&gt; &lt;b&gt;Notice&lt;/b&gt;: Undefined index: latestValue in &lt;b&gt;C:\xampp\htdocs\MedPhil\home.php&lt;/b&gt; on line &lt;b&gt;98&lt;/b&gt;&lt;br /&gt; } </code></pre> <p>When i remove the php part inside the javascript function, the above error is not generated, which means it's not possible to use php in the way I've used.</p> <p>Can anyone give me a solution other than echoing the whole script content using php?</p> <p>Thanks in advance</p> </div>

通过调用PHP脚本从Javascript更新数据库_course

<div class="post-text" itemprop="text"> <p>Ive been trying to get this for age</p> <p>I am building a website which has an activity wall. I have the whole thing working except the like and unlike buttons. I have them currently just showing a text box I like or I don't like</p> <pre><code>&lt;a href='#' onclick='like()'&gt;Like&lt;/a&gt; </code></pre> <p>or</p> <pre><code>&lt;a href='#' onclick='unlike()'&gt;Unlike&lt;/a&gt; </code></pre> <p>Now these call these scripts</p> <pre><code>&lt;script&gt; function like() { alert("I like"); document.getElementById("p1").innerHTML="&lt;a href='#' onclick='unlike();'&gt;Unlike&lt;/a&gt; | 1 Life&lt;hr/&gt;"; } function unlike() { alert("Dont like anymore"); document.getElementById("p1").innerHTML="&lt;a href='#' onclick='like();'&gt;Like&lt;/a&gt; | 0 Lifes&lt;hr/&gt;"; } &lt;/script&gt; </code></pre> <p>I have a php script that connects to the database and adds or removes the like which I know works. I don't need to return anything to the javascript but how do I call that php script giving the postID and username??</p> <hr> <p>Ok so using this I have modified it a little. But it still doesnt work :S</p> <p>==LikeUnlink.php==</p> <pre><code>&lt;?php include 'phpScripts/OpenConnection.php'; $mode = $_GET['mode']; $username = $_GET['username']; $postID = $_GET['LikeID']; echo $username."&lt;br/&gt;"; echo $mode."&lt;br/&gt;"; echo $postID."&lt;br/&gt;"; if($mode == 0) { $query = "INSERT INTO tbl1Ups (Username, ActivityID) VALUES ('$username', $postID)"; } else { $query = "DELETE FROM `tbl1Ups` WHERE Username='$username' AND ActivityID=$postID"; } $result = mysql_query($query) or die(mysql_error()); </code></pre> <p>==MembersHome.php==</p> <pre><code>&lt;script type="text/javascript"&gt; function process(LikeId, Username, currentLikes, likeUnlike) { //your validation code $.ajax( { type: 'GET', url: LikeUnlike.php, //file where like unlike status change in database data:{like:LikeId, username:Username, mode:likeUnlike}, success: function(data) { alert('It Works'); } } ); } &lt;/script&gt; </code></pre> <p>==Like link==</p> <pre><code>&lt;a href='Javascript:void(0)' onclick='process(".$row['ID'].", \"".$username."\", ".$likes.", 0);'&gt;$linkText&lt;/a&gt; </code></pre> </div>

Javascript倒数与数据库输入_course

<div class="post-text" itemprop="text"> <pre><code>sset($_POST["confirm"])) { $check="select * from tbl_donate where receiverId='$username' and status = 'created'"; $exc=mysqli_query($conn,$check); $match=mysqli_fetch_array($exc); $cElapseTime=$match['cElapseTime']; $timeCreated=$match['timeCreated']; $receiverId=$match['receiverId']; $senderId=$match['senderId']; $pop = $match['proof']; $projectId = $match['projectId']; $actlAmt = $match['amtRec']; //$errMsg = $projectId; $now=date("Y-m-d h:i:s"); $t1 = strtotime($timeCreated); $t2 = strtotime($cElapseTime); $t3 = strtotime($now); $diff = $t2 - $t3; $hours = gmdate("H:i:s", $diff); </code></pre> <p>i want to pass this as a count down to a javascript, and also after the countdown is zero, it should automatically stops the countdown and reload the page and update a column in the database.</p> <p>i need help on this</p> </div>

php连接数据库传值给js_course

然后在页面上展示出来，刚出来实习的一个小菜鸟，很多东西都不是太会，希望各位大神多帮帮忙，感激不尽！

SQL数据库到php网站用javascript_course

<div class="post-text" itemprop="text"> <p>I seem to be stuck on a concept in database query and website development.</p> <p>I have a website that will reflect what data is stored in a database and the website needs to change depending on that data: therefore, my menu system will not be hardcoded in. It builds my menu system based off a query of all the models in my database. The action of clicking on the menu will show tables without changing the page (a simple javascript "showtables" function). like so:</p> <pre><code> function showTables(TABLE_NAME) { if(TABLE_NAME != "PRINTER_TABLE") { document.getElementById("PRINTER_TABLE").style.display ="none"; } if(TABLE_NAME != "show_ALL_PRINTERS") { document.getElementById("show_ALL_PRINTERS").style.display ="none"; } document.getElementById(TABLE_NAME).style.display ="block"; } </code></pre> <p>I did not include all of my other if statements because there are about 15 of them. These statements will hide everything and the only show the formatted table of "TABLE_NAME" at the end of that script. </p> <p>My problem is that, if all of the data will not be hardcoded in either HTML or PHP, I need to pass into my function "showTables" a model type or ID that will come from my query. </p> <p>My Menu system code snipet: </p> <pre><code> &lt;li class="hasmore"&gt;&lt;a href="#" onClick="showTables('show_ALL_PRINTERS')"&gt;&lt;span&gt;Printer Parts&lt;/span&gt;&lt;/a&gt; &lt;ul class="dropdown"&gt; &lt;?php include 'connection.php'; $query = "SELECT * FROM all_printers"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { #echo "&lt;h3&gt;" . $row['printer_model'] . "&lt;/h3&gt;"; echo "&lt;li&gt;&lt;a href=\"#\" onclick=\"showTables('PRINTER_TABLE'")\"&gt;" .$row['printer_model']."&lt;/a&gt;&lt;/li&gt; "; } ?&gt; </code></pre> <p>This puts the model into the menu system and the "PRINTER_TABLE" will access my showTables function, which then will show that table. But there are many different printer models and I need to tell my table query what specific model to get info on.</p> <p>I hope this makes sense as there is a lot of logic behind it. Maybe there is an easier way..?</p> <p>In my tables I have:</p> <pre><code> &lt;table id="table"&gt; &lt;thead&gt; &lt;tr&gt; &lt;th scope="col" id="table"&gt;Type&lt;/th&gt; &lt;th scope="col" id="table"&gt;Size&lt;/th&gt; &lt;th scope="col" id="table"&gt;S/N&lt;/th&gt; &lt;th scope="col" id="table"&gt;Model&lt;/th&gt; &lt;th scope="col" id="table"&gt;Connection Type&lt;/th&gt; &lt;th scope="col" id="table"&gt;Surplus&lt;/th&gt; &lt;th scope="col" id="table"&gt;Amount&lt;/th&gt; &lt;/tr&gt; &lt;/thead&gt; &lt;tbody&gt; &lt;?php include 'connection.php'; $query_misc = "SELECT * FROM all_parts WHERE part_type='MISC'"; $result_misc = mysql_query($query_misc); while($row = mysql_fetch_array($result_misc)) { echo "&lt;tr&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_type']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_size']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_sn']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_model']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_connection']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_surplus']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;td&gt;&lt;div align=\"center\"&gt;".$row['part_temp_amount']."/".$row['part_amount']."&lt;/div&gt;&lt;/td&gt;"; echo "&lt;/tr&gt;"; } </code></pre> <p>..... etc</p> <p>Any ideas?</p> <p>EDIT:</p> <p>I do now know how to put what I click on, into the url properly..</p> <pre><code> &lt;? $query = 'SELECT printer_id, printer_model FROM printer_table WHERE 1 ORDER BY name'; $products = mysql_query($query); while ($product = mysql_fetch_assoc($products)) : { echo "&lt;li&gt;&lt;a href=\"inventory_admin.php?product_id='".$product['printer_id']."'\" onclick=\"toggleVisibility('".$product['printer_model']."')\"&gt;" .$product['printer_model']."&lt;/a&gt;&lt;/li&gt; "; } ?&gt; </code></pre> <p>or</p> <pre><code> &lt;li&gt;&lt;a href="inventory_admin.php?product_id=&lt;?=$product['printer_id']?&gt;" onclick="toggleVisibility('&lt;?=$product['printer_model']?&gt;')"&gt;&lt;?=$product['printer_model']?&gt;&lt;/a&gt;&lt;/li&gt; </code></pre> <p>doesnt work properly, because i need to call the suggested part list php part, but do not know where to do so..</p> <p>EDIT:</p> <p>I placed that php within a div and the echos will fill out my table, but how am I suppose to call that div to only run when that onclick action? I know that is not how divs work, It would seem I would need a JS function but I know you cannot do php within JS. AJAX perhaps?</p> <p><strong>EDIT----------------------------------------------------</strong></p> <p>The call here to the DB is correct, tested it manually without any errors, but I am still receiving a syntax error upon loading my home page. Here is my call to the DB via PHP...</p> <pre><code> &lt;? if (!isset($_GET['action'])) { //If not isset -&gt; set with dumy value $_GET['action'] = "undefine"; } include 'connection.php'; $query = 'SELECT ppart_table.* FROM ppart_table LEFT JOIN printer_part_relation ON ppart_table.part_id = printer_part_relation.part_id WHERE printer_part_relation.printer_id ='.mysql_real_escape_string($_GET['printer_id']); $parts = mysql_query($query) or die("Query failed with error: ".mysql_error()); while ($row = mysql_fetch_assoc($parts)) { echo table blah blah } ?&gt; </code></pre> <p>I have tried supressing all errors via this:</p> <pre><code> &lt;?php error_reporting (E_ALL ^ E_NOTICE); ?&gt; </code></pre> <p>And the syntax error at page load still exist. </p> <p>My home page of this site does NOT have the "product_id=" after mysite.php</p> </div>

按钮Onclick调用Javascript调用PHP文件，该文件添加到Mysql数据库_course

<div class="post-text" itemprop="text"> <p>I need help with adding to a database. I want to call a javascript scrt from a button click method. The Javascript Script, I want to call upon a php file which contains some code that adds to a MySQL Database.</p> <p>I literally tried over 20+ website and No help with the stuff.</p> <p>If AJAX would be better Could you help me?</p> <p>The Button Code:</p> <pre><code>&lt;input type="button" value="favorites1" onClick="favfunct();"&gt; </code></pre> <p>The Javascript Code</p> <pre><code>function favfunct() { var target = document.createElement( "script" ); target.setAttribute( "src", "php/addtofavorites.php" ); document.getElementsByTagName( "body" )[0].appendChild( target );` } </code></pre> <p>The Php Code</p> <pre><code>&lt;?php echo "test successful" $con = mysql_connect("localhost","root","student"); if ($_POST["get"] == 'runfunction') echo "Works"; } if ($_POST["action"] == 'favorites1'){ echo "Testing Was Successful" if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("tvid", $con); $sql="INSERT INTO Persons (userid, davorites) VALUES ('1','$_POST[video0]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "Your Video was Added To Your Favorites"; mysql_close($con) } ?&gt; </code></pre> </div>

使用Javascript中的Javascript数据库中的数据_course

<div class="post-text" itemprop="text"> <p>I'd like to show some data of my database with Javascript. Here's my PHP script:</p> <pre><code>$arrayDatabase = array(); $statement = $link-&gt;prepare("SELECT project.ID, project.titel, project.subtitel, project.plaatje, project.beschrijving, project.link FROM project" ); $statement-&gt;execute(); $statement-&gt;bind_result($ID, $titel, $subtitel, $plaatje, $beschrijving, $site); while($statement-&gt;fetch()){ echo ' &lt;div class="singleProject" id="'.$ID.'"&gt; &lt;img src="'.$plaatje.'" alt="'.$titel.'" /&gt; &lt;div&gt; &lt;h2&gt;'.$titel.'&lt;/h2&gt; &lt;div&gt;&lt;p&gt;'.$subtitel.'&lt;/p&gt;&lt;/div&gt; &lt;/div&gt; &lt;/div&gt; '; $arrayRij= array($ID, $beschrijving, $site); array_push($arrayDatabase, $arrayRij); } $statement-&gt;close(); </code></pre> <p>But if I use json_encode to get the array to Javascript, it won't work.</p> <pre><code>var jsArray = &lt;? echo json_encode($arrayDatabase); ?&gt;; </code></pre> <p>EDIT: In my browser there is only a ';' after var jsArray = </p> <p>The weird thing is. If a use a multidimensional array on my own like:</p> <pre><code>$phpArray = array(array("foo", "bar"), array("foo", "bar")); </code></pre> <p>My script works.</p> </div>

通过PHP验证JavaScript后，将表单数据发送到mySQL数据库_course

<div class="post-text" itemprop="text"> <p>I have an html form used as a subscription form. The form is sent via POST method to PHP file for processing and database entry. Form validation is done via JavaScript. </p> <p>I don't want to redirect to the PHP file and I want to keep my form styling. That is, when the user clicks on the SUBMIT button the form animates and displays a Success message on-page without reloading or sending to the php file.</p> <p>I have tested the PHP file alone and it works fine, writing as expected in mySQL database table. The JavaScript validation file also works great on its own. The problem is that when the Submit button is clicked, after all required fields are valid, the form animates as if data is sent successfully, but no data gets written into my database. I tried inserting AJAX in different formats at different place in the JavaScript code but nothing worked. </p> <p>The JS Validation file is linked to via in the HTML file. And the PHP file is linked to via the Form Action="" attribute.</p> <p>When I use the following script in the HTML alongside the link to form.js :</p> <pre><code> &lt;script type="text/javascript"&gt; $("#submitBtn").click(function() { var dataString = $('#register').serialize(); $.ajax({ type: "POST", url: "contact/validate.php", data: dataString }); }); &lt;/script&gt; </code></pre> <p>It actually works - the form animates as intended, there is no redirect to the PHP file and form data gets written into the database, but this makes dublicate entries and also allows non-valid entries to be written into the database, despite the JavaScript-initiated error messages on the input fields.</p> <p><strong>Here is my HTML Form:</strong> </p> <pre><code> &lt;div id="contactForm" class="contactForm"&gt; &lt;div id="formHeader" class="formHeader"&gt; &lt;h2 id="message"&gt;Форма за регистрация&lt;/h2&gt; &lt;/div&gt; &lt;div id="formBody" class="formBody"&gt; &lt;form action="contact/validate.php" method="POST" name="contactForm" id="register"&gt; &lt;div class="row"&gt; &lt;div class="inputContainer hlf"&gt; &lt;input name="fullname" id="fullname" type="text" placeholder="Вашето име" minlength="2" maxlength="40" required tabindex="1"&gt; &lt;/div&gt; &lt;div class="inputContainer hlf"&gt; &lt;input name="location" id="location" type="text" placeholder="Населено място" minlength="5" maxlength="40" required tabindex="2"&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="row"&gt; &lt;div class="inputContainer hlf"&gt; &lt;input name="email" id="email" type="email" placeholder="Ваш имейл за контакт" maxlength="75" required tabindex="3"&gt; &lt;/div&gt; &lt;div class="inputContainer hlf"&gt; &lt;input name="phone" id="phone" type="tel" placeholder="Телефон" pattern="[0-9 ]" maxlength="15" tabindex="4"&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="row"&gt; &lt;div class="inputContainer"&gt; &lt;textarea name="comment" id="comment" rows="4" placeholder="Допълнителен коментар" minlength="5" maxlength="250" tabindex="5"&gt;&lt;/textarea&gt; &lt;/div&gt;&lt;/div&gt; &lt;input id="submitBtn" class="submitBtn" type="submit" value="Изпрати"&gt; &lt;/form&gt; &lt;/div&gt; </code></pre> <p> </p> <p><strong>Here is my PHP File:</strong> </p> <pre><code>&lt;?php //Clean form data from backslashes and evil tags //define variables and set to empty values $fullname = $location = $email = $phone = $comment = ""; if ($_SERVER["REQUEST_METHOD"] == "POST") { $fullname = test_input($_POST["fullname"]); $location = test_input($_POST["location"]); $email = test_input($_POST["email"]); $phone = test_input($_POST["phone"]); $comment = test_input($_POST["comment"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } //All input is tested and validated, now connect to DB and send data to the mySQL database table: $servername = "localhost"; $username = "usename"; $password = "password"; $dbname = "database name"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn-&gt;connect_error) { die("Connection failed: " . $conn-&gt;connect_error); } $sql = "INSERT INTO subscribed (fullname, location, email, phone, comment) VALUES ('$fullname', '$location', '$email', '$phone', '$comment')"; if ($conn-&gt;query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "&lt;br&gt;" . $conn-&gt;error; } $conn-&gt;close(); </code></pre> <p><strong>Finally, here is my JavaScript validation file:</strong> </p> <pre><code>$(function() { "use strict"; var //GLOBAL VARIABLES input, container, //CSS CLASSES classSuccess = "success", classError = "error", //FORM VALIDATOR formValidator = { init: function() { this.cacheDom(); this.bindEvents(); }, cacheDom: function() { //MAIN PARENT ELEMENT this.contactForm = document.getElementById("contactForm"); //MAIN FORM ELEMENTS this.formHeader = document.querySelector("#formHeader h2"); this.formBody = document.getElementById("formBody"); this.inputContainer = document.getElementsByClassName("inputContainer"); //USER INPUT ELEMENTS //INPUT FIELDS this.fields = { fullname: document.getElementById("fullname"), location: document.getElementById("location"), email: document.getElementById("email") }; this.submitBtn = document.getElementById("submitBtn"); }, bindEvents: function() { var i; //RUN RULES ON SUBMIT BUTTON CLICK this.submitBtn.onclick = this.runRules.bind(this); //BIND EVENTS TO EACH INPUT FIELD for (i in this.fields) { if (this.fields.hasOwnProperty(i)) { //VARIABLES input = this.fields[i]; container = input.parentElement; //RUN RULES WHEN INPUT HAS FOCUS input.onfocus = this.runRules.bind(this); //RESET ERRORS WHEN CONTAINER IS CLICKED container.onclick = this.resetErrors.bind(this, input); } } }, runRules: function(evnt) { var target = evnt.target, type = evnt.type; //IF EVENT ON SUBMIT BUTTON if (target === this.submitBtn) { //PREVENT FORM SUBMITTION this.preventDefault(evnt); //IF INPUT HAS FOCUS } else if (type === "focus") { //RESET CLASSLIST this.resetClassList(target.parentElement); //RESET ERRORS this.resetErrors(target); return false; } //RESET CLASSLIST this.resetClassList(); //CHECK FIELDS this.checkFields(); }, preventDefault: function(evnt) { //PREVENT DEFUALT evnt.preventDefault(); }, checkFields: function() { var i, validCount = 0, //EMAIL FILTER filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/; //CYLCE THROUGH INPUTS for (i in this.fields) { if (this.fields.hasOwnProperty(i)) { input = this.fields[i]; //CHECK IF FIELD IS EMPTY if (input.value === "") { //ADD ERROR CLASS this.addClass(input, classError); //CHECK IF EMAIL IS VALID } else if (i === "email" &amp;&amp; !filter.test(input.value)) { //ADD ERROR CLASS this.addClass(input, classError); } else { //FIELD IS VALID this.addClass(input, classSuccess); validCount += 1; } } } //IF ALL FIELDS ARE VALID if (validCount === 3) { //SUBMIT FORM this.submitForm(); } }, addClass: function(input, clss) { container = input.parentElement; //IF INPUT HAS ERROR if (clss === classError) { //SHOW ERROR MESSAGE this.errorMessage(input); } //ADD CLASS input.parentElement.classList.add(clss); }, errorMessage: function(input) { var message; //IF NAME HAS ERROR if (input === this.fields.fullname) { message = "Моля, въведете пълно име"; //ELSE IF LOCATION HAS ERROR } else if (input === this.fields.location) { message = "Моля, въведете град/село"; //ELSE IF USEREMAIL HAS ERROR } else if (input === this.fields.email) { message = "Има грешка в имейла"; } this.renderError(input, message); }, renderError: function(input, message) { var html; //GET INPUT CONTAINER container = input.parentElement; //RENDER HTML html = document.createElement("div"); html.setAttribute("class", "message"); html.innerHTML = message; //IF MESSAGE ELEMENT DOESN'T EXIST if (!container.getElementsByClassName("message")[0]) { //INSERT MESSAGE TO INPUT CONTAINER container.insertBefore(html, container.firstElementChild); } }, resetClassList: function(input) { var i; //IF TARGETING SPECIFIC INPUT if (input) { //GET INPUT CONTAINER container = input.parentElement; //REMOVE CLASSES container.classList.remove(classError, classSuccess); //FOCUS ON INPUT FIELD input.focus(); } else { for (i in this.fields) { if (this.fields.hasOwnProperty(i)) { //REMOVE CLASSES FROM ALL FIELDS this.fields[i].parentElement.classList.remove(classError, classSuccess); } } } }, resetErrors: function(input) { //GET INPUT CONTAINER container = input.parentElement; //IF CONTAINER CONTAINS ERROR if (container.classList.contains(classError)) { //RESET CLASSES this.resetClassList(input); } }, submitForm: function() { var waitForAnimation; //ADD SUCCESS CLASS this.contactForm.classList.add(classSuccess); //WAIT FOR ANIMATION TO FINISH this.changeHeader("Регистрацията е успешна!"); //WAIT FOR ANIMATION TO FINISH setTimeout(this.changeHeader.bind(this, "ДОБРЕ ДОШЛИ!"), 1800); }, changeHeader: function(text) { //CHANGE HEADER TEXT this.formHeader.innerHTML = text; } }; //INITIATE FORM VALIDATOR formValidator.init(); }()); </code></pre> </div>

如何从MySQL数据库表中获取JavaScript变量？_course

<div class="post-text" itemprop="text"> <p>I want to take a JavaScript var from database to JavaScript code.</p> <p>I have a twitch community that help stream by the way I need to let the user or member add their twitch name to the list so that other members can see them when they are online.</p> <p><strong>my code is : JAVASCRIPT</strong> </p> <pre><code>var hello = "hello"; /* This is an alternate method to creating javascript methods function streamer(name, status, url) { this.name = name; this.status = status; this.url = url; } */ // The streamer object // here we will store the necessary information from // the twitch api json file var Streamer = { id: 0, status: "title", name: "strimmah", display_name: "Strimmah", url: "https://secure.twitch.tv/freecodecamp", // test url previewImgs: ["large", "medium", "small", "template"], game: "GaM3", viewers: 0, init: function(name, status, game, url) { this.name = name; this.status = status; this.game = game; this.url = url; }, init: function(name, status, game, viewers, url) { this.name = name; this.status = status; this.game = game; this.viewers = viewers; this.url = url; }, initPreviewImgs: function(large, medium, small, template) { this.previewImgs[0] = large; this.previewImgs[1] = medium; this.previewImgs[2] = small; this.previewImgs[3] = template; } }; // delete test variables var test = Object.create(Streamer); var backUpImage = "https://static-cdn.jtvnw.net/ttv-static/404_preview-640x360.jpg"; var tempStreamers = [ "nokss68", "snake606", "team_itxx_cod", "relapsegtv", "sokkaenpyjama", "elfepurpl3", "lighthund", "spacecakezed", "nagatsu6", "xng360", "nazenko", "giiskaa", "floki_live", "kayakox", "jejen64", "spivix", "keryg4n", "mehdii95150", "mrgeekyfr", "zaykerz92", "etsalutdit", "x_dyn_x", "martind32", "el_fideo11", "xmisticoxx", "zookervinc78", "MrCraaftt", "killerelite84", "Aqu0ss", "panteleimon42", "veynstream", "le_salty_gamer" ]; var streamDisplayStatus = 1; // 0-ALL, 1-Online Only, 2-Offline only var twitchURL = "https://secure.twitch.tv/"; // to create channel urls var streamerArray = []; var showOffline = true; // ENTRY POINT, $(document).ready(function() { /*for (var i = 0; i &lt; tempStreamers.length; i++) { loadStreamJsonInfo(tempStreamers[i], test); }*/ // initial set of streamers, we start with Overview so show all instantiateStreamers(); // navigator button setup navigationButtons(); }); function instantiateStreamers() { streamerArray.length = 0; for (var i = 0; i &lt; tempStreamers.length; i++) { var streamer = Object.create(Streamer); loadStreamJsonInfo(tempStreamers[i], streamer); } } function loadStreamJsonInfo(name, data) { /*$.getJSON('https://api.twitch.tv/kraken/streams/freecodecamp?callback=?', function(json) { console.log(json); }); */ $.getJSON('https://api.twitch.tv/kraken/streams/' + name + '?callback=?', function(json) { // console.log(json); var stream = json.stream; if (stream !== null) { var channel = json.stream.channel; data.init(channel.display_name, channel.status, channel.game, stream.viewers, channel.url); data.initPreviewImgs(stream.preview.large, stream.preview.medium, stream.preview.small, stream.preview.template); // console.log(data.name + " " + data.status + " " + data.viewers); } else { data.init(name, "Offline", "", 0, twitchURL + name) data.initPreviewImgs(backUpImage, backUpImage, backUpImage, backUpImage); } streamerArray.push(data); //console.log("TEST: " + streamerArray.length); checkDisplayStatus(data); }); // end of getJson } function checkDisplayStatus(data) { switch (streamDisplayStatus) { case 0: createStreamerDOMItem(data); break; case 1: if (data.status !== "Offline") { createStreamerDOMItem(data); } break; case 2: if (data.status === "Offline") { createStreamerDOMItem(data); } break; default: createStreamerDOMItem(data); console.log("Default switch"); break; } } function createStreamerDOMItem(streamData) { var divStart = '&lt;div class="streamer-container"&gt;'; var divEnd = '&lt;/div&gt;&lt;/div&gt;'; var divStreamerItem = '&lt;div class="streamer-item" align="center"&gt;' + '&lt;a target="_blank" href="' + streamData.url + '"&gt;&lt;iframe src="https://player.twitch.tv/?channel='+ streamData.name +'\" frameborder="0" scrolling="no" height="350" width="100%" /&gt;&lt;/a&gt;' + '&lt;p id="viewer-count"&gt;&lt;font color="yellow"&gt;' + streamData.viewers + '&amp;nbsp;personne(s) sur ' + '&lt;/font&gt;&lt;a href=\"' + streamData.url + '\" id="streamer-link"&gt;' + streamData.name + '&lt;/a&gt;&lt;/p&gt;' + ''; var final = divStart + divStreamerItem + divEnd; $(final).appendTo(".live-channels-container"); } function clearStreamerDOMItems() { $("div").remove(".streamer-container"); } </code></pre> <p><strong>HTML</strong> </p> <pre><code>&lt;div&gt; &lt;div class="navbar-container" &gt; &lt;/div&gt; &lt;br&gt; &lt;div class="live-channels-container"&gt; &lt;/div&gt; &lt;!-- END OF STREAMER BOXES--&gt; &lt;/div&gt; </code></pre> <p>Now I want to get ( var tempStreamers = ) username from DATABASE.</p> </div>

JavaScript更新MySQL？_course

<div class="post-text" itemprop="text"> <p>:)</p> <p>I'm hoping to make a <strong>very</strong> simple rating system. It won't consist of anything like averages, it's literally vote up or vote down, so if there's more votes down it'll go into a minus stance.</p> <p>What I'd like is for when the links to vote up/down are clicked, the page isn't refreshed, just that rating number. I'm guessing I can do this with JavaScript's append once it calls the new data, however I've no idea how to run the MySQL query with JavaScript.</p> <p>From what I understand, this isn't all that safe so I'm hoping I can run it from a PHP file?</p> <p>Can anyone tell me how to do this please?</p> </div>

从SQL数据库使用PHP和JavaScript登录_course

<div class="post-text" itemprop="text"> <p>I have created a drop-down login panel (I am using Bootstrap 3.3.7), where I want the user to input the username and password used during registration. </p> <p>If login is successful I want the user to be redirected to another page called <code>profile.php</code> else if login is not successful an error message will appear on the login panel footer. Here is my html code for the panel:</p> <pre><code>&lt;li class="nav-link dropdown"&gt; &lt;a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"&gt;&lt;span class="glyphicon glyphicon-user"&gt;&lt;/span&gt;Login&lt;/a&gt; &lt;div class="dropdown-menu" aria-labelledby="navbarDropdown"&gt; &lt;div style="width:300px;"&gt; &lt;div class="panel-heading text-center" style="color:black;"&gt;LOGIN&lt;/div&gt; &lt;div class="panel-heading"&gt; &lt;label for="email"&gt;username&lt;/label&gt; &lt;input type="text" class="form-control" id="username"&gt; &lt;label for="email"&gt;Password&lt;/label&gt; &lt;input type="password" class="form-control" id="password"&gt; &lt;br&gt; &lt;a href="#" style="color:blue; list-style:none;"&gt;Forgotten password?&lt;/a&gt;&lt;input type="submit" class="btn btn-success" style="float:right;" id="login" value="login"&gt; &lt;/div&gt; &lt;div class="panel-footer" id="login_msg"&gt;&lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/li&gt; </code></pre> <p>here is my javascript login code:</p> <pre><code>$("#login").click(function(event) { event.preventDefault(); var u_name = $("#username").val(); var pass = $("#password").val(); $.ajax({ url: "login.php", method: "POST", data: { userLogin: 1, userUname: u_name, userPassword: pass }, success: function(data) { if (data == "truejsdhfkh") { window.location.href = "profile.php"; } else { $("#login_msg").html(data); } } }) }) </code></pre> <p>here is my php login code:</p> <pre><code>&lt;?php // connect to the database include "db.php"; //session start session_start(); //login page if(isset($_POST['userLogin'])){ $uname = mysqli_real_escape_string($con, $_POST['userUname']); $passwrd = mysqli_real_escape_string($con, $_POST['userPassword']); if(empty($uname) || empty($passwrd)){ echo " &lt;div class='alert alert-danger'&gt; &lt;a href='#' class='close' data-dismiss='alert' aria-label='close'&gt;&amp;times;&lt;/a&gt;&lt;b&gt;Please fill in all fields!&lt;/b&gt; &lt;/div&gt; "; exit(); }else{ $passwrd = md5($passwrd); $sql = "SELECT * FROM user_info WHERE username = '$u_name' AND passwrd = '$password'"; $run_query = mysqli_query($con,$sql); $count = mysqli_num_rows($run_query); if($count == 1){ $row = mysqli_fetch_array($run_query); $_SESSION["uid"] = $row["user_id"]; $_SESSION["uname"] = $row["username"]; echo "truejsdhfkh"; } } } ?&gt; </code></pre> <p>I am using a phpMyAdmin SQL database. The database name is <code>user_info</code> with the following columns: (<code>user_id</code>, <code>username</code>, <code>first_name</code>, <code>last_name</code>, <code>email</code>, <code>passwrd</code>, <code>mobile</code>, <code>home_town</code>)</p> <p>When I click the login button nothing happens please help?</p> </div>

使用php从数据库中获取带引号或撇号的字符串，使用json_encode，然后尝试在javascript中解析JSON_course

<div class="post-text" itemprop="text"> <p>I have a table full of strings in a database, about a sentence long each. Some have quotation marks in them or apostrophes. I run a fetch in React-native, which runs a php file. This php file gets a random item from the table and echos it so the javascript can parse the JSON string and do things with it. If the string has quotation marks or apostrophe(s), the app crashes with "JSON parse error: unexpected EOF". I have tried addslashes() and I have even tried using the php function str_replace() to replace quotations and apostrophes with obscure characters. Either way, I still get the crash and the same error message. Here is part of the code here:</p> <pre class="lang-php prettyprint-override"><code>$get_fate = "SELECT * FROM $fates ORDER BY RAND() LIMIT 1"; $run_fate = mysqli_query($con, $get_fate); $num_fates = mysqli_num_rows($run_fate); if ($num_fates == 1) { $row_fate = mysqli_fetch_assoc($run_fate); $fate = $row_fate['fate']; $msg = addslashes($fate); $msg_json = json_encode($msg); echo $msg_json; } else ... </code></pre> <p>And the javascript side:</p> <pre class="lang-js prettyprint-override"><code>getFate = async () =&gt; { let user = await AsyncStorage.getItem('email'); fetch('fetch address goes here', { method: 'POST', headers: { 'Accept': 'application/json', 'Content-Type': 'application.json', }, body: JSON.stringify({ email: user }) }).then((response) =&gt; response.json()) .then((responseJson) =&gt; { this.setState({fate: responseJson}); }).catch((error) =&gt; { console.error(error); }); } </code></pre> <p>Here is an image of the crash:</p> <p><a href="https://i.stack.imgur.com/Wa0zP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wa0zP.jpg" alt="enter image description here"></a></p> <p>And if it means anything, I was sent a big word file of all these "fates". I used fates.splitlines() in python to separate them all into separate strings and put them into an array, which I looped through in php and inserted into the database. I then noticed there was some kind of klingon looking text where quotes and apostrophes should be, so I "fixed" that with the following SQL queries:</p> <p></p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false"> <div class="snippet-code"> <pre class="snippet-code-js lang-js prettyprint-override"><code>UPDATE choose_your_fate SET fate = REPLACE(fate, '“', '“'); UPDATE choose_your_fate SET fate = REPLACE(fate, 'â€', '”'); UPDATE choose_your_fate SET fate = REPLACE(fate, '’', '’'); UPDATE choose_your_fate SET fate = REPLACE(fate, '‘', '‘');</code></pre> </div> </div> </div>

如何使用（PHP）foreach用我的数据库中的记录更新我的javascript时间表？_course

<div class="post-text" itemprop="text"> <p>I am making a timetable with php and javascript and if each time i add a (name,time,date..) i want to update my javascript timetable</p> <p>i am using phpmyadmin for my database and the timetable is gantt and from am4charts</p> <p>this is the php:</p> <pre><code>$query = "SELECT Nom FROM registre"; $resultat = mysqli_query($connect, $query); $data = array(); //$chart_data = ''; //while ($row = mysqli_fetch_array($resultat)) if(mysqli_num_rows($resultat)&gt;0){ while ($row = mysqli_fetch_assoc($resultat)) { $data2[] = $row; } } //print_r($data); foreach ($data2[0] as $data2) { echo $data2; } </code></pre> <p>this is javascript:</p> <pre><code>chart.data = [ { name:"&lt;?php echo $data2; ?&gt;", fromDate: "2018-01-01 08:00", toDate: "2018-01-01 10:00", color: colorSet.getIndex(0).brighten(0) }, ]; var categoryAxis = chart.yAxes.push(new am4charts.CategoryAxis()); categoryAxis.dataFields.category = "name"; categoryAxis.renderer.grid.template.location = 0; categoryAxis.renderer.inversed = true; </code></pre> </div>

ajax获取不到php从数据库里面读取到的数据，（php读取到的数据已经成功转换成了json数据）_course

javascript代码： ```javascript // 初始化两个数组，盛装从数据库中获取到的数据 var dates = new Array(), moneys = new Array(); //调用ajax来实现异步的加载数据 function getusers() { $.ajax({ type: "post", async: false, data:{}, url: "dataDemo/dataIndex.php", data: {}, dataType: "json", success: function(result){ if(result){ for(var i = 0; i < result.length; i++){ dates.push(result[i].sum); moneys.push(result[i].money); } } }, error: function(errmsg) { alert("Ajax获取服务器数据出错了！"+ errmsg); } }); return dates, moneys; } //执行异步请求 getusers(); ``` public_function.php代码： ```php <?php function dbInit(){ global $con; $dsn = "mysql:dbname=info;localhost=127.0.0.1"; $user = "root"; $password = "644066YanMin&&!+"; try{ $con = new PDO($dsn,$user,$password); }catch(PDOExcepetion $e){ die ("Error!: " . $e->getMessage() . "<br/>"); } } /* 处理结果集中有多条数据的函数; */ function fetchAll($sql){ global $con; class user{ public $times; public $money; } if($result = $con->query($sql)){ //声明数组，用于接收结果集; $data = array(); //遍历结果集; while($row = $result->fetch(PDO::FETCH_ASSOC)){ $user = new User(); $user->times = $row['times']; $user->money = $row['sum']; $data[] = $user; } return $data; }else{ //执行失败; return false; } } ``` dataIndex.php代码 ```php <?php require "public_function.php"; dbInit(); $sql = 'select times,sum from date'; $datas = fetchAll($sql); // 返回JSON类型的数据 echo json_encode($datas); //$con = null; require "dataIndex.html"; ```