首页 \ 问答 \ 如何使用JQuery在图像旁显示数据库信息？(How to display database information next to an image with JQuery?)

如何使用JQuery在图像旁显示数据库信息？(How to display database information next to an image with JQuery?)

 嗨，大家好，我希望在库中的每个不同图像上显示来自数据库的任何类型的信息（ 这看起来与RedBox非常相似），但我不知道如何去做，有没有人有任何解决方案这个？  
 PS：顺便说一句，我正在使用SQL Server 2008  
 这是我迄今为止...  
 的index.html  
<!DOCTYPE html>
<html>
    <head>
        <title>Tablero</title>
        <link rel="stylesheet" href="css/style.css">
        <script src="http://code.jquery.com/jquery-1.8.2.min.js"></script>
    </head>
    <body>
        <section class="tagline">
            <h1>Jueces</h1>
        </section>
        <div id="container">
            <h1 id="heading"> Projects</h1>
            <ul id="gallery"></ul>
        </div>
        <script>
            $(document).ready(function() {
                setInterval(function() {
                    $("#container").load('connection.php');
                }, 1000);
            });
        </script>

    </body>
</html>
 
 Connection.php  
<?php 
$server = "localhost";
$user = "perron";
$password = "hasg";
$database = "ejemplo";
$conn = odbc_connect("Driver={SQL Server Native Client 10.0}; Server=$server; Database=$database;", $user, $password);
$sql = "SELECT * FROM Prueba";
$rs = odbc_exec($conn, $sql);
if (!$rs) { exit("Error en la consulta SQL");
}
?>

<div class="container">
    <div id="container">
        <h1 id="heading"> Projects</h1>
        <ul id="gallery">
            <?php do{
            ?>
            <?php $resultado_img = odbc_result($rs, "img");
            $resultado_id = odbc_result($rs, "id");
            $resultado_nombre = odbc_result($rs, "nombre");
            $resultado_fecha = odbc_result($rs, "fecha_aud");
            $resultado_hora = odbc_result($rs, "hora_aud");
            $resultado_juzgado = odbc_result($rs, "juzgado");
            ?>
            <?php echo '<li><img src="img/' . $resultado_img . "\" alt=\"\" height=\"200\" width=\"200\" /></li>"; ?>
            <?php }
                while ( odbc_fetch_row($rs) )
            ?>
        </ul>
    </div>
</div>
 
 style.css文件  
body {
    margin: 0;
    padding: 0;
    font-family: "Arial", sans-serif;
    font-size: 15px;
    color: #666;
    text-decoration: none;
    line-height: 1.6em;
}
a {
    color: #666;
    text-decoration: none;
}
.container {
    width: 80%;
    margin: auto;
    overflow: auto;
}
.logo {
    float: left;
    width: 30%;
    margin-top: 15px;
}
section {
    padding: 20px 0;
    overflow: hidden;
}
.tagline {
    background: #03899c;
    color: #fff;
}
.tagline h1 {
    text-align: center;
    font-size: 35px;
}
#gallery {
    list-style: none;
    margin: 0;
    padding: 0;
    width: 100%;
}
#gallery li {
    display: block;
    float: left;
    width: 23%;
    cursor: pointer;
    border-radius: 5px;
    box-sizing: border-box;
    margin: 0 12px 7px 0;
}
#gallery img {
    width: 100%;
    border-radius: 5px;
}

Hi everybody I want to display any kind of information from the database on every different image in the gallery (This is how it looks) pretty similar to RedBox but I don't have any idea how to do it, does anybody have any solution for this?  
P.S: btw I'm using sql server 2008  
This is what I have so far... 
Index.html 
<!DOCTYPE html>
<html>
    <head>
        <title>Tablero</title>
        <link rel="stylesheet" href="css/style.css">
        <script src="http://code.jquery.com/jquery-1.8.2.min.js"></script>
    </head>
    <body>
        <section class="tagline">
            <h1>Jueces</h1>
        </section>
        <div id="container">
            <h1 id="heading"> Projects</h1>
            <ul id="gallery"></ul>
        </div>
        <script>
            $(document).ready(function() {
                setInterval(function() {
                    $("#container").load('connection.php');
                }, 1000);
            });
        </script>

    </body>
</html>
 
Connection.php 
<?php 
$server = "localhost";
$user = "perron";
$password = "hasg";
$database = "ejemplo";
$conn = odbc_connect("Driver={SQL Server Native Client 10.0}; Server=$server; Database=$database;", $user, $password);
$sql = "SELECT * FROM Prueba";
$rs = odbc_exec($conn, $sql);
if (!$rs) { exit("Error en la consulta SQL");
}
?>

<div class="container">
    <div id="container">
        <h1 id="heading"> Projects</h1>
        <ul id="gallery">
            <?php do{
            ?>
            <?php $resultado_img = odbc_result($rs, "img");
            $resultado_id = odbc_result($rs, "id");
            $resultado_nombre = odbc_result($rs, "nombre");
            $resultado_fecha = odbc_result($rs, "fecha_aud");
            $resultado_hora = odbc_result($rs, "hora_aud");
            $resultado_juzgado = odbc_result($rs, "juzgado");
            ?>
            <?php echo '<li><img src="img/' . $resultado_img . "\" alt=\"\" height=\"200\" width=\"200\" /></li>"; ?>
            <?php }
                while ( odbc_fetch_row($rs) )
            ?>
        </ul>
    </div>
</div>
 
Style.css 
body {
    margin: 0;
    padding: 0;
    font-family: "Arial", sans-serif;
    font-size: 15px;
    color: #666;
    text-decoration: none;
    line-height: 1.6em;
}
a {
    color: #666;
    text-decoration: none;
}
.container {
    width: 80%;
    margin: auto;
    overflow: auto;
}
.logo {
    float: left;
    width: 30%;
    margin-top: 15px;
}
section {
    padding: 20px 0;
    overflow: hidden;
}
.tagline {
    background: #03899c;
    color: #fff;
}
.tagline h1 {
    text-align: center;
    font-size: 35px;
}
#gallery {
    list-style: none;
    margin: 0;
    padding: 0;
    width: 100%;
}
#gallery li {
    display: block;
    float: left;
    width: 23%;
    cursor: pointer;
    border-radius: 5px;
    box-sizing: border-box;
    margin: 0 12px 7px 0;
}
#gallery img {
    width: 100%;
    border-radius: 5px;
}

原文：https://stackoverflow.com/questions/37780625

更新时间：2024-03-27 15:03

最满意答案

 这将有助于表明你已经做了一些功课......  
library(sos)
findFn("perceptron")
RSiteSearch("perceptron")  ## after running this, click on some buttons on the web page to expand the search
 
 在http://rseek.org上搜索“perceptron”  
 也搜索[r] perceptron StackOverflow，虽然这并没有太多; 你也可以尝试[r] neural net ... 

It would help to show that you've done some homework ... 
library(sos)
findFn("perceptron")
RSiteSearch("perceptron")  ## after running this, click on some buttons on the web page to expand the search
 
Search "perceptron" at http://rseek.org 
Also search StackOverflow for [r] perceptron, although that doesn't get much; you might try [r] neural net too ...

如何使用JQuery在图像旁显示数据库信息？(How to display database information next to an image with JQuery?)

最满意答案

相关问答

感知器分类和R(perceptron classification and R)[2022-04-06]

R中的SVM分类图(SVM Classification Plot in R)[2022-03-09]

SVM分类 - R中的归一化(SVM classification - normalization in R)[2023-12-26]

感知器故障(Malfunctioning perceptron)[2022-03-13]

多层感知器：减少错误(Multi-layer perceptron: error reduction)[2023-01-02]

按ID分类(Classification in R by ID)[2023-06-02]

scikit学习平均感知器分类器(scikit learn averaged perceptron classifier)[2023-02-21]

感知器学习 - 最重要的特征(Perceptron learning - most important feature)[2022-04-02]

使用感知器进行分类(Use of perceptron for classification)[2023-06-15]

R中的树：回归与分类(Trees in R: regression vs classification)[2022-10-26]

相关文章

最新问答