PHP Is Simple: April 2020

Tuesday, 21 April 2020

Auto Id and File Upload

Hi All,
Find the code for Auto Id and File Upload in PHP...

CREATE TABLE IF NOT EXISTS `studentreg` (
`sid` int(11) NOT NULL,
`name` text NOT NULL,
`address` text NOT NULL,
`email` text NOT NULL,
`phone` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

------------------------------------------------
studentform.php
-----------------------------------------------------
<html>
<body>
<?php

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

//Code to insert into both registration and Login table
if(isset($_POST['btnsubmit']))
{
$sql="insert into studentreg values('$_POST[id1]','$_POST

[name]','$_POST[address]','$_POST[email]','$_POST

[phone]')";
echo $sql;
$sql1="insert into login values('$_POST[id1]','$_POST[password]','student','0')";
mysql_query($sql,$con);
mysql_query($sql1,$con);

$target_dir = "uploads/";
$target_file=$target_dir .$_POST['id1'].'.jpg';
move_uploaded_file($_FILES["fileToUpload"]["tmp_name"],

$target_file) or die('Error'.mysql_error());

}

?>

<?php

//Auto generate next id in the screen.

//Query to get the highest value in table

$sql="select max(sid) as mid from studentreg";
$data=mysql_query($sql);
$id=0;
while($row=mysql_fetch_array($data))
{
$id=$row['mid'];
}

$id=$id+1;
echo $id;
?>
<form action=# method=post enctype="multipart/form-data">
<pre>
Id <input name=id disabled=disabled value="<?php echo

$id ; ?>" pattern="[a-zA-Z]{2,10}" title="Enter only

characters">
<input type=hidden name=id1 value="<?php echo $id ; ?>" >
Name <input name=name required=required maxlength=18>
Address <input name=address>
Email <input type=email name=email>
Phone <input name=phone pattern="[0-9]{10,12}">
Password<input name=password >
Photo <input type="file" name="fileToUpload"

id="fileToUpload">
<input type=submit name=btnsubmit value='Save'>
</pre>
</form>

Monday, 6 April 2020

Combo Box -Validation- Auto ID Generation-Delete-Uploadfile

Hi All,

This PHP program will help you to do combobox, dynamic combobox from table, form validation , auto id generation in php form, delete from form, upload image in php etc.

---------------------------------------------------------------------------------------
<html>
<body>
<form action=savestudent.php method=post>
<table>
<tr>
<td>Id</td>
<td><input name=id ></td>
</tr>

<tr>
<td>Name</td>
<td><input name=name ></td>
</tr>
<tr>
<td>Course</td>
<td>
<select name=name >
<option value=c1>MCA</option>
<option value=c2>MTech</option>
<option value=c3>BTech</option>
</select>
</td>
</tr>
<tr>
<td>Gender</td>
<td>Male <input type=radio name=gender value=male >Female <input type=radio name=gender value=female ></td>
</tr>
<tr>
<tr>
<td></td>
<td><input type=submit value='Save'></td>
</tr>
</table>
</form>
</body>
</html>

-----------------------------------------------------------------------------------------------------------------
Now Combobox values can be generated by using table and function
So create a table course with courseid and coursename

<htm>
<body>
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("hup");

function showcombobox()
{
$sql="select courseid,coursename from course";
echo $sql;
$data=mysql_query($sql);
$retvalue='';
while($row=mysql_fetch_array($data))
{
$retvalue=$retvalue."<option value='".$row['courseid']."'>".$row['coursename']."</option>";
}
echo $retvalue;

}
?>

<form action=savestudent.php method=post>
<table>
<tr>
<td>Id</td>
<td><input name=id ></td>
</tr>

<tr>
<td>Name</td>
<td><input name=name ></td>
</tr>
<tr>
<td>Course</td>
<td>
<select name=name >
<?php
showcombobox();
?>
</select>
</td>
</tr>
<tr>
<td>Gender</td>
<td>Male <input type=radio name=gender value=male >Female <input type=radio name=gender value=female ></td>
</tr>
<tr>
<tr>
<td></td>
<td><input type=submit value='Save'></td>
</tr>
</table>
</form>
</body>
</html>

Friday, 3 April 2020

Simple View in PHP

Hi All,
See the code.... ...

<?php

//include('connect.php');
//Db connection code here

$query = 'select * from student';
$result = mysql_query($query);
if (!$result)
{
$message = 'ERROR:' . mysql_error();
return $message;
}
else
{
$i = 0;
echo '<html><body><table border=1 align=center><tr>';
while ($i < mysql_num_fields($result))
{
$meta = mysql_fetch_field($result, $i);
echo '<th>' . ucfirst($meta->name) . '</th>';
$i = $i + 1;
}
echo '<th>Delete</th>';

$i = 0;
while ($row = mysql_fetch_row($result))
{
echo '<tr>';
$count = count($row);
$y = 0;
$idval='1';
while ($y < $count)
{
$c_row = current($row);
if($y==0)
$idval=$c_row;
echo '<td>' . $c_row . '</td>';
next($row);
$y = $y + 1;
}
echo '<td><a href=delstudent.php?id=$idval>Delete</a></td>';

echo '</tr>';
$i = $i + 1;
}
echo '</table></body></html>';
mysql_free_result($result);
}
mysql_close ($con);

?>