Log In
Sign Up
Jobs
Job Search
Explore all available job openings across industries and locations.
Company Search
Find your dream jobs categorized by company names.
Themed Jobs
Discover job opportunities organized by specific themes or industries.
Download our App
Tools
Resume
Create your job-winning resume using our free resume builder.
Portfolio
Showcase your skills and projects with a professional portfolio.
Resume
Create your job-winning resume using our free resume builder.
Resume Builder
Make a resume for free.
Resume Templates
Access our extensive library of professional & ready-to-use templates.
Resume Examples
Get inspired by real resume examples to create your own.
Occupation Guide
Access resume writing guides tailored for different professions.
Resume Help
Get expert advice on all things resume from our team of recruitment specialists.
Portfolio
Showcase your skills and projects with a professional portfolio.
Portfolio Maker
Create a professional portfolio to highlight your skills and projects.
Portfolio Gallery
Browse through our collection of real portfolios for inspiration and networking.
Resources
Articles
Read insightful articles on career development, job search strategies, and more.
View All Articles
Job Search Guide
Resume & CV
Cover Letter
Portfolio
Interview Skills
Job Search Tips
Industry & Job Overview
Career Guidance
Career Planning
Career Tools
Career Development
Personal Branding
Success Stories
Success Stories
Business Excellence
People Operations
Recruitment & HR
About CakeResume
People & Culture
News & Updates
Events
Featured Reads
Resume & CV
What to Write in an Email When Sending a Resume [+ Examples & Tips]
Read More
Hire
Talent Search
Find Resumes.
Job Posting
Start for Free.
Recruitment Service
Acquire Talent.
Employer of Record (EOR)
Empower Your Business in Taiwan.
Employer Branding
Build and promote your employer brand.
Pricing
Job Posting Plans
Talent Search Plans
Resume Builder Plans
Build your Network
My Network
Access your personal network connections and manage your contacts.
CakeResume Meet
Expand your professional network by meeting and connecting with other users.
Community
Engage with other users through discussions, forums, and networking events.
Download our App
Build your Network
My Network
Access your personal network connections and manage your contacts.
CakeResume Meet
Expand your professional network by meeting and connecting with other users.
Community
Engage with other users through discussions, forums, and networking events.
Log In
Sign Up
Portfolios
蔡智丞
phpMyAdmin建立資料庫過程成果展示
phpMyAdmin建立資料庫過程成果展示
phpMyAdmin建立資料庫過程成果展示
By
蔡智丞
碩士
・
Pingtung County, Taiwan
Connect
phpMyAdmin建立資料庫並連接到MySQL過程成果展示
建立資料庫
首先打127.0.0.1/phpmyadmin 進去登入畫面
進去會要求密碼(打剛剛MYSQL上面的帳號與密碼
使用者名稱:root 密碼:設定的密碼)
登入之後會進到appserv的主畫面 接下來就是開始建立資料庫
從主畫面有一個資料庫的選項 點擊進去
進去後所有建立的資料庫名稱都在這裡
(這些都是我之前建好的資料庫)
滑鼠拉到最下面有一個建立新資料庫(左邊第一個欄位是你要建立資料庫的名稱欄位)
建立好之後appserv會告訴你這個資料庫已經建立完成
之後左邊的資料庫選項拉下來找到剛剛建立好的資料庫點下去(會顯示說資料庫裡面還尚未建立資料表)
(
一定要建立不然資料庫裡面沒有資料!
)
欄位數目是裡面要有幾個資料表,假如10個最多就只有10個資料表名稱跟欄位數目,確認完點擊執行
一開始要先新增好資料庫才會記錄資料 比如我的資料庫是123 資料表為mysql 那程式回傳方面就要設定mysql這個資料表的名稱
會員資料表所需要的資料行名稱、資料型態
確認完成之後點擊儲存
建立完成後的畫面 左邊就會出現mysql的資料表了
這是新增功能所需要的欄位
還要回傳 register_finish.php
這程式是再做回傳mysql跟appserv的欄位才能夠記錄資料
php必須回傳到appserv裡面的資料庫所以要做一個程式讓mysql能夠讀取到欄位
include這行指令可以將PHP文件的內容插入到另一個
PHP文件
$name=$POST[‘NAME’]是回傳NAME這個值
$sql = "insert into member_table(username... ) values ( '$id', '$pw',)";
是把輸入的資料新增到member_table資料表裡面
if(mysql_query($sql)
echo ‘新增成功’
如果新增成功就回傳到index.php顯示新增成功的畫面
如果沒有新增成功或新增失敗就回傳"您無權觀看此頁面"
這裡展現的是我自己使用過phpMyAdmin的經驗以及架設本機網站成果,使用PHP撰寫後端程式,利用MySQL連接應用。 撰寫PHP工具是Notepad++
Report
Please login to comment.
Post
蔡智丞
Connect
Published: Jul 3rd 2022
65
2
0
Tools
MySQL
PHP
Apache
apache
mysql
phpMyAdmin
PHP
Share
Other works from
蔡智丞
網頁後端功能圖
Java作品(程式碼)
AI繪圖作品以及心得
JAVAプログラムを日本語で説明します。(練習)
PHPのGETとPOSTコマンドを日本語で說明します。(練習)
Linux建立網路卡指令