擅长:python、mysql、java
<blockquote>
<p>I hope that is what you want</p>
</blockquote>
<pre><code>#! /usr/bin/python
import sqlite3
db = sqlite3.connect("vt.db")
cr = db.cursor()
def get_db_data():
return db.execute("SELECT * FROM icerik").fetchall()
def get_result_html():
icerik = ""
for i in get_db_data():
if len(i) >= 1:
icerik += f"""
<div class="article">
<img src='+ {str(i[3])}' alt="Bilişim Hukuku" class="img">
<a href="" class="categori">Bilişim Hukuku</a>
<br>
<h3 class="articleh3"> {str(i[1])}</h3>
<a href='/blog.html?id= {str(i[0])}'>Devamını oku</a>
</div>
"""
else:
print("not SQL match !")
return str(icerik)
</code></pre>