Latest ads

Ad icon
Cam ෂෝ කරන්න ආස කෙල්ලෝ
- vip video seller srilanka
- Updated: 46 minutes ago
Cam show job
- vip video seller srilanka
- Updated: Today at 2:01 AM
Vip විඩීයෝ තියේ හොරෙන් රෙකෝඩ් කරපුවා
- vip video seller srilanka
- Updated: Today at 1:26 AM
Kandy Welcome all my all new pet shop Bark.lk
- dilumrane
- Updated: Monday at 12:26 PM
Windows RDP Only Rs.500 a month
- Blogerwiki
- Updated: Sunday at 12:41 PM

Reply to thread

Message: <blockquote data-quote="MaD-DoC" data-source="post: 4130179" data-attributes="member: 56284"><p><strong>Delete data from a MySQL database</strong></p><p></p><p>       <strong>Description</strong></p><p></p><p>       How to remove and erase stored information from a MySQL database table.</p><p>       <strong>The code</strong></p><p></p><p>       <span style="color: #000000"></span></p><p><span style="color: #000000"><span style="color: #0000BB"><?php</span></span></p><p><span style="color: #000000"><span style="color: #0000BB"></span></span></p><p><span style="color: #000000"><span style="color: #0000BB"></span></span></p><p><span style="color: #000000"><span style="color: #0000BB"></span></span></p><p><span style="color: #000000"><span style="color: #0000BB"></span><span style="color: #FF8000">/*</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* Change the first line to whatever</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* you use to connect to the database.</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">*</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* Change tablename to the name of your </span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* database table.</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">*</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* This example would delete a row from</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* a table based on the id of the row.</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* You can change this to whatever you</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* want.</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">*/</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p><span style="color: #000000"><span style="color: #FF8000">// Your database connection code</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span><span style="color: #0000BB">db_connect</span><span style="color: #007700">();</span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #DD0000">"DELETE FROM tablename WHERE id = ('$id')"</span><span style="color: #007700">;</span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);</span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700">echo </span><span style="color: #DD0000">"The data has been deleted."</span><span style="color: #007700">;</span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span></span></p><p><span style="color: #000000"><span style="color: #007700"></span><span style="color: #0000BB">?></span></span></p><p><span style="color: #000000"><span style="color: #0000BB"></span></span></p></blockquote><p></p>

Verification: Haya warak paha keeyada? (haya wadi kireema paha)

Top Bottom