Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function createMedOne() {
- $medid = "1";
- $mname = "Name1";
- $menh = "Amount 1";
- $mtime = "17:23";
- $mdte = date("Y-m-d");
- $mhtml = '<tr class="" id="med1">
- <td><p style="font-weight: bold;">Name1</p></td>
- <td>Amount 1</td>
- <td>Kl: 17:23</td>
- <td><button type="button" class="btn btn-warning btn-sm" style="float: right;">Sign</button></td>
- </tr>';
- addmed($medid,$mname,$menh,$mtime,$mdte,$mhtml);
- }
- createMedOne();
- function addmed($medid,$mname,$menh,$mtime,$mdte,$mhtml)
- {
- try
- {
- $stmt = $this->conn->prepare("INSERT INTO tbl_med(medID,medName,medEnh,medTime,medDate,medHtml)
- VALUES(:med_Id, :med_name, :med_enh, :med_time, :med_date, :med_html)");
- $stmt->bindparam(":med_Id",$medid); //id of the med
- $stmt->bindparam(":med_name",$mname); //name of the med
- $stmt->bindparam(":med_enh",$menh); //the amount
- $stmt->bindparam(":med_time",$mtime); //When to give med
- $stmt->bindparam(":med_date",$mdte); //date
- $stmt->bindparam(":med_html",$mhtml); //the html-code to generate content
- $stmt->execute();
- return $stmt;
- }
- catch(PDOException $ex)
- {
- echo $ex->getMessage();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement