DB 문제도와주세여ㅜㅜ!! 정보
DB 문제도와주세여ㅜㅜ!!본문
memo_insert.php_________________________________________________________________________
<input type="text" name="f_text">
<input type="submit" name="f_click" value="환자조회">
<br>
</br>
<form method = "get" action = <?= $_SERVER['PHP_SELF'] ?> >
<table border=1 align=left width = 300>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">환자번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bunho" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">환자명</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="name" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">주민번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="jumin" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">성별</td>
<td align="left" valign="middle" style="width:100px;height:50px;" valign="bottom">
<input name="sex" type="radio" class="male" value="남자">남
<input name="sex" type="radio" class="female" value="여자">여</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">요양등급</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="level" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">보험유형</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bohum" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">전화번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="tel" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">주소</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="add" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">종교</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="god" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">직업</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="job" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">특이사항</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="memo" style="width:150px;"></td>
</tr>
<table border=1 align=left width =350>
<tr>
<td valign="middle" style="font-size:13px;width:400px;height:50px;">보호자명</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="boho" name="9" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:400px;height:50px;">보호자주민번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="bohojumin" name="10" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">성별</td>
<td align="left" valign="middle" style="width:100px;height:50px;" valign="bottom">
<input name="sexx" type="radio" class="male" value="남자">남
<input name="sexx" type="radio" class="female" value="여자">여</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">환자와의 관계</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="rel" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">보호자 전화번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="hp" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">보호자주소</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bohoadd" style="width:150px;"></td>
</tr>
<tr>
<td align="left" valign="middle" style="width:400px;height:50px;" valign="bottom">
<input name="no" type="radio" class="female" value="여자">보호자없음</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">입원일</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="date" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">병실</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="room" style="width:150px;"><td align="center" valign="middle" colspan="2">
<table border=1 align=left width =100>
<input type="submit" value="병실현황"></td>
</tr>
</table>
<tr>
<td align="center" valign="middle" colspan="2"><input type="submit" value="저장"></td>
</td>
</tr>
</table>
</table>
</form>
zz.php___________________________________________________________________________________
<p><input type="text" name="f_text">
<input type="submit" name="f_click" value="환자조회"></p>
<table border=1 align=left width = 850>
<tr bgcolor = white>
<td colspan=7 align=center><b>환자 명단 보기</b></td>
</tr>
<tr align=center >
<td width=120>환자번호</td>
<td width=120>환자이름</td>
<td width=120>성별</td>
<td width=120>병실</td>
<td width=120>입원일</td>
<td width=120>간병인</td>
<td width=150>보호자정보</td>
</tr>
!!!!!!!!!!!!!!위에파일이 memo파일이고 아래파일이 zz파일입니다ㅜㅜ
memo에서 입력된 값이 저장을 누른 후 zz파일에 보여지게 됩니다(memo와 zz는 다른페이지에 있음)
데이터베이스 어떻게하나요ㅜㅜ?
DB생성과 테이블 만드는것까지는 알겠는데
각각 필드값을 정하고 거기서부터 막혀서 잘 안되네요
ㅜㅜ제발 도와주세요!!
<input type="text" name="f_text">
<input type="submit" name="f_click" value="환자조회">
<br>
</br>
<form method = "get" action = <?= $_SERVER['PHP_SELF'] ?> >
<table border=1 align=left width = 300>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">환자번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bunho" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">환자명</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="name" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">주민번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="jumin" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">성별</td>
<td align="left" valign="middle" style="width:100px;height:50px;" valign="bottom">
<input name="sex" type="radio" class="male" value="남자">남
<input name="sex" type="radio" class="female" value="여자">여</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">요양등급</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="level" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">보험유형</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bohum" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">전화번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="tel" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">주소</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="add" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">종교</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="god" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">직업</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="job" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:100px;height:50px;">특이사항</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="memo" style="width:150px;"></td>
</tr>
<table border=1 align=left width =350>
<tr>
<td valign="middle" style="font-size:13px;width:400px;height:50px;">보호자명</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="boho" name="9" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:400px;height:50px;">보호자주민번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="bohojumin" name="10" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:300px;height:50px;">성별</td>
<td align="left" valign="middle" style="width:100px;height:50px;" valign="bottom">
<input name="sexx" type="radio" class="male" value="남자">남
<input name="sexx" type="radio" class="female" value="여자">여</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">환자와의 관계</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="rel" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">보호자 전화번호</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="hp" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">보호자주소</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="bohoadd" style="width:150px;"></td>
</tr>
<tr>
<td align="left" valign="middle" style="width:400px;height:50px;" valign="bottom">
<input name="no" type="radio" class="female" value="여자">보호자없음</td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">입원일</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="date" style="width:150px;"></td>
</tr>
<tr>
<td valign="middle" style="font-size:13px;width:120px;height:50px;">병실</td>
<td align="left" valign="middle" style="width:400px;height:50px;"><input type="text" name="room" style="width:150px;"><td align="center" valign="middle" colspan="2">
<table border=1 align=left width =100>
<input type="submit" value="병실현황"></td>
</tr>
</table>
<tr>
<td align="center" valign="middle" colspan="2"><input type="submit" value="저장"></td>
</td>
</tr>
</table>
</table>
</form>
zz.php___________________________________________________________________________________
<p><input type="text" name="f_text">
<input type="submit" name="f_click" value="환자조회"></p>
<table border=1 align=left width = 850>
<tr bgcolor = white>
<td colspan=7 align=center><b>환자 명단 보기</b></td>
</tr>
<tr align=center >
<td width=120>환자번호</td>
<td width=120>환자이름</td>
<td width=120>성별</td>
<td width=120>병실</td>
<td width=120>입원일</td>
<td width=120>간병인</td>
<td width=150>보호자정보</td>
</tr>
!!!!!!!!!!!!!!위에파일이 memo파일이고 아래파일이 zz파일입니다ㅜㅜ
memo에서 입력된 값이 저장을 누른 후 zz파일에 보여지게 됩니다(memo와 zz는 다른페이지에 있음)
데이터베이스 어떻게하나요ㅜㅜ?
DB생성과 테이블 만드는것까지는 알겠는데
각각 필드값을 정하고 거기서부터 막혀서 잘 안되네요
ㅜㅜ제발 도와주세요!!
댓글 전체