<?php
    $dbhost = "192.168.0.1";
    $dbusername = "user_name";
    $dbpassword = "password";
    $dbname = "dbname";

    $connection = mysql_connect($dbhost, $dbusername, $dbpassword) or die('Could not connect');
    $db = mysql_select_db($dbname);


//    아래와 같이 해도 작동 함
// $connect = mysql_connect("192.168.0.2","root","1234");
// $db_con = mysql_select_db("todayprice",$connect);
// mysql_query("set names utf8");
?>



여러줄 불러오기

$sql ="select product_int, product_name from aaa"
$result = mysql_query($sql, $connection);
while($row=mysql_fetch_array($result)){
?>
<?php echo $row["product_int"]?>
<?php echo $row["product_ㅜ믇"]?>
<?php
}
?>



한줄 불러오기

$sql = "select * from tp_mart where mart_int ='$mart_int'";
$result = mysql_query($sql,$connection);
$row=mysql_fetch_array($result);
echo $row[tel2];



입력하기

$sql = "update tp_my_cart set cart_count = $cart_count where cart_int = $cart_int and user_id = '$mb_id'";
sql_query($sql);

include_once('common.php');

$sql = " select count(*) as countt from member ";
$sql_one = sql_fetch($sql);
echo $sql_one["countt"];

$result = sql_query($sql);
while ($row = sql_fetch_array($result)){
echo $row['countt'];
}



$sql = "update tp_my_cart set cart_count = $cart_count where cart_int = $cart_int and user_id = '$mb_id'";
sql_query($sql);