php_prac

Problems I faced and solutions which worked

1. mysql not starting - https://stackoverflow.com/questions/18177148/xampp-mysql-does-not-start
   

2. php version on xampp - https://stackoverflow.com/questions/49463762/how-to-know-the-version-of-php-is-used-on-xampp
   

3. phpmyadmin not working - https://stackoverflow.com/questions/52522461/i-changed-the-phpmyadmin-mysql-port-number-and-now-i-cant-log-in
   

4. problem while connecting to databse:

servername should be the server phpmyadmin is running . Make sure to include the port 3307(in case changed)

<?php
    echo "Get connected to database<br>";
    /*ways to connect to msql database
        1.MySQLi extension
        2.PDO
    */
    
    //create a database connection
    $servername = "127.0.0.1:3307";//default
    $username = "root";
    $password = "";//this is default password of xampp
    //$database = "codephp";

    //create a connection
    $conn = mysqli_connect($servername, $username, $password);

    //die if connection was not successful
    if(!$conn){
        die("Sorry we failed to connect: ". mysqli_connect_error());
    }
    else{
        echo "Connection was successful<br>";
    }


?>

adding port number after localhost is another way

<?php
    echo "Get connected to database<br>";
    /*ways to connect to msql database
        1.MySQLi extension
        2.PDO
    */
    
    //create a database connection
    //$servername = "127.0.0.1:3307";
    $servername = "localhost:3307";
    $username = "root";
    $password = "";//this is default password of xampp
    //$database = "codephp";

    //create a connection
    $conn = mysqli_connect($servername, $username, $password);

    //die if connection was not successful
    if(!$conn){
        die("Sorry we failed to connect: ". mysqli_connect_error());
    }
    else{
        echo "Connection was successful<br>";
    }


?>

5. Deleting record from table using php and button - https://e-codec.blogspot.com/2021/05/how-to-delete-data-from-database-in-php.html
   
6. Edit and update the table by button click and php - https://www.campcodes.com/downloads/add-edit-delete-mysql-table-rows-in-php-source-code/
   
7. Password verification using hashing - https://www.geeksforgeeks.org/how-to-encrypt-and-decrypt-passwords-using-php/#:~:text=Decryption%20of%20the%20password%3A%20To%20decrypt%20a%20password,given%20password%2C%20generated%20by%20the%20password_hash%20%28%29%20function.
   
8. Disable back button in browser through js : https://stackoverflow.com/questions/7011334/disable-browser-back-button
   
9. Remove error messages: https://stackoverflow.com/questions/1987579/remove-warning-messages-in-php
   
10. Not able to redirect to another php page using header() function in php- https://stackoverflow.com/questions/4871942/how-to-redirect-to-another-page-using-php
    Easy solution:

    <?php
        echo "<script> location.href='new_url'; </script>";
        exit;
    ?>