write data from MySQL database

Question

I have been programming with asp for years now but I am very new to php.

I want to pull the data from the mysql database I created.

If I was to do the same job with asp;

<%
    Set ObjConn = CreateObject("ADODB.Connection")
    ObjConn.Open ("DRIVER={SQL Server};SERVER=serveraddress;DATABASE=databasename;UID=username;PWD=password")

SQL = "SELECT * FROM PRODUCTS ORDER BY PRODUCTNAME DESC" 
    Set objProducts = objConn.Execute(SQL)

    Do While not objProducts.EOF 
%>
<%=objProducts("PRODUCTNAME")%>
<%
    objProducts.MoveNext 
    Loop
%>

How do I do same thing with php?

OMG Ponies · Accepted Answer · 2011-01-12 05:05:37Z

2

Use:

<?php
  mysql_connect("serveraddress", "username", "password") or die("Could not connect: " . mysql_error());
  mysql_select_db("databasename");

  $result = mysql_query("SELECT PRODUCTNAME
                           FROM PRODUCTS 
                       ORDER BY PRODUCTNAME DESC");

  while ($row = mysql_fetch_array($result)) {
    echo $row["PRODUCTNAME"];
  }

  mysql_free_result($result);
?>

Recommendation

Never select columns that you will not use or display.

Reference:

answered Jan 12, 2011 at 5:05

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

write data from MySQL database

1 Answer 1

Recommendation

Reference:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Recommendation

Reference:

Comments

Your Answer

Sign up or log in

Post as a guest

Related