Anyone know how to do this?

tahj

Write a PHP program that does the following:

. it creates a database called "myfriends"
. it creates a table called "myfriends_table".
. "myfriends_table" has the following fields:
. fr_id smallint not null auto_increment primary key
. lastname varchar(14)
. fname varchar(14)
. city varchar(14)
. state varchar(2)
. it populates the table with 10 records

. After creating and populating the database, it displays the records in a tabular manner
. It also displays all of your friends from New York state

Thanks.

NogDog

Many people here know how to do that. However, most of us who have spent the time and effort to learn PHP and MySQL are not particularly inclined to do other people's homework assignments for them. If, on the other hand, you want to put some effort into doing as much of it as you can and then ask us for help in specific areas where you get stuck, then we'll be more than happy to help you after you show us the code you've created that is having the problem and explain what that specific problem is.

tahj

Ok. Here is what I worked on so far. Can you let me know if what I have so far is correct? Thanks.:

<!DOCTYPE html PUBLIC "-/W3C/DTD XHTML 1.0 Strict //EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml -strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head><title>My Friends database</title></head>
<body>
<?php

//create a connection

$connection = mysqli_connect("localhost", "tj", "team");
if ($connection)
echo "<h2>Connection to MySQL server established";
else
echo "<h2>No Connection established";

create database myfriends;

CREATE TABLE myfriends_table;
(
fr_id smallint not null auto_increment primary key,
lastname varchar(14),
fname varchar(14),
title varchar(30),
city varchar(14),
state varchar(2),

);

//selecting a database
$databasename = "myfriends";
$selectdB = @mysqli_select_db($connection, "myfriends") or die ("<h2>No Database selected</h2>" . "Error code " . mysqli_errno($connectd😎 . ": ". mysqli_error($connectd😎 . "</p>");
echo "<h2>We have selected the database myfriends</h2>";;

//looking for something in the database
$querystate = "SELECT * FROM myfriends WHERE City='New York'";
$queryresult = @mysqli_query($connectdB,$querystate) or die ("<h2>No query performed</h2>" . "<p>Error code ". mysqli_errno($connectd😎 . ". " .mysqli_error($connectd😎 . "</p>");
echo "<p>Query performed</p>";

?>

</body>
</html>

But I don't know how to do the parts that say:

"it populates the table with 10 records

. After creating and populating the database, it displays the records in a tabular manner

benracer

to start with this will not work...

if ($connection)
echo "<h2>Connection to MySQL server established";
else 
echo "<h2>No Connection established";

it needs to be...

if ($connection){
echo "<h2>Connection to MySQL server established";
}else{ 
echo "<h2>No Connection established";
}

this...
create database myfriends;

needs to be...

// create database myfriends

benracer

to add the data look at the foreach loop...
http://www.tizag.com/phpT/foreach.php

save all the data into an array then loop it through a foreach that contains a select query.

Kudose

benracer wrote:

to start with this will not work...

if ($connection)
echo "<h2>Connection to MySQL server established";
else 
echo "<h2>No Connection established";

it needs to be...

if ($connection){
echo "<h2>Connection to MySQL server established";
}else{ 
echo "<h2>No Connection established";
}

Yes it will.

Braces are not required on conditionals if one statement is made after it.

i.e.

if(1) echo 1; else echo 2;

Will work, but

if(1) echo 1; echo 3; else echo 2;

Will not.

tahj

benracer wrote:
to add the data look at the foreach loop...
http://www.tizag.com/phpT/foreach.php

save all the data into an array then loop it through a foreach that contains a select query.

How do I do that? Also how do I do the create records in 10 seconds? Thanks.

benracer

im sorry i dont understand where the 10 seconds comes in?

tahj

benracer wrote:
im sorry i dont understand where the 10 seconds comes in?

I'm sorry, I meant 10 records.

benracer

ok, what data do you want to insert and where is it coming from?

tahj

benracer wrote:
ok, what data do you want to insert and where is it coming from?

I just asked that since the work asks to populate the database with 10 records.

benracer

yes but what is going in these records?

tahj

benracer wrote:
yes but what is going in these records?

I could just add some names, and what city and state they live in.

benracer

ok, a loop will repeat until the command returns false. I dont understand why you need 10 records if you are going to " just add some names, and what city and state they live in"?

tahj

benracer wrote:
ok, a loop will repeat until the command returns false. I dont understand why you need 10 records if you are going to " just add some names, and what city and state they live in"?

Thats what the prof wrote.

benracer

Thats what the prof wrote. what does this mean?

tahj

benracer wrote:
Thats what the prof wrote. what does this mean?

He put that in the assignment. In class, this is supposed to be a web design class, that comes after what we learn for HTML, and XHTML. I don't like programming, especially this. Thats why I have trouble doing it.

Kudose

Why are you taking web design classes if you don't like programming? XHTML is technically programming.

tahj

Kudose wrote:
Why are you taking web design classes if you don't like programming? XHTML is technically programming.

I didn't know that PHP was like this. In the class before this one that I am in now, we learned html. Now this class is about php. Plus, there aren't many options of classes for me to take.

tahj

Is my code pretty much done?