Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
sayuru bandara
Updated:
Tuesday at 12:30 PM
Ad icon
ඉන්ටර්නෙට් එකෙන් හරියටම සල්ලි හොයන්න සහ Success වෙන්න කැමතිද? 🚀 (E-Money & Success Stories)
siri sumana
Updated:
Saturday at 11:44 PM
Gemini AI PRO 18 months Offer
Hawaka
Updated:
May 27, 2026
Ad icon
koko account
DasunEranga
Updated:
May 27, 2026
Ad icon
koko account
DasunEranga
Updated:
May 27, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
Computers & Internet
Software Development
UseFul PHP Script`s n Code`s
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="MaD-DoC" data-source="post: 4130172" data-attributes="member: 56284"><p><strong>Add data to a MySQL database</strong></p><p></p><p> <strong>Description</strong></p><p></p><p> How to insert and save information into a MySQL database table using PHP.</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">* We're using two values, title and</span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* text. Replace these with 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 want to add 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">* Finally, change tablename to the </span></span></p><p><span style="color: #000000"><span style="color: #FF8000"></span></span></p><p> <span style="color: #000000"><span style="color: #FF8000">* name of your 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"></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">"INSERT INTO tablename(title, text) VALUES('$title','$text')"</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 added to the database."</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>
[QUOTE="MaD-DoC, post: 4130172, member: 56284"] [B]Add data to a MySQL database[/B] [B]Description[/B] How to insert and save information into a MySQL database table using PHP. [B]The code[/B] [COLOR=#000000] [COLOR=#0000BB]<?php [/COLOR][COLOR=#FF8000]/** * Change the first line to whatever * you use to connect to the database. * * We're using two values, title and * text. Replace these with whatever * you want to add to the database. * * Finally, change tablename to the * name of your table. */ // Your database connection code [/COLOR][COLOR=#0000BB]db_connect[/COLOR][COLOR=#007700](); [/COLOR][COLOR=#0000BB]$query [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#DD0000]"INSERT INTO tablename(title, text) VALUES('$title','$text')"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#0000BB]$result [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$query[/COLOR][COLOR=#007700]); echo [/COLOR][COLOR=#DD0000]"The data has been added to the database."[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#0000BB]?> [/COLOR][/COLOR] [/QUOTE]
Insert quotes…
Verification
Hata thunen beduwama keeyada? (60 bedeema thuna)
Post reply
Top
Bottom