Database_Connectivity_PHP_MySQL_Presentation.pptx

Database_Connectivity_PHP_MySQL_Presentation.pptx

• 1.
  Database Connectivity inPHP with MySQL B.Tech Computer Science & Engineering Assignment Presentation
• 2.
  Introduction • Dynamic websitesrequire databases to store, manage, and retrieve data. • PHP integrates seamlessly with MySQL to achieve this.
• 3.
  What is MySQL? •MySQL is an open-source relational database. • Features: • - Relational model with tables • - Lightweight and scalable • - Widely used with PHP.
• 4.
  PHP + MySQLIntegration • Browser → PHP → MySQL • Part of AMP stack (Apache, MySQL, PHP). • Supports login systems, e-commerce, student management.
• 5.
  Database Connection <?php $host ="localhost"; $user = "root"; $pass = ""; $db = "college"; $conn = mysqli_connect($host, $user, $pass, $db); if ($conn) { echo "Connected Successfully!"; } else { echo "Connection Failed!"; } • ?>
• 6.
  CRUD Operations • Create,Read, Update, Delete are the fundamental operations. • Example:
• 7.
  Insert Example $sql ="INSERT INTO students (name, course) VALUES ('Ankit', 'B.Tech CSE')"; • mysqli_query($conn, $sql);
• 8.
  Read Example $result =mysqli_query($conn, "SELECT * FROM students"); while($row = mysqli_fetch_assoc($result)){ echo $row['name']." - ".$row['course']."<br>"; • }
• 9.
  Real-Life Applications • •Login systems • • E-commerce websites • • Student Management Systems
• 10.
  Hosting • Deploy PHP-MySQLapplications using: • - cPanel • - FileZilla • Makes projects live globally.
• 11.
  Security Best Practices •• Prevent SQL injection using prepared statements • • Validate inputs • • Use PDO/MySQLi • • Prefer HTTPS
• 12.
  Conclusion • Database connectivityin PHP with MySQL enables modern dynamic applications. • We covered: • - MySQL basics • - PHP integration • - CRUD operations • - Real-world applications • - Hosting & Security