Difference between r1.4 and the current
@@ -1,31 +1,36 @@
* mysql °èÁ¤ °ü·Ã °íÄ¡±â
* POST ·Î °ª º¸³»±â ¾ÈµÇ´Â ¹®Á¦, ÄíÅ° ¾ÈµÇ´Â ¹®Á¦
* register_globals = off Àεí
* /etc/php.ini ˼ on
* /usr/local/lib/php.ini ˼ off
1. mysql °èÁ¤ °ü·Ã °íÄ¡±â
* ¼÷Á¦ ¼¹ö mysql ȯ°æ¿¡ ¸Â°Ô °èÁ¤À̸§, passwd µî ±³Ã¼
1. POST ·Î °ª º¸³»±â ¾ÈµÇ´Â ¹®Á¦, ÄíÅ° ¾ÈµÇ´Â ¹®Á¦
* ¿øÀÎ
* php.ini ÀÇ ¼³Á¤ÀÌ ´Ù¸§.
* register_globals = off Àεí
* /etc/php.ini ˼ on
* /usr/local/lib/php.ini ˼ off
* ÇØ°á
* ¾Æ·¡¿Í °°ÀÌ check.php, index.php ¿¡ Ãß°¡( º¸°í¼¿Í ´Þ¶óÁöÁö ¾Ê°Ô ÇÑÁÙ·Î Ãß°¡)
{{{$name = $_POST['name'];
* ¾Æ·¡¿Í °°ÀÌ check.php, index.php ¿¡ Ãß°¡( º¸°í¼¿Í ´Þ¶óÁöÁö ¾Ê°Ô ÇÑÁÙ·Î Ãß°¡)
{{{check.php ¿¡ Ãß°¡
$name = $_POST['name'];
$address = $_POST['address'];
$cardnumber = $_POST['cardnumber'];
$phonenumber = $_POST['phonenumber'];
$email = $_POST['email'];
$quantity = $_POST['quantity'];
$productInfo = $_POST['productInfo'];
$indexNumber = $_COOKIE['indexNumber'];}}}
{{{index.php ¿¡ Ãß°¡
$indexNumber = $_COOKIE['indexNumber'];}}}
* DB Çʵå ÂüÁ¶ Á¦´ë·Î ¾ÈµÇ´Â ¹®Á¦
1. DB Çʵå ÂüÁ¶ Á¦´ë·Î ¾ÈµÇ´Â ¹®Á¦
* ÀÌÀ¯ ºÒºÐ¸í
* ´Ù¸¥ ¼¹ö¿¡¼´Â ÀßµÊ
* ÇØ°á
* ¾Æ·¡¿Í °°ÀÌ °íħ
{{{index.php
* ¾Æ·¡¿Í °°ÀÌ °íħ(³¡¿¡ ÁÖ¼®Ã³¸®µÈ °ÍÀº ¿ø·¡ ÄÚµå)
{{{index.php
$ss = $row['SUM(ProductNum)']; echo "<td>$ss</td>";//echo "<td>$row[SUM(ProductNum)]</td>";
$sss = $row['SUM(ProductNum*ProductUnitPrice)']; echo "<td>$sss won</td>"; //echo "<td>$row[SUM(ProductNum*ProductUnitPrice)] won</td>";}}}
{{{admin.php
{{{admin.php
$ss = $row['SUM(ProductNum)']; echo "<td>$ss</td>"; //echo "<td>$row[SUM(ProductNum)]</td>";
$sss = $row['SUM(ProductNum*ProductUnitPrice)']; echo "<td>$sss won</td>"; //echo "<td>$row[SUM(ProductNum*ProductUnitPrice)] won</td>";}}}
- mysql °èÁ¤ °ü·Ã °íÄ¡±â
- ¼÷Á¦ ¼¹ö mysql ȯ°æ¿¡ ¸Â°Ô °èÁ¤À̸§, passwd µî ±³Ã¼
- POST ·Î °ª º¸³»±â ¾ÈµÇ´Â ¹®Á¦, ÄíÅ° ¾ÈµÇ´Â ¹®Á¦
- ¿øÀÎ
- php.ini ÀÇ ¼³Á¤ÀÌ ´Ù¸§.
- register_globals = off Àεí
- /etc/php.ini ˼ on
- /usr/local/lib/php.ini ˼ off
- ÇØ°á
- ¾Æ·¡¿Í °°ÀÌ check.php, index.php ¿¡ Ãß°¡( º¸°í¼¿Í ´Þ¶óÁöÁö ¾Ê°Ô ÇÑÁÙ·Î Ãß°¡)
check.php ¿¡ Ãß°¡
$name = $_POST['name'];
$address = $_POST['address'];
$cardnumber = $_POST['cardnumber'];
$phonenumber = $_POST['phonenumber'];
$email = $_POST['email'];
$quantity = $_POST['quantity'];
$productInfo = $_POST['productInfo'];
$indexNumber = $_COOKIE['indexNumber'];
index.php ¿¡ Ãß°¡
$indexNumber = $_COOKIE['indexNumber'];
- DB Çʵå ÂüÁ¶ Á¦´ë·Î ¾ÈµÇ´Â ¹®Á¦
- ÀÌÀ¯ ºÒºÐ¸í
- ´Ù¸¥ ¼¹ö¿¡¼´Â ÀßµÊ
- ÇØ°á
- ¾Æ·¡¿Í °°ÀÌ °íħ(³¡¿¡ ÁÖ¼®Ã³¸®µÈ °ÍÀº ¿ø·¡ ÄÚµå)
index.php
$ss = $row['SUM(ProductNum)']; echo "<td>$ss</td>";//echo "<td>$row[SUM(ProductNum)]</td>";
$sss = $row['SUM(ProductNum*ProductUnitPrice)']; echo "<td>$sss won</td>"; //echo "<td>$row[SUM(ProductNum*ProductUnitPrice)] won</td>";
admin.php
$ss = $row['SUM(ProductNum)']; echo "<td>$ss</td>"; //echo "<td>$row[SUM(ProductNum)]</td>";
$sss = $row['SUM(ProductNum*ProductUnitPrice)']; echo "<td>$sss won</td>"; //echo "<td>$row[SUM(ProductNum*ProductUnitPrice)] won</td>";