#02 Advanced CRUD App Using Bootstrap 4, PHP & MySQLi Prepared Statement In Object Oriented Style


https://i.ytimg.com/vi/kkxTxoFvVMA/hqdefault.jpg



Hello World! this is the 2nd part of the series Advanced CRUD Application using Bootstrap 4, PHP and MySQLi Prepared Statement (Object Oriented). And in this part I’m showing you how to make connection to the database in object oriented style and then I’m showing how to insert record in the table with image. And also I’m showing you how to delete record and display bootstrap 4 alert dynamically according to message type.

Source Code: https://dcodemania.com/post/crud-app-php-mysqli-prepared-statement

Full Playlist Link : https://www.youtube.com/playlist?list=PL6u82dzQtlfupa5S9YieBB5CHgwmI6bM_

#CRUD_App_Using_PHP_MySQLi_OOP
#CRUD_App_BS4_PHP_MySQLi_Prepared_Statement

If you like my works and my video tutorials then you can donate me some amount. You can donate through these links :

Paypal : https://www.paypal.me/wolfmania

Instamojo (Credit/Debit Card & UPI) : https://www.instamojo.com/@wolfmania

Thanks for watching this video. If you like this video then hit like button, share this video, And Subscribe my Channel. Also like my Facebook page for latest updates.

♥ Facebook Page – https://www.facebook.com/dcodemania
♥ Myself On FB – https://www.facebook.com/sahil4rock
♥ Instagram – https://www.instagram.com/sahil4rock
♥ Twitter – https://twitter.com/dcodemania

Original source

32 thoughts on “#02 Advanced CRUD App Using Bootstrap 4, PHP & MySQLi Prepared Statement In Object Oriented Style

  • July 11, 2021 at 15:32
    Permalink

    hello Mate! Can you help. This is an error in your original configuration.

    Fatal error: Uncaught Error: Call to a member function execute() on bool in C:xampphtdocscruddbindex.php:98 Stack trace: #0 {main} thrown in C:xampphtdocscruddbindex.php on line 98

  • July 11, 2021 at 15:32
    Permalink

    Sir how to remove this error
    Parse error:syntax error,unexpected '-' expecting variable(T_VARIABLE)or{'or $ in C:xampphtdoscsBSaction.pup on line 3

  • July 11, 2021 at 15:32
    Permalink

    <td><img src="<?= $photo = $row['Photo']; ?>" width="25"></td>
    I have a problem in above it..
    it is making string between src code instead of php code and image is not showing as well

  • July 11, 2021 at 15:32
    Permalink

    Getting an error Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:wamp64wwwApule Driving schoolaction.php on line 15

    ( ! ) Error: Call to a member function bind_param() on boolean in C:wamp64wwwApule Driving schoolaction.php on line 15

  • July 11, 2021 at 15:32
    Permalink

    Hi.
    When i whrite your line 60 i've got this problem:
    Notice: Undefined variable: _SESSION in C:wamp64wwwconsumableindex.php on line 67

    How to solve this .?

  • July 11, 2021 at 15:32
    Permalink

    working perfectly. loving the tutorials. thank you.
    Is there a way of clearing the session variables on a page re-load? If you move away from the index.php when it is displaying an alert box then come back to index.php the alert box still shows.
    Keep up the good work man!

  • July 11, 2021 at 15:32
    Permalink

    In a profound sense , Fermat's Last Theorem stand up at the base of #ModernPhysics , and then we can't let a PROOF to hide a GENERAL SOLUTION WHICH Discover this BASE .

    Fermat's Last Theorem is Fundamental by 2015 September 24 – and it was possible not by a PROOF, but instead for accuracy and all math rigor, by an analytic #MathMethod which to generalize over all n's #FermatMurguImpossibleEquationsInRationalsAndIntegers , but to Proof as #PROOF is correct or not you have Fermat-Murgu Quadruplets a new beautiful #MathGroup (x^3 +y^3 – z^3 = 1 or -1) to demonstrate Modularity at the last for n=3 , and I hope in your success for even if I think sure isn't modularity there. *A M E R I C A 2015 SEPTEMBER 24 WILL CHANGE SCIENCE FUTURE AND EVEN CULTURE – STAY WITH US FOR A NEW 1000 YEARS TRAVEL* With #ShoeTheory , but with #Inerton or The Tear Of Geea, #Physics will know a #NewEra , and a lot will not more like before, #Cosmology, #Astrophysics, and even #ElementaryParticlesTheory , come with My to understand for what I was LOSING more then 40 years for, because of a calculus mistake!!!

    ***STAY AWAY OF CORONA VIRUS! WE HAVE WORK TO MAKE FOR #GOODMORNINGFUTURE !

    #University #academy #Scientist #Nobel -'s , #America2015September24 Fundamentals brought any which nobody was hoping, neither #Einstein, or #Newton or #Maxwell , a motivation for our #Gravitational and #Electromagnetic fields Dependencies , I am #Guilty for it because I was lucking for it , 40 years , now I didn't claim the money of Fermat's Last Theorem SOLUTION, but I claim that my methods are the single for. And I claim it because its accuracy bring a lot for #Science, and is the time for youngest #Sientist to work on, I did my duty! I get what I was lucking for by the time I was 3-th grade at Physics University , now is time for next generations to work on for #TheTearOfGeea.

    #AmericaEarthProudDayFundamentals is coming with a new #ScienceLogic , after #StringTheory , #QuantumTheory is coming back with a new logic, maybe not the last , but to hope will help for next one #SHOETheory! SHOETheory is an #OpenSources #Physics Project of future and #ClimaticDisorderDOTCOM for #LifeClimatic. #America2015September24 the biggest ever #ScienceEvent opened a sense for new #Hopes ! Seem by every coming day , a need to take care of our Planet, and we are ready for it in the era of #SpaceActivity , when… OUR SCIENCE IS MORE THEN MORE ADVANCED , BUT ARE WE HANDLING ENVIRONMENTAL LABYRINTH ? If you will not understand this message today, schedule a time for tomorrow and the day after tomorrow! Until then, take it as a HOPE, AND now we need as never hope! #Universe is one of our #PrimordialDuty as maybe HIS single (maybe) #UniverseConsciousness and I have a big hope **AMERICA EARTH PROUD DAY FUNDAMENTALS** is coming with a big #ScienceTool there too, but , but as you see right now we need a hope to fight to preserve our state declared by My , without honesty – Universe Consciousness – of possible approaching enemy – Climatic Disorder – (thanks God isn't yet #ClimateChange ! ) the strongest ever manifesting right now as even #BiologicDisorders (this series of #SARS) ! #Urgent we need to fight against every Climatic Disorder, but right now is a primordial common fight against #Ephemeral which can to "undress" our #SpiritualState by state of consciousness. For it the single solution , which to propagate to future this primordial care, is our Commercial Site – CLIMATIC DISORDER DOTCOM – AND we will be proud to have you near of us in this FIGHT! AMERICA EARTH PROUD DAY FUNDAMENTALS WAS A HUMAN 2015 BIG MEAL HOPE, HIDED THEN, BUT NOW WE NEED HOPE AND COME TO SAY GOOD MORNING FUTURE AS HOPE*! Five years hided, may by another 10 to hide , but for sure, in a day, you will hear about the best Science and Culture Humanity Event ever ! PS: Fermat-Murgu Impossible Equations into Integers and Rationals, isn't coming with a #PROOF , Instead, is a generalized, correct and accurate #Solution for #FermatLastTheorem . Via *A M E R I C A EARTH PROUD DAY FUNDAMENTALS into #SaintDay 2015 September 24, America brought the biggest ever Humanity #ScienceANDCulture Contribution, 2 #Mathematical Fundamentals with Scientific value #AbsoluteTruth, which can to change your #ScienceLogical for every time by now! One is Fermat's Last Theorem correct solution, where now can stand up the base of #Physics in a new logic, and I hope after 5 years you will understand finally can to be the best to introduce this #Logic too! Only AMERICA EARTH PROUD DAY FUNDAMENTALS solved correct , generalize over all n's as powers, and SENT #FermatLastTheorem IN FUNDAMENTAL. I remind you, CORRECT SOLUTION for is coming from an analytic analyze of symmetric neighbors of Fermat Equations X^n + Y^n – Z^n =0 , like {(X-1),(Y-1),(Z-1)}, {(X-2),(Y-2),(Z-2)} via #IonMurguIntegersPowersFundamentalEquations or #IonMurguTheLostMathematicsFundamental (lost for maybe 7000 years!), and this method was coming with an #AbsoluteTruth . #IfYouLoveEarthComeWithMyToSaveVenus where MY are you everybody! Here are any Examples , a part of our future work to make for GOOD MORNING FUTURE! I INITIATED IT FOR YOU ALREADY BY 2015 SEPTEMBER 24 ! Is the time to recheck our logical system WITH AMERICA EARTH PROUD DAY FUNDAMENTALS ! Stay far away of #CoronaVirus , Climatic Disorder #DOTCOM IS COMING WITH WORK FOR 1000 YEARS FOR #GoodMorningFuture !!! #WildNature , a #WildHope ,but is a hope, with any finality, a kind of #Consciousness maybe also not #ReasoningSentimental with #HumanConsciousness but also we cannot disregard it. #University #Academy ???* This Spring all nature was acting weird, plants but especially trees suffered with us. Maybe motivation was Corona Virus, or a old weird phenomena which began long time ago and is strong sign of CLIMATIC DISORDERS – DEPERSONALIZATION OF THE SEASONS – or both , but scaring anyway!*??? #DEPERSONALIZATIONOFTHESEASONS was observed 17 years ago by climaticdisorder DOT COM AND CRY, but by then the signs are becoming more evidently every year! Humanity and Life in generally seem to be in the front of ever strongest enemy which confronted also thousands years ago (SEE APOCALYPTIC STORY'S INTERPRETED WITH LOGICAL MIND) => #ClimaticChange (#ClimateChange maybe improper) which is announced by Climatic Disorders. We are not yet there , but have a merit, at technological level we are, to try to avoid ever it! Need to understood as in reality our #CivilSocietyPillars implied in #politic at the time, or in #finance directly, or even in #business do not have free time , and any times neither direct interest to be preoccupied about #LifeClimatic and disorders into #LifeClimaticAcceptanceParameters, because they are any times fighting with any urgent hazards problems, what keep of #social or #economy . THEN : With 2015 September 24 , a new era in #Science began, and #AmericaEarthProudDayFundamentals seem to be opening a new hope to #GoodMorningFuture ! ****************JOIN TO*************** A M E R I C A EARTH PROUD DAY FUNDAMENTALS TO FIGHT EPHEMERA AND ALL CLIMATIC DISORDERS #OpenSources Climatic Disorder DOTCOM TO FIGHT WITH last, and strongest Climatic Disorder #CoronaVirus which can send HUMANITY in #Ephemeral #CivilSocietyPillars !!!!!!!!!!! By Blessing Pythagorean Triples as Fermat's Last Theorem BLESSED EXCEPTIONS Fermat's Last Theorem brought itself at THE BASE OF #Physics via #Inerton. Join to Climatic Disorder DOTCOM to try to fight against Climatic Disorders as biologic, climate , etc. – to try to avoid so #ClimateChange which can to mean also #EarthLifeClimaticAcceptanceParameters loss! #HumanityScienceThesaurus #AmericaEarthProudDayFundamentals #ClimaticDisorder DOT COM WASN'T COMING WITH A PROOF FOR any n's as power for Fermat's Last Theorem , BUT INSTEAD GENERALIZE a solution for all n's as powers and then ======= AFTER 400 YEARS GET AFTER ALL HUMANITY RIGHTS FOR = Fermat's Last Theorem = the right to UNIVERSAL = THEN FROM 2015 SEPTEMBER 24 . **FERMAT'S LAST THEOREM – FUNDAMENTAL** This SEPTEMBER 24 to – CLIMATIC DISORDER DOT COM, CLIMATIC HARMONY DOT ORG and a part of #Earth, will CELEBRATE: THE 5TH EARTH PROUD DAY "A DAY OF VIRTUAL APPRECIATION FOR EARTH AS UNTIL NOW SINGLE LIFE CLIMATIC PARAMETERS ACCEPTANCE BUT ALSO THE DAY WHEN FERMAT'S LAST THEOREM BECAME FUNDAMENTAL IN SCIENCE. in 2015 September 24, AMERICA, BROUGHT 2 FUNDAMENTALS as the best contribution anybody make to Humanity Science And Culture Universal. AMERICA EARTH PROUD DAY FUNDAMENTALS brought a lot of new for #Science : 1. Double False Redundancy Of Truth. 2. Fermat – Murgu Quadruplets as a new group in #LinearAlgebra . 3 Murgu Quadruplets also as comparative on. 4. Fermat Equations as Irrationals Integrator's. 5. Blessed Pythagorean Triples as Fermat's Last Theorem EXCEPTIONS. 6. ION MURGU , Special Irrationals which define all Irrational Field. 7. Pythagorean Prime Numbers by Ion Murgu. 8. Euler – Murgu Equations 1=1. 9. Pythagorean Triples as Fermat's Last Theorem BLESSED EXCEPTIONS. & first 2 -two qualitative approach – one FOR #PHYSICS AND ONE FOR #LOGIC . 10. ps: #FermatMurguQuadruplets single #RibetEpsilon accepted by Fermat Equations non modular #AbelPrize for PROOF "n=3 as power". 11. Pythagorean Triples blessed as Fermat's Last Theorem Exceptions which confirm The Rule. 12. A co-lateral but full of beauty #Paradox – Ion Murgu Circles Paradox. 14. FOR PHYSICS BROUGHT "#INERTON' OR #THETEAROFGEEA AND TO HOPE #SHOEThory – SCIENCE HOPE OVER EVERYTHING THEORY. #Microsoft #Google #Facebook #Apple #Twiter #CISCO & ALL. #UnderHumanityNaturalLawOfCopyright#AmericanScienceThesaurus ,#EuropeanScienceThesaurus "https://www.climaticdisorder.com/hstp/ "

  • July 11, 2021 at 15:32
    Permalink

    Hello, my code haven't ERRO, but don't insert the VALUES on DB:

    <?php session_start(); ?>
    <?php ob_start(); ?>
    <?php include('verifica_login.php'); ?>
    <?php include('conexao.php');?>

    <?php

    if (isset($_POST['add'])){

    $nome = $_POST['nome'];
    $email = $_POST['email'];
    $usuario = $_POST['usuario'];
    $senha = $_POST['senha'];
    $conta = $_POST['conta'];

    $foto = $_FILES['imagem']['name'];
    $upload ="uploads/".$foto;

    $query="INSERT INTO usuarios( nome, usuario, email, conta, senha, foto) VALUES (?,?,?,?,?,?)";
    $stmt=$conexao->prepare($query);
    $stmt->bind_param("ssssss", $nome, $usuario, $email, $conta, $senha, $upload);
    $stmt->execute();

    move_uploaded_file($_FILES['imagem']['tmp_name'], $upload);

    header('Location:funcionarios.php');
    ob_end_flush();
    }
    ?>

  • July 11, 2021 at 15:32
    Permalink

    Hey Dok,, greetings from Brazil. I am also having the same problem as the others below. I thought about buying the source code but who guarantees that the same problem will not happen as in the video? Bind_param? Help us dok?

  • July 11, 2021 at 15:32
    Permalink

    Good morning Sahil, I am Amin from Ethiopia, thanks for your video, I am following your video typing the code according with the video, but when I clic the add button the register is not added to the data base, I have repeated the videos twice but I still don´t add a register successfully. Coud you please share your code?. Thanks. (my email: ame305a@gmail.com), or comment

  • July 11, 2021 at 15:32
    Permalink

    Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:xampphtdocsProjectphpcrudaction.php:24 Stack trace: #0 {main} thrown

    HELP me in solving this problem why m i getting this even though i cross checked my whole code and matched with your video 🙁 plz sort out

  • July 11, 2021 at 15:32
    Permalink

    from the bottom of my heart thank you very much, with a bit of mistakes but everything went perfectly for me and all the stuff works thank you very much friend greetings from peru

  • July 11, 2021 at 15:32
    Permalink

    good evening bro how can i solved this problem Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:xampphtdocscscfoaction.php:14 Stack trace: #0 {main} thrown in C:xampphtdocscscfoaction.php on line 14

  • July 11, 2021 at 15:32
    Permalink

    12:25 have problem with adding in database. Can anyone help me out.

    Notice: Undefined index: image in C:xampphtdocsappCaction.php on line 10
    Notice: Trying to access array offset on value of type null in C:xampphtdocsappCaction.php on line 10

    10th line is $photo ->>>>>>>>>>>>>

    if(isset($_POST['add'])){
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];

    $photo = $_FILES['image']['name'];
    $upload = "uploads/".$photo;

    $query = "INSERT INTO crud(name,email,phone,photo)VALUES(?,?,?,?)";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("ssss", $name, $email, $phone, $upload);
    $stmt->execute();
    }

  • July 11, 2021 at 15:32
    Permalink

    Good afternoon friend, I added two more datatime fields (created and modified). I can't do the auto add date code in action.php.
    The date of created and modifieda is to display in the details.php file.
    When to add: data created automatically.
    When update: date modified automatically.

    These two fields are datetime.
    Can you help me please ?

  • July 11, 2021 at 15:32
    Permalink

    problem in session:

    Fatal error: Uncaught Error: Call to undefined function isset_() in C:xampphtdocsjdybindex.php:63 Stack trace: #0 {main} thrown in C:xampphtdocsjdybindex.php on line 63

  • July 11, 2021 at 15:32
    Permalink

    Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:xampphtdocsinspinamodelsaction.php:22 Stack trace: #0 {main} thrown in C:xampphtdocsinspinamodelsaction.php on line 22

    nice video

  • July 11, 2021 at 15:32
    Permalink

    Fatal error: Call to a member function bind_param() on boolean in C:xampphtdocsprojetosphpcrudaction.php on line 15

    <?php

    session_start();

    include 'config.php';

    if(isset($_POST['add'])){

    $name=$_POST['name'];

    $email=$_POST['email'];

    $phone=$_POST['phone'];

    $photo=$_FILES['image']['name'];

    $upload="uploads/".$photo;

    $query="INSERT INTO crud(name,email,phone,photo)VALUES(?,?,?,?)";

    $stmt=$conn->prepare($query);

    $stmt->bind_param("ssss", $name, $email, $phone, $upload);

    $stmt->execute();

    move_uploaded_file($_FILES['image']['tmp_name'],$upload);

    header('location:index.php');

    $_SESSION['response']="Successfully Inserted to the database!";

    $_SESSION['res_type']="Success";

    }

    ?>

  • July 11, 2021 at 15:32
    Permalink

    Please assist me, everything is working ok. But my images are broken. Where am I going wrong. Thank you in advance? This is a very helpful tutorial for my next project.

  • July 11, 2021 at 15:32
    Permalink

    Good morning Sahil, I am Alberto from Colombia, thanks for your video, I am following your video typing the code according with the video, but when I clic the add button the register is not added to the data base, I have repeated the videos twice but I still don´t add a register successfully. Coud you please share your code?. Thanks. (my email: advillanuevag@gmail.com)

Leave a Reply