Member Avatar for jto

hello,
i am new in web developing , i want to develop a web sites in which when i will click a link or menu item i want to open a page , which will ask a question such as pls enter telephone no. to search , then it will search this no. in my access /sql database and then in next page it will shows all the information related to that phone no. stored in database , that is name , address , email id etc and even photographs which r saving in a file in jpg form , is any buddy will help , how i should start and from where i should start in easiest and efficient way because i have no knowledge . thanks

  • 3 Contributors
  • 6 Replies
  • 128 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Member #117553

Dani AI

Generated

A short, practical path to get a working "search by phone" page without diving into a full course: run a local webserver (Apache + PHP) so you can build and test, move or import your Access data into a simple SQL table (or keep Access and connect with ODBC), store photographs as JPG files in an images/ folder and store only the filename in the database. This produces a small, repeatable workflow you can extend as you learn; it also addresses the immediate goal described while reflecting the "start small" point made by and the realistic expectations noted by .

Install a local stack such as XAMPP and create one table (contacts) with fields like phone, name, address, email, photo. If you must keep Access, PHP can connect via ODBC (see odbc_connect in the PHP manual). For new projects, exporting Access to CSV and importing to MySQL/SQLite is simpler for web use.

Example files to get a working proof-of-concept:

A tiny search form:

<form method="get" action="result.php">
  <label>Phone: <input type="text" name="phone"></label>
  <input type="submit" value="Search">
</form>

A minimal PHP result script (use with PDO/MySQL; adjust credentials and table names):

<?php
$phone = preg_replace('/\D/', '', $_GET['phone'] ?? '');
if ($phone === '') { echo 'Enter phone.'; exit; }

$pdo = new PDO('mysql:host=localhost;dbname=yourdb;charset=utf8mb4','root','',[
  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);

$stmt = $pdo->prepare('SELECT name,address,email,photo FROM contacts WHERE phone = ?');
$stmt->execute([$phone]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);

if ($row) {
  echo htmlspecialchars($row['name']) . '<br>';
  echo htmlspecialchars($row['address']) . '<br>';
  echo htmlspecialchars($row['email']) . '<br>';
  if ($row['photo']) echo '<img src="images/' . rawurlencode($row['photo']) . '" alt="photo">';
} else {
  echo 'No record found.';
}
?>

Quick cautions and links: always validate and normalize the phone (the preg_replace above removes non-digits), use prepared statements to avoid SQL injection (see the PHP PDO prepared statements docs), and check file permissions and correct relative paths if images do not show. For ODBC with Access see the PHP odbc_connect reference and for HTML form basics see MDN Forms.

Recommended Answers

All 6 Replies

Member Avatar for tgreer

1. Learn HTML
2. Learn the basics of Database design
3. Learn SQL
4. Learn to write/communicate well

Member Avatar for jto

can u help me with some examples. in books it take to much time . thanks for relply

Member Avatar for tgreer

It's "you", not "u". You'll have to ask specific questions to get any meaningful help. For examples on HTML, you can use any web page. View the source, study it. Make copies and experiment.

Member Avatar for jto

ok sorry i will kept this mistakes in mind because in massanger we r using this type of character so i used here , and unfortunately i didn't read the massage from the forum.
from where i should start , waht type of soft ware is required and how i will start .

Member Avatar for tgreer

Right, this isn't Messenger. It's a forum for technical discussion. In order to communicate with each other, we have to be precise. To do that, we've decided that standard English is required.

To start learning HTML,

1. Get a good text editor. There are many. I like TextPad.
2. Read a good tutorial. You say you don't like books. Sorry, there are no shortcuts. Either get a book, or study HTML online.

I doubt anyone here is willing to give a complete breakdown on HTML to someone who isn't willing to take the time to crack open a book and study. I wish you well.

Member Avatar for Member #117553

Agree... There is no easy way to learn how things get done. Get buzy reading, be prepared to read constantly or just give it up and spend some bucks for someone to get your website done.
If you are going to code to make your living better get some books and prepare yourself for long hours of reading and exhausting countless attempts and questions like "OK, I did it right, why doesn't work!".
If you don't like this perspective- just give it up and save yourself some effort.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.