inserting multiple records into a db by way of a cms

[trufla]

Could someone help, I am not sure if this is a php problem or a MySQL issue.

I have a table in a db called issues (as in comics). a record contains fields of info like release date, genre, title.

I display the latest 5 issues at a time in a webpage.
I want to be able to update the db by means of a form in the web page that you log into (say an administrator).
This way you need never go into the database (cms).

The problem is I do not know how I would go about inserting 5 records at once (so they do not overwrite each other) and specifying that the latest 5 be displayed in the webpage.

I have only inserted a single record up to now and specified the newest record be displayed in the webpage.

Any help appreciated!

trufla

[ZibingsCoder]

Alright, for starters, when you use the INSERT syntax in any SQL environment, it does not overwrite -anything-. With that in mind, you might just want to add a few fields to your database. Two that would help you the most would be an auto_increment field, and a timestamp field.

CREATE TABLE `table` (
   `id_field` int(4) not null auto_increment,
   `date_field` int(11) not null,
   primary key `id_field` (`id_field`)
);

The only one that you -really- need for your purposes is the date field, so you can just ignore the other two lines around it if you'd like.

When you do an insert query in PHP, you would make the date field...

$str = "INSERT INTO `table` (`date_field`) VALUES ('".time()."')";

And then to retrieve...

$str = "SELECT * FROM `table` ORDER BY `date_field` DESC LIMIT 0,5";

That will get you the most recent 5 posts.

Hope this helps.

[trufla]

Cheers mate!

Will give that a go!

[trufla]

ZibingsCoder, excuse my stupidity but,

I did what you said as far as I can see, in my table (changed name to releases) I created a field called "Date_field".

I then updated the insert code to this:

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "releases_frm")) {
  $insertSQL = sprintf("INSERT INTO releases (Artist, Title, Description, ReleaseUser, Date_field) VALUES (%s, %s, %s, %s, '".time()."')",
                       GetSQLValueString($HTTP_POST_VARS['releasesArtist'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['releasesTitle'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['releasesDesc'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['releasesUser'], "text"));

I checked "Date_field" in the db and I get value like this:

1093426201

I then went to by releases page to update the SELECT code:

<?php require_once('Connections/xxxxdb.php'); ?>
<?php
mysql_select_db($database_xxxxdb, $xxxxdb);
$query_releases = "SELECT * FROM releases ORDER BY 'Date_field' DESC LIMIT 0,5";
$releases = mysql_query($query_releases, $xxxxdb) or die(mysql_error());
$row_releases = mysql_fetch_assoc($releases);
$totalRows_releases = mysql_num_rows($releases);
?>

Do I need to create more of these recordsets to display 5 recent posts? Is there anything else I should be doing?

[SumitGupta]

Hi..

Well I Read your problem and want to give a new Idea (basically new coding) Correct me if you I understood it wrong..

First YOu want:

To insert 5 record in a table at once for the Issues of magzine any name , genre and other stuff

Second you want ot display the top 5 (according to latest issue date)

Than it is quite simple....
Your soultion is here

Just make a HTML page which accept the Issue Data name, publication etc...

Make a Database table relative to it....with two extra column serialNo, DateInserted(You can use the Daterelease if you want)

Than run a while loop for the Form (HTML that u create to take entry from user)

In that take value from one set of the Textboxes... and create a custom query like

insert into <tablename> values  "","$txtname1","$txtauthor1",...");

Similarly display them

Hope u understand it...and that i am giving you right answer

[trufla]

Originally posted by SumitGupta
Hi..

Well I Read your problem and want to give a new Idea (basically new coding) Correct me if you I understood it wrong..

First YOu want:

To insert 5 record in a table at once for the Issues of magzine any name , genre and other stuff

Second you want ot display the top 5 (according to latest issue date)


Than it is quite simple....
Your soultion is here

Just make a HTML page which accept the Issue Data name, publication etc...

Make a Database table relative to it....with two extra column serialNo, DateInserted(You can use the Daterelease if you want)

Than run a while loop for the Form (HTML that u create to take entry from user)

In that take value from one set of the Textboxes... and create a custom query like

insert into <tablename> values  "","$txtname1","$txtauthor1",...");

Similarly display them

Hope u understand it...and that i am giving you right answer [/B]

I do not really understand, but thanks for the post. The most important thing for me at the moment is so display the most recent posts in the page.

I could live without the multiple inserts for now I guess.

I liked the SQL

"SELECT * FROM `table` ORDER BY `date_field` 
DESC LIMIT 0,5";

Because it was fairly simple to read (good for my level at this point).

How can I display 5 recent posts with this?

[SumitGupta]

Hi..

Yes You haven't it properly..

Read it now..

After that you execute your query the code is something like this

$r=mysql_query("Select * from......");//Ur SQL query here
if ($r)//Check if query executes
{
if (mysql_num_rows($r)>0) //See if record found 
{
while($row=mysql_fetch_array($r)) //Fetch asingle row at a time
{
//Code to display data goes here
//Use $row[<cloumnname>] or $row[columnindex] to fetch record say "PHP Tutorial by Sumit Gupta" 
}
}
else
{
echo "no record found";
}
}

I hope you get the code you want I just use while loop and fetch a single row from the select query that u execute and display it in code(incomplete though)

[trufla]

Originally posted by SumitGupta
Hi..

Yes You haven't it properly..

Read it now..

After that you execute your query the code is something like this

$r=mysql_query("Select * from......");//Ur SQL query here
if ($r)//Check if query executes
{
if (mysql_num_rows($r)>0) //See if record found 
{
while($row=mysql_fetch_array($r)) //Fetch asingle row at a time
{
//Code to display data goes here
//Use $row[<cloumnname>] or $row[columnindex] to fetch record say "PHP Tutorial by Sumit Gupta" 
}
}
else
{
echo "no record found";
}
}

I hope you get the code you want I just use while loop and fetch a single row from the select query that u execute and display it in code(incomplete though)

OK, I kind of understand what you mean, but I am a newbie. alot of the problems I have is translating variables and understanding the constructs of other peoples examples:

while loop sounds like a good idea, but how do I translate:

mysql_select_db($database_gymtvdb, $gymtvdb);
$query_releases = "SELECT * FROM releases ORDER BY 'Date_field' DESC LIMIT 0,5";
$releases = mysql_query($query_releases, $gymtvdb) or die(mysql_error());
$row_releases = mysql_fetch_assoc($releases);
$totalRows_releases = mysql_num_rows($releases);
?>

into your while loop example?

What varibles are you using in comparision to mine?

[SumitGupta]

Hi..

how r u?

See Teh code you are using is not much different from mine... The code you give is right and I just try to put my code in the last two lines that you use in your code...

code by u

$row_releases = mysql_fetch_assoc($releases);
$totalRows_releases = mysql_num_rows($releases);

Change it with this one

echo "<table>";
while($row_releases=mysql_fetch_array($releases))//Same except that I wirte it in while loop
{
  //Now the first row return by the SQL query is in $row_releases which is an array of the Table data in HTML or Columns value like name of book not the Column Name.
//The first element of the $row_releases is the first column u have in your database
//hence use the $row_releases with the index number int he order you want to show value
//Example I am using it in a table tag of html
echo "<tr><td>$row_releases[0]</td><td>$row_releases[1]</td></tr>";
}
echo "</table>";

I hope this will solve the problem.. You need to learn php and HTML and the logics for the programming (the most important thing)...

Bye..