PHP Is Simple: 2022

Tuesday, 13 December 2022

PHP and MySQL

MySql

Mysql is a powerful RDBMS.

Top companies in the world such as Youtube, Paypal, Linkedin, Facebook, Twitter, Cisco, Uber, Verizon, Github, Walmart, Flipcart, Alibaba, Paypal etc have adopted Mysql for this reason.

PHP programming language has built-in APIs for interacting with MySQL.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses.

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python.

PHP General Points

PHP

Front End of the application is developed using PHP.

With the help of PHP static part of the project could be easily bind with Back End.

As this is free software the same can be downloaded and deployed easily.

It is integrated with a number of Common databases, including PostgreSQL , MySQL, , Sybase, Informix, and Microsoft SQL Server.

PHP supports a large number of important protocols such as IMAP ,POP3, and LDAP.

PHP can handle forms, i.e. gather data from files, save in hard drive etc.

We add, delete, modify elements within our database using PHP.

We can easily handle cookies variables and set cookies.

Using PHP, you can restrict users to access some pages of your website using session.

It can encrypt data using various algorithms. Hashing can also be done.

Wednesday, 27 April 2022

Auto ID in forms

Hi all,

This has got three parts

1. Code in the form - saveform.php

<html>

<body>

<?php

include('dbconnect.php');

$mid=getid('student','sid');

Id <input type=text name=id1 value='<?php echo $mid; ?>' disabled >

Name <input type=text name=name><br>

</form>

</body>

</html>

2. Code in the save part -savestudent.php

<?php

$id=$_POST['id'];

echo $id;

include('dbconnect.php')

//DB insert query part

3. Include file - dbconnect.php

<?php

$con = mysql_connect("localhost","root","");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("anganwadi", $con);

function getid($tablename,$fieldid)

{

$query="select max($fieldid)+1 as mid from $tablename";

echo $query;

$data=mysql_query($query);

$maxid=0;

while($row=mysql_fetch_array($data))

{

$maxid=$row['mid'];

}

return $maxid;

}