PHP Is Simple

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);

?>

Saturday, 22 February 2020

Dynamic Combobox

Dear all

Using this code a combo box can be dynamically populated using php code.

-------------------------
<?php
if($con=mysql_connect("localhost","root",""))
{
//echo"connected";
}
else
{
//echo"not connected";
}
mysql_select_db("fjc");

//start combo box code.

function showcombobox($tablename,$valuefield,$showfield)
{

$sql="select $valuefield,$showfield from $tablename";
echo $sql;
$data=mysql_query($sql);
$retvalue='';
while($row=mysql_fetch_array($data))
{

$retvalue=$retvalue."<option value='".$row[$valuefield]."'>".$row[$showfield]."</option>";

}

return $retvalue;
}

//start combo box code.

?>
-------------------------------

Sunday, 9 February 2020

MVC in core PHP

Hi All,
This is a post dedicated for creating MVC program using core PHP

////View

<html>
<head>
<form action="controller.php" method=post>
<b> NAME <input type="text" name="name">
ADDRESS <input type="text" name="address">
COURSE<input type="text" name="course"></b>
<input type="submit" name=btnsub value="OK">
</form>
</html>

/////Controller

<?php
include ('model.php');
if(isset($_POST["btnsub"]))
{
echo "entered";
$con=mysql_connect("localhost","root","");
mysql_select_db("mvc",$con);
$s=new student();
$name=$_POST['name'];
$address=$_POST['address'];
$course=$_POST['course'];
$s->insert($name,$address,$course);
//header('location: model.php');

}
?>

/////Model

<?php
class student {
function __construct() {

}

function insert($name,$address,$course ) {
echo "insert worked";
$sql=("insert into student values('$name','$address','$course')");
mysql_query($sql);

}
}
?>

Monday, 27 January 2020

Showing videos which are stored in Server using PHP

Hi All,
This code can be used to view videos which are stored in server.
Table contents are shown using reusable code here.
You have to change only the sql in the below given code.
No need to type the entire code.
Just copy and run.

-----------------------------------------------------------------------------------------------------------
<center>
<?php
include('connect.php');

$query = 'select * from upload';
$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>View</th></tr>';
$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=videoupload1/'.$idval.'.mp4>View Video</a></td>';
echo '</tr>';
$i = $i + 1;
}
echo '</table></body></html>';
mysql_free_result($result);
}
mysql_close ($con);

?></center>

Friday, 10 January 2020

Create a Hashtag with Auto Id

Hi All,
Using this code you can save data to a table with auto generated ID in PHP.

--------------------------
Table

CREATE TABLE IF NOT EXISTS `hashtag` (
`hid` int(11) NOT NULL,
`tag` text NOT NULL,
`description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---------------------------

<html>
<body>
<?php

mysql_connect("localhost","root","");
mysql_select_db("tcsr");

$sql1="select max(hid) as mid from hashtag ";
$data1=mysql_query($sql1);

$id=0;

while($row=mysql_fetch_array($data1))
{

$id=$row['mid'];
}
$id=$id+1;
echo $id;

?>
<form name="frm" method=post enctype="multipart/form-data" >
<pre>
Id <input type="text" value="<?php echo $id; ?>" disabled=disabled name="hid" /> <input name="hid1" type="hidden" value="<?php echo $id; ?>" />
HashTag <input type="text" name="hashtag" />
Description <input type="text" name="description" />

<input name="hsubmit" type="submit" value="Upload files" />
</form>

<?php
echo "entered";
if(isset($_POST['hsubmit']))
{
echo "Entered";
$hid=$_POST['hid1'];
$hashtag=$_POST['hashtag'];
$desc=$_POST['description'];

$sql="insert into hashtag values('$hid','$hashtag','$desc')";
echo $sql;
$result=mysql_query($sql);

}

?>
</body>
</html>

Friday, 27 December 2019

View data using PHP

HI All,

See the code

------------------------------------------------------------------------------

<?php
include('connect.php');

$query = 'select * from upload';
$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>View</th>';
echo '<th>Rating</th></tr>';
$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=videoupload/'.$idval.'.mp4>View Video</a></td>';
echo '<td><a href=rating.php><img src="images/star.jpg"></a></td>';
echo '</tr>';
$i = $i + 1;
}
echo '</table></body></html>';
mysql_free_result($result);
}
mysql_close ($con);

?></center>
<?php

//Showing image in the table
/*$query = 'select * from userreg';
$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></tr>';
$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><img width=30 height=30 src='uploads/

$idval.jpg'></td><td><a href=delComplaint.php?id='.

$idval.'>Delete</a></td>";
echo '</tr>';
$i = $i + 1;
}
echo '</table></body></html>';
mysql_free_result($result);
}
mysql_close ($con);*/

?>