PHP Bootstrap Database Patent Application: Manage patents stored in a MySQL database

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 177		All time: 8,752 This week: 47

Version		License		PHP version		Categories
`bootstrap-patent-db` 1.0.0		Freeware		5		PHP 5, Databases, Content management

Description

Author

Timothy Malche

This class can manage a patent database with a Bootstrap based UI.

It can manage patents stored in a MySQL database by providing means to create, retrieve, update, delete and check patent records.

The patent records are stored in a table that includes fields for the patent title, year, earnings and status.

Innovation Award

August 2017
Number 2

Prize: One downloadable e-book of choice by O'Reilly

Patents are used to record inventions done by many people.

This package can manage a patent database, so users can review or update the list of recorded patents.

Manuel Lemos

Timothy Malche

Performance

Level

Name:	Timothy Malche `<contact>`
Classes:	2 packages by Timothy Malche
Country:	India
Age:	45
All time rank:	3728	256 in India
Week rank:	195	19 in India

Level 1

Innovation award

Nominee: 1x

Example


<?php


require_once ('EmpPatent.php');








$pstatusList = array(1 => 'Filed', 'Granted', 'Published', 'Owned');





$act = $_GET['act'];


$pid = $_GET['pid'];





if ($act == 1) {


    $result = "<table class='table table-bordered'><tr><td><h4 align='center' >Add Patent Details</h4></td></tr></table>"


            . "<form method='post' id='add' action='' enctype='multipart/form-data'><div class='row' style='margin-left: 0'>"


            . " <div class='span12'> "


            . "<table class='table table-bordered table-striped table-condensed cf table-hover form-group' style='font-size:12px;'>"


            . "<tr>"


            . "<td><b>Patent No :</b></td>"


            . "<td><input type='text' id='pno' name='pno' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Title :</b></td>"


            . "<td><input type='text' id='title' name='title' class='form-control' style='height:30px;width:90%;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Earnings (in Rs.) :</b></td>"


            . "<td><input type='number' id='earnings' name='earnings' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Status :</b></td>"


            . "<td><select id='status' name='status' required>"


            . "<option value=''> -- Select -- </option>";


    foreach ($pstatusList as $key => $value) {


        $result .= "<option value='" . $key . "'>" . $value . "</option>";


    }





    $result .= "</select></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Year :</b></td>"


            . "<td><input type='number' id='year' name='year' min='1900' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td colspan='2' style='text-align: center;'><button id='btnsubmit2' name='btnsubmit' type='submit' class='btn btn-default'  value='add' style='width:25%;background:lightgray;'><b> Add </b></button></td>"


            . "</tr>"


            . "</table>"


            . "</form>";





    echo $result;


    } elseif ($act == 2 && $pid != "") {


        $objPatent = EmpPatent::GetRecordById($pid);





    $result = "<table class='table table-bordered'><tr><td><h4 align='center' >Edit Patent Details</h4></td></tr></table>"


            . "<form method='post' id='edit' action='' enctype='multipart/form-data'><div class='row' style='margin-left: 0'>"


            . " <div class='span12'> "


            . "<table class='table table-bordered table-striped table-condensed cf table-hover form-group' style='font-size:12px;'>"


            . "<tr>"


            . "<td><b>Patent No :</b></td>"


            . "<td><input type='hidden' name='pid' id='pid' value='" . $objPatent->getId() . "'>"


             . "<input type='text' id='pno' name='pno' value='" . $objPatent->getPNo() . "' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Title :</b></td>"


            . "<td><input type='text' id='title' name='title' value='" . $objPatent->getTitle() . "' class='form-control' style='height:30px;width:90%;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Earnings (in Rs.) :</b></td>"


            . "<td><input type='number' id='earnings' name='earnings' value='" . $objPatent->getEarnings() . "' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Status :</b></td>"


            . "<td><select id='status' name='status' required>"


            . "<option value=''> -- Select -- </option>";


    foreach ($pstatusList as $key => $value) {


        $result .= "<option value='" . $key . "'";


        if ($key == $objPatent->getStatus()) {


            $result .= " selected='true' ";


        }


        $result .= ">" . $value . "</option>";


    }





    $result .= "</select></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Year :</b></td>"


            . "<td><input type='number' id='year' name='year' min='1900' value='" . $objPatent->getPYear() . "' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td colspan='5' style='text-align: center;'><button id='btnsubmit2' name='btnsubmit' type='submit' class='btn btn-default' align='center' value='edit' style='width:25%;background:lightgray;'><b> Edit </b></button></td>"


            . "</tr>"


            . "</table>"


            . "</form>";


    echo $result;


} elseif ($act == 3 && $pid != "") {


    $objPatent = EmpPatent::GetRecordById($pid);





    //Check for proper user


    //if ($objPatent->getPf_no() != $emp->getPfno()) {


    //   header('Location: patents.php');


    //   exit();


   // }





    $result = "<table class='table table-bordered'><tr><td><h4 align='center'><font color='red'>DELETE Patent Details</font></h4></td></tr></table>"


            . "<form method='post' id='delete' action='' enctype='multipart/form-data'><div class='row' style='margin-left: 0'>"


            . " <div class='span12'> "


            . "<table class='table table-bordered table-striped table-condensed cf table-hover form-group' style='font-size:12px;'>"


            . "<tr>"


            . "<td><b>Patent No :</b></td>"


            . "<td><input type='hidden' name='pid' id='pid' value='" . $objPatent->getId() . "'>"


             . "<input type='text' id='pno' name='pno' value='" . $objPatent->getPNo() . "' class='form-control' style='height:30px;' required/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Title :</b></td>"


            . "<td><input type='text' id='title' name='title' value='" . $objPatent->getTitle() . "' class='form-control' style='height:30px;width:90%;' disabled/></td>"


            . "</tr>"


             . "<tr>"


            . "<td><b>Earnings (in Rs.) :</b></td>"


            . "<td><input type='number' id='earnings' name='earnings' value='" . $objPatent->getEarnings() . "' class='form-control' style='height:30px;' disabled/></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Status :</b></td>"


            . "<td><select id='status' name='status' disabled>"


            . "<option value=''> -- Select -- </option>";


    foreach ($pstatusList as $key => $value) {


        $result .= "<option value='" . $key . "'";


        if ($key == $objPatent->getStatus()) {


            $result .= " selected='true' ";


        }


        $result .= ">" . $value . "</option>";


    }





    $result .= "</select></td>"


            . "</tr>"


            . "<tr>"


            . "<td><b>Year :</b></td>"


            . "<td><input type='number' id='year' name='year' min='1900' value='" . $objPatent->getPYear() . "' class='form-control' style='height:30px;' disabled/></td>"


            . "</tr>"


            . "<tr>"


            . "<td colspan='5' style='text-align: center;'><button id='btnsubmit2' name='btnsubmit' type='submit' class='btn btn-danger' align='center' value='delete' style='width:25%;'><b> Delete </b></button></td>"


            . "</tr>"


            . "</table>"


            . "</form>";


    echo $result;


}


?>

Details

contents of applications

/bootstrap	-	file folder
actionPatent.php
EmpPatent.php
footer.php
header.php
patents.php
payent.sql

Files (13)

File	Role	Description
`bootstrap` (2 directories)
`actionPatent.php`	Example	php code
`EmpPatent.php`	Class	php code
`footer.php`	Aux.	php code
`header.php`	Aux.	php code
`OOP_PHP_DB`	Data	contents description
`patent.sql`	Data	sql script
`patents.php`	Data	php code
`screenshot1.jpg`	Screen	jpg image
`screenshot2.jpg`	Screen	jpg image

Files (13)

bootstrap

File	Role	Description
`css` (1 file)
`js` (3 files)

Files (13)

bootstrap

css

File	Role	Description
`bootstrap.min.css`	Data	style sheet

Files (13)

bootstrap

File	Role	Description
`bootstrap.min.js`	Data	java script
`jquery-1.11.1.min.js`	Data	java script
`jquery-1.9.1.min.js`	Data	java script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	bootstrap-patent-db-2017-08-04.zip 190KB
	bootstrap-patent-db-2017-08-04.tar.gz 189KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

Total:	177
This week:	0

All time:	8,752
This week:	47

User Comments (1)

is dengerous, No sanitize PDO posts
7 years ago (gabriele)

17%

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.