How to display and be able to delete them in MySql

Ive added my picture in database, but now I want to display them and be able to delete them.My database name is cms, my table is babies and my column is pic_name(contains a path and image name)

Jul 3 '14 #1

Subscribe Post Reply

1022

sankobe

Here is my code for displaying images from cms :

Expand|Select|Wrap|Line Numbers

 <html>

   <head>

     <title>Delete Images</title>

      <meta http-equiv="Content-Type" content="text/html; charset=isc-8859-1">

    </Head>

  <body>

 <?php

 include("mysqlconnect.php"); 

 $res=mysql_query("select * from babies");

 echo "<table>";

 while($row=mysql_fetch_array($res))

 {

   echo "<tr>";

   echo "<td>";?><img src="<?php echo $row["pic_name"]; ?>" height="100" width="100"> <?php echo "</td>";
 
   echo "</tr>";

 }

 echo "</table>";

 ?>  

  </body>

 </html>

Jul 3 '14 #2

Dormilich

8,658

Expert Mod 8TB

you delete the images by selecting the image by ID (which you have to fetch from the DB as well), go to the denoted resource (the actual image), delete it from the FS, and then delete the DB entry of said ID. (this would make sure you have no unrecognised (by the DB) images. if you reverse the order (first delete in the DB, then in the FS) you may have leftover images, but also no broken links.

Jul 4 '14 #3

Similar topics

how to display newly added mysql column

by: kindermaxiz | last post by:

hi there i have a mysql table and i want the user to add columns using a php interface and then display the table with the newly added column. I was thinking about putting all the columns...

PHP

Delete MySql Rows Problem

by: imarkdesigns | last post by:

Hello everyone.. a newbie programmer here wants to ask why is my codes for deleting rows from my databse won't work.... seems that this codes spread to the net and no one refuse to correct it... ...

MySQL Database

Delete mysql records with array_diff

by: pezholio | last post by:

Hi, I'm trying to put together a page that deletes records from a database based on if an item is unticked, I've got the existing items in an array (let's call it array1 for the sake of argument):...

PHP

Help Using Checkboxes to delete MySQL Rows.

by: recordlovelife | last post by:

Hey guys, ill try to make this simple. I want to make a GUI for a client so that they can delete news entries that they have posted. I figure I can code a site that will query the table for the news...

PHP

display data from mysql array one row at a time

by: wadro21 | last post by:

Hello everyone, i am trying to pull from a myql database all records from a table with multiple rows. i need to be able to call the data from each row one by one i would asume from an array. the...

PHP

display image from mysql(blob data)

by: foss | last post by:

HI all, I am able to upload the image as blob to mysql. but while displaying the image i cant display it properly . The code used for uploading image to mysql inserts data into mysql table.The...

PHP

How to display messages from mysql database in rows?

by: ashfaqbinnazar | last post by:

Dear friends, How can i display messages from mysql database in each rows with delete and reply button. Thanks in advance. Here is my code. i have created a page like scrapbook. and splitted the...

PHP

PHP Script for Datepicker to slect and display database from Mysql required

by: prakashghai | last post by:

After spending 3 days on internet and struggling with so many different forums , i have found a match and similar case of my problem here. Friends, I am zero in PHP, but still i have managed to do...

PHP

Need to delete MySQL records from a table that are older than 700 days

by: DTeCH | last post by:

Hello all, I need to delete records from a table in a MySQL database that are more than 700 days old. There is a column with the time of the record's entry "pPostDate", & the dates are in RFC...

MySQL Database

How to display images from mysql table at below after selection of dropdown category

by: Monomita Har | last post by:

I want to show a category based shopping items with images on web page that can be found in the most Online shopping sites.I crated two mysql tables: Ist with id, category_name and 2nd with id,...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice