[Ghazal]

Hello there,

I have got a question .. Which i don't know if i am allowed to post it here or no, anyways i will give it a try.

I am a newbie in PHP.

I was wondering if there is tutorials like showing ban list from mysql using php or an exmaple for it?

Thanks for reading ...

[Kyle]

http://www.w3schools.com/sql/sql_select.asp

http://php.net/manual/en/function.mysql-fetch-array.php

[Ghazal]

Quote:

Originally Posted by KyleSmith http://www.w3schools.com/sql/sql_select.asp http://php.net/manual/en/function.mysql-fetch-array.php

I would like an example script, so i can understand.

[Kyle]

Quote:

Originally Posted by Maro06 I would like an example script, so i can understand.

The examples are in both pages. Just adapt it to your database structure.

Basically, you're asking for an 'example script' so you don't have to do anything and just copy that one.

[Ghazal]

Quote:

Originally Posted by KyleSmith The examples are in both pages. Just adapt it to your database structure. Basically, you're asking for an 'example script' so you don't have to do anything and just copy that one.

lol.

Actually, how can i even understand from that 2 pages? And i am not going to copy, I will make one by my self, if you don't want to help just dont reply.

[Kyle]

Код:

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
    die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    printf ("ID: %s  Name: %s", $row[0], $row["name"]);
}

mysql_free_result($result);
?>

[TakeiT]

You should use Mysqli, not mysql. Mysql is depreciated.

[iFarbod]

Use PDO, Or MySQLi

[Kyle]

Quote:

Originally Posted by TakeiT You should use Mysqli, not mysql. Mysql is depreciated.

Quote:

Originally Posted by iFarbod Use PDO, Or MySQLi

Код:

<?php
    $con = new mysqli("localhost", "mysql_user", "mysql_password");
    if ($mysqli->connect_errno) { printf("Connect failed: %s\n", $mysqli->connect_error); exit(); }

if($result = mysqli_query($con, "SELECT id, name FROM mytable"))
{

while ($row = mysqli_fetch_assoc($result)) {
    printf ("ID: %s  Name: %s", $row["id"], $row["name"]);
}

mysqli_free_result($result);

}
mysqli_close($con);
?>

[KingHual]

Quote:

Originally Posted by KyleSmith http://www.w3schools.com/sql/sql_select.asp http://php.net/manual/en/function.mysql-fetch-array.php

Using mysql_* is bad practice as it's not safe, though. They should either use mysqli_* or PDO.