php help

[Love kolla]

Ai ban mehema wenne.. meke connection ek hondata wenoo.. table eken select krna eke mkakd magul error ekak enoo.. ai bn ee??

http://imgur.com/KrgMXeH
http://imgur.com/t66Kr9U

Meke mchan ,

mysqli_num_rows()

mysqli_fetch_assoc()

Use karath oya error ek ee widiytama enawa ban

 

[dildude]

 

[3rdEye]

connection එක හැදුවට db එක select කරලා කෝඩ් එකක් ලියලා නැනේ

 

[Love kolla]

Thanx dildude

 

[Love kolla]

connection එක හැදුවට db එක select කරලා කෝඩ් එකක් ලියලා නැනේ

Ai mchan $con variable eken mn database ekath connect krla thiyenawne.. $db kiynne database eke variable ek.. Mysqli walin puluwn ne bn ehem kr..
Ehema nattn kiypnko kohomada meka hariyata hadaganne kyla?

 

[3rdEye]

Ai mchan $con variable eken mn database ekath connect krla thiyenawne.. $db kiynne database eke variable ek.. Mysqli walin puluwn ne bn ehem kr..
Ehema nattn kiypnko kohomada meka hariyata hadaganne kyla?

mysqli_num_rows()

ඔන්න වැරැද්ද උබ දාලා තියෙන්නේ old එක

mysqli_fetch_assoc()

මේකත්

 

[dakshina11]

machan "mysql_num_rows" kiyanne mysqli library eke function ekak nemei.

http://php.net/manual/en/function.mysql-num-rows.php

 

[Love kolla]

Eth machan.. Mysqli dammath oy error ekama enawane

 

[dakshina11]

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

if ($result = mysqli_query($link, "SELECT Code, Name FROM Country ORDER BY Name")) {

    /* determine number of rows result set */
    $row_cnt = mysqli_num_rows($result);

    printf("Result set has %d rows.\n", $row_cnt);

    /* close result set */
    mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

 

[Love kolla]

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

if ($result = mysqli_query($link, "SELECT Code, Name FROM Country ORDER BY Name")) {

    /* determine number of rows result set */
    $row_cnt = mysqli_num_rows($result);

    printf("Result set has %d rows.\n", $row_cnt);

    /* close result set */
    mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

Ithn bn dn methanin pxe database eke thiyena ewa print krgnne kohomada bn??