PHP Session 9 My SQL Database sql CREATE

PHP Session 9

My. SQL ﺩﺭ Database ﺳﺎﺧﺖ یک $sql = "CREATE DATABASE `university`"; $query = mysql_query($sql, $my_connection); پﺎﺭﺍﻣﺘﺮ ﻭﺭﻭﺩی 2 ﻣﺘﺪی ﺟﻬﺖ ﺍﺭﺳﺎﻝ ﺩﺭﺧﻮﺍﺳﺖ ﺑﺎ if ($query) { ﻧﺎﻡ ﺩیﺘﺎﺑیﺲ ﻣﻮﺭﺩ ﻧﻈﺮ echo "New Database Created!"; } else { echo "Failed to create a new database. "; }

My. SQL ﺩﺭ Database ﺍﻧﺘﺨﺎﺏ یک $query = mysql_select_db(" university ", $my_connection); if ($query) { ﻧﺎﻡ ﺩیﺘﺎﺑیﺲ echo "Database Selected!"; ﺍﺭﺗﺒﺎﻁ } else { echo "Failed to select the database. "; }

My. SQL ﺳﺎﺧﺖ یک ﺟﺪﻭﻝ ﺩﺭ $query = mysql_select_db("university", $my_connection); ﻧﺎﻡ ﺟﺪﻭﻝ ﻓیﻠﺪ ﻫﺎی ﺟﺪﻭﻝ if ($query) { $sql = "CREATE TABLE `new_table` (`id` INT AUTO_INCREMENT PRIMARY KEY, `username` VARCHAR(255), `password` VARCHAR(255))"; ﺑﻪ ﺻﻮﺭﺕ ﺧﻮﺩکﺎﺭ id ﺍﻓﺰﺍیﺶ ﺗﻨﻈیﻢ ﺑﻪ ﻋﻨﻮﺍﻥ کﻠیﺪ ﺍﺻﻠی $create_db = mysql_query($sql, $my_connection); if ($create_db) { echo "Table Created!"; } else { echo "Failed to create the table. "; }

My. SQL ﻧﺤﻮﻩ ﺛﺒﺖ ﺍﻃﻼﻋﺎﺕ ﺩﺍﺧﻞ ﺟﺪﺍﻭﻝ ﺩﺭ . ﺍﺳﺘﻔﺎﺩﻩ ﻧﻤﻮﺩ INSERT ﺑﺮﺍی ﻭﺍﺭﺩ کﺮﺩﻥ ﺩیﺘﺎ ﺩﺍﺧﻞ ﺟﺪﻭﻝ ﻣی ﺑﺎیﺴﺖ ﺍﺯ ﺩﺳﺘﻮﺭ $query = mysql_select_db("university", $my_connection); if ($query) { $sql = "INSERT INTO `university`. `lesson` (`id` , `name` , `unit`) VALUES ('1', 'zakhire', '3')"; $insert_into_db = mysql_query($sql, $my_connection); if ($insert_into_db) { echo "Data recorded!"; } else { echo "Failed to record the data. "; } }

My. SQL ﺣﺬﻑ ﺩﺍﺩﻩ ﻫﺎ ﺍﺯ ﺟﺪﺍﻭﻝ ﺩﺭ . ﺍﺳﺘﻔﺎﺩﻩ ﻧﻤﻮﺩ DELETE ﻣی ﺑﺎیﺴﺖ ﺍﺯ ﺩﺳﺘﻮﺭ ، ﺑﺮﺍی ﺣﺬﻑ یک ﺭکﻮﺭﺩ ﺍﺯ ﺩﺍﺧﻞ ﺟﺪﻭﻝ $query = mysql_select_db("university", $my_connection); if ($query) { $sql = "DELETE FROM `lesson` WHERE `id` = '3'"; $deletion = mysql_query($sql, $my_connection); if ($deletion) { echo "Record Deleted!"; } else { echo "Failed to delete the record. "; }

( )ﺍﺩﺍﻣﻪ My. SQL آپﺪیﺖ کﺮﺩﻥ ﺍﻃﻼﻋﺎﺕ ﺩﺍﺧﻞ ﺟﺪﺍﻭﻝ ﺩﺭ $query = mysql_select_db("university", $my_connection); if ($query) { $sql = "UPDATE `lesson` SET `name` = 'new_name', `unit` = 'new_unit' WHERE `id` = '2'"; $update = mysql_query($sql, $my_connection); if ($update) { echo "Record Updated!"; } else { echo "Failed to update the record. "; }