{"id":6087,"date":"2015-02-23T15:01:23","date_gmt":"2015-02-23T20:01:23","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=6087"},"modified":"2015-07-11T10:45:39","modified_gmt":"2015-07-11T14:45:39","slug":"%e0%a6%aa%e0%a6%bf%e0%a6%8f%e0%a6%87%e0%a6%9a%e0%a6%aa%e0%a6%bf-%e0%a6%ae%e0%a6%be%e0%a6%87%e0%a6%8f%e0%a6%b8%e0%a6%95%e0%a6%bf%e0%a6%89%e0%a6%8f%e0%a6%b2-%e0%a6%9f%e0%a7%87%e0%a6%ac%e0%a6%bf","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=6087","title":{"rendered":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf : \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf (PHP Create MySQL Tables)"},"content":{"rendered":"<p>\u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09a8\u09be\u09ae \u09a5\u09be\u0995\u09c7 \u098f\u09ac\u0982 \u098f\u099f\u09be \u0995\u09b2\u09be\u09ae \u0993 \u09b8\u09be\u09b0\u09bf \u09a8\u09bf\u09af\u09bc\u09c7 \u0997\u09a0\u09bf\u09a4 \u09b9\u09df\u0964<\/p>\n<h2>MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099b\u0995 (table) \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be<\/h2>\n<p>\u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 CREATE TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964<br \/>\n\u0986\u09ae\u09b0\u09be \u098f\u0996\u09a8 &#8220;MyGuests&#8221; \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u09cb \u09af\u09be\u09b0 &#8220;id&#8221;, &#8220;firstname&#8221;, &#8220;lastname&#8221;, &#8220;email&#8221; \u098f\u09ac\u0982 &#8220;reg_date&#8221; \u09a8\u09be\u09ae\u09c7 \u09aa\u09be\u0981\u099a\u099f\u09bf \u0995\u09b2\u09be\u09ae \u09a5\u09be\u0995\u09ac\u09c7-<\/p>\n<hr \/>\n<pre>CREATE TABLE MyGuests (\r\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\n firstname VARCHAR(30) NOT NULL,\r\n lastname VARCHAR(30) NOT NULL,\r\n email VARCHAR(50),\r\n reg_date TIMESTAMP\r\n )<\/pre>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4>\u0989\u09aa\u09b0\u09c7\u09b0 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf\u09b0 \u099c\u09a8\u09cd\u09af \u0995\u09bf\u099b\u09c1 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6\u09a8\u09be<\/h4>\n<p>\u09a1\u09be\u099f\u09be \u099f\u09be\u0987\u09aa \u0995\u09b0\u09be\u09b0 \u09aa\u09b0\u09c7, \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09bf \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09af\u09c7 \u0990\u099a\u09cd\u099b\u09bf\u0995 \u09ac\u09c8\u09b6\u09bf\u09b7\u09cd\u099f\u09cd\u09af\u0997\u09c1\u09b2\u09bf \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8 \u09a4\u09be \u09a8\u09bf\u099a\u09c7 \u09a6\u09c7\u0993\u09df\u09be \u09b9\u09b2 :<\/p>\n<ul>\n<li>NOT NULL \u2013\u09af\u09c7 \u0995\u09b2\u09be\u09ae\u0995\u09c7 NOT NULL \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09a4\u09be\u09b0 \u0985\u09ac\u09b6\u09cd\u09af\u0987 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a8 (value) \u09a5\u09be\u0995\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u09ae\u09be\u09a8 (value) \u09a8\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u09aa\u09cd\u09b0\u0995\u09be\u09b6 \u098f\u09b0 \u0985\u09a8\u09c1\u09ae\u09a4\u09bf \u09aa\u09be\u09ac\u09c7 \u09a8\u09be\u0964<\/li>\n<li>DEFAULT value \u2013 \u09af\u0996\u09a8 \u0995\u09cb\u09a8 \u09ae\u09be\u09a8 (value) \u0997\u09c3\u09b9\u09c0\u09a4 \u09a8\u09be \u09b9\u09df, \u09a4\u0996\u09a8 \u0995\u09cb\u09a8 \u09a1\u09bf\u09ab\u09b2\u09cd\u099f (default) \u09ae\u09be\u09a8 (value) \u09af\u09cb\u0997 \u0995\u09b0\u09be \u0964<\/li>\n<li>UNSIGNED \u2013 \u0995\u09b2\u09be\u09ae \u098f \u09b6\u09c1\u09a7\u09c1\u09ae\u09be\u098f \u09b8\u0982\u0996\u09cd\u09af\u09be \u09a7\u09be\u09b0\u09a8\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 \u09b6\u09c1\u09a7\u09c1\u09ae\u09be\u098f \u09b8\u0982\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u09a4\u09a5\u09cd\u09af\u09c7\u09b0 \u0987\u09a4\u09bf\u09ac\u09be\u099a\u0995 \u09b8\u0982\u0996\u09cd\u09af\u09be \u098f\u09ac\u0982 \u09b6\u09c2\u09a8\u09cd\u09af \u09b8\u0982\u0996\u09cd\u09af\u09be\u09b0 \u09b8\u09c0\u09ae\u09be \u09a8\u09bf\u09af\u09bc\u09a8\u09cd\u09a4\u09cd\u09b0\u09a3 \u0995\u09b0\u09c7\u0964<\/li>\n<li>AUTO INCREMENT \u2013 \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09cd\u09ac\u09af\u09bc\u0982\u0995\u09cd\u09b0\u09bf\u09af\u09bc\u09ad\u09be\u09ac\u09c7 \u09ae\u09be\u09a8 \u09a8\u09bf\u09af\u09bc\u09a8\u09cd\u09a4\u09cd\u09b0\u09a3 \u0995\u09b0\u09c7\u0964<\/li>\n<li>PRIMARY KEY \u2013\u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09b8\u09be\u09b0\u09bf\u0995\u09c7 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09ad\u09be\u09ac\u09c7 \u09b8\u09a8\u09be\u0995\u09cd\u09a4 \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4\u0964<\/li>\n<\/ul>\n<p>\u09af\u09a6\u09bf \u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f primary key \u0995\u09b2\u09be\u09ae \u09a5\u09be\u0995\u09c7 (\u098f\u0987 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09a7\u09b0\u09b2\u09be\u09ae &#8220;id&#8221; \u0995\u09b2\u09be\u09ae\u099f\u09bf\u0995\u09c7 primary key \u0995\u09b0\u09be \u09b9\u09df\u09c7\u099b\u09c7) \u09a4\u09be\u09b9\u09b2\u09c7 \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u0995\u09be\u09b0 \u09a1\u09be\u099f\u09be \u098f\u0987 \u099f\u09c7\u09ac\u09bf\u09b2\u09c7\u09b0 \u09b8\u0982\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u09a1\u09be\u099f\u09be \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964<\/p>\n<p>\u09a8\u09bf\u09ae\u09cd\u09a8\u09b2\u09bf\u0996\u09bf\u09a4 \u0989\u09a6\u09be\u09b9\u09b0\u09a3 \u098f \u0986\u09ae\u09b0\u09be \u09a6\u09c7\u0996\u09ac\u09cb \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a6\u09cd\u09ac\u09be\u09b0\u09be \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09df-<\/p>\n<p>\u0989\u09a6\u09be\u09b9\u09b0\u09a3 <strong>(MySQLi Object-oriented)<\/strong><\/p>\n<hr \/>\n<pre>&lt; ?php\r\n $servername = \"localhost\";\r\n $username = \"username\";\r\n $password = \"password\";\r\n $dbname = \"myDB\";<\/pre>\n<pre>\/\/ Create connection\r\n $conn = new mysqli($servername, $username, $password, $dbname);\r\n \/\/ Check connection\r\n if ($conn-&gt;connect_error) {\r\n       die(\"Connection failed: \" . $conn-&gt;connect_error);\r\n }<\/pre>\n<pre>\/\/ sql to create table\r\n $sql = \"CREATE TABLE MyGuests (\r\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\n firstname VARCHAR(30) NOT NULL,\r\n lastname VARCHAR(30) NOT NULL,\r\n email VARCHAR(50),\r\n reg_date TIMESTAMP\r\n )\";<\/pre>\n<pre>if ($conn-&gt;query($sql) === TRUE) {\r\n        echo \"Table MyGuests created successfully\";\r\n } else {\r\n        echo \"Error creating table: \" . $conn-&gt;error;\r\n }<\/pre>\n<pre>$conn-&gt;close();\r\n ?&gt;<\/pre>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0989\u09a6\u09be\u09b9\u09b0\u09a3 <strong>(MySQLi Procedural)<\/strong><\/p>\n<hr \/>\n<pre>&lt; ?php\r\n $servername = \"localhost\";\r\n $username = \"username\";\r\n $password = \"password\";\r\n $dbname = \"myDB\";<\/pre>\n<pre>\/\/ Create connection\r\n $conn = mysqli_connect($servername, $username, $password, $dbname);\r\n \/\/ Check connection\r\n if (!$conn) {\r\n     die(\"Connection failed: \" . mysqli_connect_error());\r\n }<\/pre>\n<pre>\/\/ sql to create table\r\n $sql = \"CREATE TABLE MyGuests (\r\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\n firstname VARCHAR(30) NOT NULL,\r\n lastname VARCHAR(30) NOT NULL,\r\n email VARCHAR(50),\r\n reg_date TIMESTAMP\r\n )\";<\/pre>\n<pre>if (mysqli_query($conn, $sql)) {\r\n      echo \"Table MyGuests created successfully\";\r\n } else {\r\n      echo \"Error creating table: \" . mysqli_error($conn);\r\n }<\/pre>\n<pre>mysqli_close($conn);\r\n ?&gt;<\/pre>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0989\u09a6\u09be\u09b9\u09b0\u09a3 <strong>(PDO)<\/strong><\/p>\n<hr \/>\n<pre>&lt;?php\r\n $servername = \"localhost\";\r\n $username = \"username\";\r\n $password = \"password\";\r\n $dbname = \"myDBPDO\";\r\n \r\n try {\r\n \u00a0\u00a0\u00a0 $conn = new PDO(\"mysql:host=$servername;dbname=$dbname\", $username, $password);\r\n \u00a0\u00a0\u00a0 \/\/ set the PDO error mode to exception\r\n \u00a0\u00a0\u00a0 $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\r\n \r\n \u00a0\u00a0\u00a0 \/\/ sql to create table\r\n \u00a0\u00a0\u00a0 $sql = \"CREATE TABLE MyGuests (\r\n \u00a0\u00a0\u00a0 id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, \r\n \u00a0\u00a0\u00a0 firstname VARCHAR(30) NOT NULL,\r\n \u00a0\u00a0\u00a0 lastname VARCHAR(30) NOT NULL,\r\n \u00a0\u00a0\u00a0 email VARCHAR(50),\r\n \u00a0\u00a0\u00a0 reg_date TIMESTAMP\r\n \u00a0\u00a0\u00a0 )\";\r\n \r\n \u00a0\u00a0\u00a0 \/\/ use exec() because no results are returned\r\n \u00a0\u00a0\u00a0 $conn-&gt;exec($sql);\r\n \u00a0\u00a0\u00a0 echo \"Table MyGuests created successfully\";\r\n \u00a0\u00a0\u00a0 }\r\n catch(PDOException $e)\r\n \u00a0\u00a0\u00a0 {\r\n \u00a0\u00a0\u00a0 echo $sql . \"&lt;br&gt;\" . $e-&gt;getMessage();\r\n \u00a0\u00a0\u00a0 }\r\n \r\n $conn = null;\r\n ?&gt;<\/pre>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09a8\u09be\u09ae \u09a5\u09be\u0995\u09c7 \u098f\u09ac\u0982 \u098f\u099f\u09be \u0995\u09b2\u09be\u09ae \u0993 \u09b8\u09be\u09b0\u09bf \u09a8\u09bf\u09af\u09bc\u09c7 \u0997\u09a0\u09bf\u09a4 \u09b9\u09df\u0964 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099b\u0995 (table) \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 CREATE TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0986\u09ae\u09b0\u09be \u098f\u0996\u09a8 &#8220;MyGuests&#8221; \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u09cb \u09af\u09be\u09b0 &#8220;id&#8221;, &#8220;firstname&#8221;, &#8220;lastname&#8221;, &#8220;email&#8221; \u098f\u09ac\u0982 &#8220;reg_date&#8221; \u09a8\u09be\u09ae\u09c7 \u09aa\u09be\u0981\u099a\u099f\u09bf \u0995\u09b2\u09be\u09ae &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=6087\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[172],"tags":[307,305,1218,732,304,306],"class_list":["post-6087","post","type-post","status-publish","format-standard","hentry","category-----php-tutorial","tag-mysql","tag-php","tag-table","tag-732","tag-304","tag-306","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6091,"url":"http:\/\/bangla.sitestree.com\/?p=6091","url_meta":{"origin":6087,"position":0},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf &#8211; \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u09b6\u09c7\u09b7 \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u0995\u09c3\u09a4 \u09b0\u09c7\u0995\u09b0\u09cd\u09a1 \u098f\u09b0 \u0986\u0987\u09a1\u09bf \u09ac\u09c7\u09b0 \u0995\u09b0\u09be (PHP Get ID of Last Inserted Record in Bangla)","author":"Author-Check- Article-or-Video","date":"February 21, 2015","format":false,"excerpt":"auto-increment \u09ab\u09be\u0982\u09b6\u09a8 \u098f\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 \u09af\u09a6\u09bf \u0986\u09ae\u09b0\u09be \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u09af\u09cb\u0997 \u09ac\u09be \u09aa\u09b0\u09bf\u09ac\u09b0\u09cd\u09a4\u09a8 \u0995\u09b0\u09c7 \u09a5\u09be\u0995\u09bf \u09a4\u09be\u09b9\u09b2\u09c7 \u098f\u09b0 ID \u098f\u09b0 \u09a8\u09be\u09ae\u09cd\u09ac\u09be\u09b0\u099f\u09bf \u0986\u09ae\u09b0\u09be \u0985\u09a4\u09bf \u09a6\u09cd\u09b0\u09c1\u09a4\u0987 \u09aa\u09c7\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964 Phpmyadmin \u098f \u0997\u09bf\u09df\u09c7 \"MyGuests\" \u09a8\u09be\u09ae\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09bf \u0964 \u098f\u0996\u09be\u09a8\u09c7 \u0986\u0987\u09a1\u09bf \u0995\u09b2\u09be\u09ae \u09b9\u099a\u09cd\u099b\u09c7 AUTO_INCREMENT \u09ab\u09bf\u09b2\u09cd\u09a1: CREATE TABLE MyGuests ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6095,"url":"http:\/\/bangla.sitestree.com\/?p=6095","url_meta":{"origin":6087,"position":1},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf &#8211; \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b9\u09a4\u09c7 \u09a1\u09be\u099f\u09be \u09b8\u09bf\u09b2\u09c7\u0995\u09cd\u099f \u0995\u09b0\u09be  (PHP Select Data From MySQL in Bangla)","author":"Author-Check- Article-or-Video","date":"February 19, 2015","format":false,"excerpt":"select statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be \u09b8\u09bf\u09b2\u09c7\u0995\u09cd\u099f \u0995\u09b0\u09c7 \u09a1\u09bf\u09b8\u09aa\u09cd\u09b2\u09c7 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af Sql syntax SELECT column_name(s) FROM table_name \u0985\u09a5\u09ac\u09be \u0986\u09ae\u09b0\u09be \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf SELECT * FROM table_name \u00a0 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a6\u09bf\u09df\u09c7 \u098f\u09b0 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u09ac\u09cb\u099d\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u09ae\u09a4\u09a8 \u09ae\u09a8\u09c7 \u0995\u09b0\u09bf \u098f\u0987 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6097,"url":"http:\/\/bangla.sitestree.com\/?p=6097","url_meta":{"origin":6087,"position":2},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf &#8211; \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b9\u09a4\u09c7 \u09a1\u09be\u099f\u09be \u09a1\u09bf\u09b2\u09bf\u099f \u0995\u09b0\u09be  (PHP Delete Data From MySQL in Bangla)","author":"Author-Check- Article-or-Video","date":"February 18, 2015","format":false,"excerpt":"Delete statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a5\u09c7\u0995\u09c7 \u0995\u09cb\u09a8 \u09a1\u09be\u099f\u09be\u0995\u09c7 \u09ac\u09be\u09a6 \u09a6\u09bf\u09df\u09c7 \u09a6\u09c7\u09df\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u098f\u09b0 \u099c\u09a8\u09cd\u09af SQL SYNTAX \u09b9\u09b2 DELETE FROM table_name WHERE some_column = some_value \u09af\u0996\u09a8 \u0986\u09ae\u09b0\u09be where clause \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac \u09a8\u09be \u09b8\u09c7\u0987\u0996\u09c7\u09a4\u09cd\u09b0\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09b8\u09ac \u09a1\u09be\u099f\u09be \u09ac\u09be\u09a6 \u09b9\u09df\u09c7 \u09af\u09be\u09ac\u09c7\u0964 \u09af\u0996\u09a8 \u0986\u09ae\u09b0\u09be where \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac \u09a4\u0996\u09a8 \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u09a1\u09be\u099f\u09be \u09ac\u09be\u09a6\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6089,"url":"http:\/\/bangla.sitestree.com\/?p=6089","url_meta":{"origin":6087,"position":3},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf &#8211; \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2  \u098f \u09a1\u09be\u099f\u09be \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6 \u0995\u09b0\u09be\u09a8\u09cb (PHP Insert Data Into MySQL in Bangla)","author":"Author-Check- Article-or-Video","date":"February 22, 2015","format":false,"excerpt":"\u09b6\u09c7\u0996 \u09ae\u09be\u09b9\u09ab\u09c1\u099c\u09c1\u09b0 \u09b0\u09b9\u09ae\u09be\u09a8 \u00a0 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f \u09a1\u09be\u099f\u09be \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6 \u0995\u09b0\u09be\u09a8\u09cb \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u09ac\u0982 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be\u09b0 \u09aa\u09b0 \u0986\u09ae\u09b0\u09be \u09a4\u09be\u09a4\u09c7 \u09a1\u09be\u099f\u09be \u09af\u09cb\u0997 \u0995\u09b0\u09be \u09b6\u09c1\u09b0\u09c1 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09bf\u0964 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09af\u09c7\u09b8\u09ac \u09b8\u09bf\u09a8\u099f\u09c7\u0995\u09cd\u09b8\u099f-\u09a8\u09bf\u09df\u09ae \u0985\u09a8\u09c1\u09b0\u09b8\u09b0\u09a8 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0983 SQL \u0995\u09cb\u09df\u09be\u09b0\u09bf\u099f\u09bf \u0985\u09ac\u09b6\u09cd\u09af\u0987 PHP \u098f\u09b0 \u09ad\u09bf\u09a4\u09b0 \u0995\u09cb\u099f\u09c7\u09a1 \u09b9\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 SQL \u0995\u09cb\u09df\u09be\u09b0\u09bf\u09b0 \u09ad\u09c7\u09a4\u09b0 \u09b8\u09cd\u099f\u09cd\u09b0\u09bf\u0982 \u09ad\u09cd\u09af\u09be\u09b2\u09c1\u099f\u09bf\u2026","rel":"","context":"In &quot;\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial&quot;","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5949,"url":"http:\/\/bangla.sitestree.com\/?p=5949","url_meta":{"origin":6087,"position":4},"title":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint  . SQL Unique Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint RIAZ-UL-HAQUE MIAN \u0987\u0989\u09a8\u09bf\u0995 Constraint \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae \u098f\u09b0 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09a4\u09be\/ uniqueness \u0995\u09c7 \u09ac\u09c1\u099d\u09be\u09df . \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u09b8\u09c7\u099f \u0995\u09b0\u09b2\u09c7 \u09a4\u09be automatically \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09b9\u09df\u09c7 \u09af\u09be\u09df\u0964 \u09a4\u09be\u09b9\u09b2\u09c7 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8 \u09b9\u09b2\u09cb \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09a6\u09b0\u0995\u09be\u09b0 \u0995\u09bf ? \u0995\u09be\u09b0\u09a3 \u0986\u09aa\u09a8\u09bf \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a4\u09cd\u09b0 \u0995\u09b2\u09be\u09ae \u0995\u09c7 \u0987 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5931,"url":"http:\/\/bangla.sitestree.com\/?p=5931","url_meta":{"origin":6087,"position":5},"title":"SQL \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint . SQL Primary Key Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint RIAZ-UL-HAQUE MIAN \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf Constraint \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae \u098f\u09b0 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09a4\u09be\/ uniqueness \u0995\u09c7 \u09ac\u09c1\u099d\u09be\u09df . \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u0985\u09ac\u09b6\u0987 \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09a4\u09c7 \u09b9\u09ac\u09c7 \u098f\u09ac\u0982 NULL \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7\u09a8\u09be . \u09aa\u09cd\u09b0\u09a4\u09bf\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f \u0987 \u098f\u0995\u099f\u09be \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf key \u09a5\u09be\u0995\u09be \u0989\u099a\u09c0\u09a0 \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a4\u09cd\u09b0 \u0995\u09b2\u09be\u09ae \u0995\u09c7 \u0987 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/6087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6087"}],"version-history":[{"count":5,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/6087\/revisions"}],"predecessor-version":[{"id":9909,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/6087\/revisions\/9909"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6087"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}