snipt

Ctrl+h for KB shortcuts

HTML

d3

<?php
 include('conexion.php');
?>
<!DOCTYPE html>
<html>
<head>
<title>Lista de que haceres</title>
<link href="style.css" rel="stylesheet">
</head>

<body>
<div>
<h1>Agregar un quehacer</h1>
<fieldset>
 <form action='agregar.php' method='POST'>
 <label>Nombre: <input type="text" size="20" name="nombre"></label><br />
 <label>Hora: <input type="text" size="20" name="hora"></label><br />
 <input type="submit" value="Agregar" name='submitted' >
 </form>
</fieldset>
</div>

<div>
<h1>Lista de quehaceres</h1>
<ol>

<?php
 $result = mysql_query("SELECT * FROM `lista` ORDER BY id ASC") or trigger_error(mysql_error());
 while ($row = mysql_fetch_array($result)){ ?>
 <li><?php echo $row['nombre']; ?> <small><?php echo $row['hora'];?></small><a href="eliminar.php?id=<?php echo $row['id']; ?>">X</a></li>
<?php } ?>
</ol>
</div>

</body>
</html>
https://snippets.siftie.com/embed/e53125275854402400f74fd6ab3f7659/
/raw/e53125275854402400f74fd6ab3f7659/
e53125275854402400f74fd6ab3f7659
html
HTML
36
2019-03-22T20:26:12
True
False
False
/api/public/snipt/20338/
d3
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a> <a href="#L-23">23</a> <a href="#L-24">24</a> <a href="#L-25">25</a> <a href="#L-26">26</a> <a href="#L-27">27</a> <a href="#L-28">28</a> <a href="#L-29">29</a> <a href="#L-30">30</a> <a href="#L-31">31</a> <a href="#L-32">32</a> <a href="#L-33">33</a> <a href="#L-34">34</a> <a href="#L-35">35</a> <a href="#L-36">36</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?php</span> </span><span id="L-2"><a name="L-2"></a><span class="cp"> include(&#39;conexion.php&#39;);</span> </span><span id="L-3"><a name="L-3"></a><span class="cp">?&gt;</span> </span><span id="L-4"><a name="L-4"></a><span class="cp">&lt;!DOCTYPE html&gt;</span> </span><span id="L-5"><a name="L-5"></a><span class="p">&lt;</span><span class="nt">html</span><span class="p">&gt;</span> </span><span id="L-6"><a name="L-6"></a><span class="p">&lt;</span><span class="nt">head</span><span class="p">&gt;</span> </span><span id="L-7"><a name="L-7"></a><span class="p">&lt;</span><span class="nt">title</span><span class="p">&gt;</span>Lista de que haceres<span class="p">&lt;/</span><span class="nt">title</span><span class="p">&gt;</span> </span><span id="L-8"><a name="L-8"></a><span class="p">&lt;</span><span class="nt">link</span> <span class="na">href</span><span class="o">=</span><span class="s">&quot;style.css&quot;</span> <span class="na">rel</span><span class="o">=</span><span class="s">&quot;stylesheet&quot;</span><span class="p">&gt;</span> </span><span id="L-9"><a name="L-9"></a><span class="p">&lt;/</span><span class="nt">head</span><span class="p">&gt;</span> </span><span id="L-10"><a name="L-10"></a> </span><span id="L-11"><a name="L-11"></a><span class="p">&lt;</span><span class="nt">body</span><span class="p">&gt;</span> </span><span id="L-12"><a name="L-12"></a><span class="p">&lt;</span><span class="nt">div</span><span class="p">&gt;</span> </span><span id="L-13"><a name="L-13"></a><span class="p">&lt;</span><span class="nt">h1</span><span class="p">&gt;</span>Agregar un quehacer<span class="p">&lt;/</span><span class="nt">h1</span><span class="p">&gt;</span> </span><span id="L-14"><a name="L-14"></a><span class="p">&lt;</span><span class="nt">fieldset</span><span class="p">&gt;</span> </span><span id="L-15"><a name="L-15"></a> <span class="p">&lt;</span><span class="nt">form</span> <span class="na">action</span><span class="o">=</span><span class="s">&#39;agregar.php&#39;</span> <span class="na">method</span><span class="o">=</span><span class="s">&#39;POST&#39;</span><span class="p">&gt;</span> </span><span id="L-16"><a name="L-16"></a> <span class="p">&lt;</span><span class="nt">label</span><span class="p">&gt;</span>Nombre: <span class="p">&lt;</span><span class="nt">input</span> <span class="na">type</span><span class="o">=</span><span class="s">&quot;text&quot;</span> <span class="na">size</span><span class="o">=</span><span class="s">&quot;20&quot;</span> <span class="na">name</span><span class="o">=</span><span class="s">&quot;nombre&quot;</span><span class="p">&gt;&lt;/</span><span class="nt">label</span><span class="p">&gt;&lt;</span><span class="nt">br</span> <span class="p">/&gt;</span> </span><span id="L-17"><a name="L-17"></a> <span class="p">&lt;</span><span class="nt">label</span><span class="p">&gt;</span>Hora: <span class="p">&lt;</span><span class="nt">input</span> <span class="na">type</span><span class="o">=</span><span class="s">&quot;text&quot;</span> <span class="na">size</span><span class="o">=</span><span class="s">&quot;20&quot;</span> <span class="na">name</span><span class="o">=</span><span class="s">&quot;hora&quot;</span><span class="p">&gt;&lt;/</span><span class="nt">label</span><span class="p">&gt;&lt;</span><span class="nt">br</span> <span class="p">/&gt;</span> </span><span id="L-18"><a name="L-18"></a> <span class="p">&lt;</span><span class="nt">input</span> <span class="na">type</span><span class="o">=</span><span class="s">&quot;submit&quot;</span> <span class="na">value</span><span class="o">=</span><span class="s">&quot;Agregar&quot;</span> <span class="na">name</span><span class="o">=</span><span class="s">&#39;submitted&#39;</span> <span class="p">&gt;</span> </span><span id="L-19"><a name="L-19"></a> <span class="p">&lt;/</span><span class="nt">form</span><span class="p">&gt;</span> </span><span id="L-20"><a name="L-20"></a><span class="p">&lt;/</span><span class="nt">fieldset</span><span class="p">&gt;</span> </span><span id="L-21"><a name="L-21"></a><span class="p">&lt;/</span><span class="nt">div</span><span class="p">&gt;</span> </span><span id="L-22"><a name="L-22"></a> </span><span id="L-23"><a name="L-23"></a><span class="p">&lt;</span><span class="nt">div</span><span class="p">&gt;</span> </span><span id="L-24"><a name="L-24"></a><span class="p">&lt;</span><span class="nt">h1</span><span class="p">&gt;</span>Lista de quehaceres<span class="p">&lt;/</span><span class="nt">h1</span><span class="p">&gt;</span> </span><span id="L-25"><a name="L-25"></a><span class="p">&lt;</span><span class="nt">ol</span><span class="p">&gt;</span> </span><span id="L-26"><a name="L-26"></a> </span><span id="L-27"><a name="L-27"></a><span class="cp">&lt;?php</span> </span><span id="L-28"><a name="L-28"></a><span class="cp"> $result = mysql_query(&quot;SELECT * FROM `lista` ORDER BY id ASC&quot;) or trigger_error(mysql_error());</span> </span><span id="L-29"><a name="L-29"></a><span class="cp"> while ($row = mysql_fetch_array($result)){ ?&gt;</span> </span><span id="L-30"><a name="L-30"></a> <span class="p">&lt;</span><span class="nt">li</span><span class="p">&gt;</span><span class="cp">&lt;?php echo $row[&#39;nombre&#39;]; ?&gt;</span> <span class="p">&lt;</span><span class="nt">small</span><span class="p">&gt;</span><span class="cp">&lt;?php echo $row[&#39;hora&#39;];?&gt;</span><span class="p">&lt;/</span><span class="nt">small</span><span class="p">&gt;&lt;</span><span class="nt">a</span> <span class="na">href</span><span class="o">=</span><span class="s">&quot;eliminar.php?id=&lt;?php echo $row[&#39;id&#39;]; ?&gt;&quot;</span><span class="p">&gt;</span>X<span class="p">&lt;/</span><span class="nt">a</span><span class="p">&gt;&lt;/</span><span class="nt">li</span><span class="p">&gt;</span> </span><span id="L-31"><a name="L-31"></a><span class="cp">&lt;?php } ?&gt;</span> </span><span id="L-32"><a name="L-32"></a><span class="p">&lt;/</span><span class="nt">ol</span><span class="p">&gt;</span> </span><span id="L-33"><a name="L-33"></a><span class="p">&lt;/</span><span class="nt">div</span><span class="p">&gt;</span> </span><span id="L-34"><a name="L-34"></a> </span><span id="L-35"><a name="L-35"></a><span class="p">&lt;/</span><span class="nt">body</span><span class="p">&gt;</span> </span><span id="L-36"><a name="L-36"></a><span class="p">&lt;/</span><span class="nt">html</span><span class="p">&gt;</span> </span></pre></div> </td></tr></table>
html