Would you help me here! I get a wrong in my php code and I couldn't solve it. PHP Syntax Check: Parse error: syntax error, unexpected token "class" in your code in line 4 The code is db = new mysqli(DBHOST, DBUSER, DBPASS, DBDATABASE); if($this->db->connect_errno > 0) { die("Fel vid anslutning: " . $db->connect_error); } } // My method to read posts from my database public function getPosts() { // sql command to get data from my database table called 'guestbook' $sql = "SELECT * from guestbook ORDER BY created DESC"; $result = $this->db->query($sql); return mysqli_fetch_all($result, MYSQLI_ASSOC); } public function addPost(string $user, string $content) { $sql = "INSERT INTO guestbook(user, content)VALUES('$user', '$content')"; return $this->db->query($sql); } public function deletePost(int $id) { $sql = "DELETE FROM guestbook WHERE id=$id"; return $this->db->query($sql); } }

Would you help me here! I get a wrong in my php code and I couldn't solve it. PHP Syntax Check: Parse error: syntax error, unexpected token "class" in your code in line 4 The code is db = new mysqli(DBHOST, DBUSER, DBPASS, DBDATABASE); if($this->db->connect_errno > 0) { die("Fel vid anslutning: " . $db->connect_error); } } // My method to read posts from my database public function getPosts() { // sql command to get data from my database table called 'guestbook' $sql = "SELECT * from guestbook ORDER BY created DESC"; $result = $this->db->query($sql); return mysqli_fetch_all($result, MYSQLI_ASSOC); } public function addPost(string $user, string $content) { $sql = "INSERT INTO guestbook(user, content)VALUES('$user', '$content')"; return $this->db->query($sql); } public function deletePost(int $id) { $sql = "DELETE FROM guestbook WHERE id=$id"; return $this->db->query($sql); } }

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

5.9 LAB - Database programming with Java (SQLite) Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database. createTable() creates the Horse table. insertHorse() inserts one row into Horse. selectAllHorses() outputs all Horse rows. Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. Both SQLite and MySQL Connector/J implement the JDBC API. Consequently, the API is as…
Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database. createTable() creates the Horse table. insertHorse() inserts one row into Horse. selectAllHorses() outputs all Horse rows. Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. Both SQLite and MySQL Connector/J implement the JDBC API. Consequently, the API is as described in the text, with a few exceptions: Use the connection…
Open your text editor and create a new document named model.php model.php will connect to a database potentially return PDO statement objects to the controller for processing. This question is complete and requires use of initMessagesfunction initMessages($tim) This method will take a single parameter of unix time using the method “time()”. It will conditionally select fromthe table “messages” the minimum id and rename it to “min_id”. The condition is that the field time is greater thanthe parameter for time. The return is the PDOStatement object with the row data from a query.
MongoDB 1) The customers collection includes documents that have accounts as a field that contains an array of values. Write a statement to retrieve a cursor containing all documents where there is only one account. 2) Write a statement that returns only the email addresses of all customer documents. 3) Write a statement to retrieve a cursor containing all customer documents where the active field within the main document (i.e., do not worry about nested documents) is set to true. 4) Write a statement to retrieve a cursor containing all customer documents that do not have the active field within the main document (i.e., do not worry about nested documents). (Hint: Take a look at the Query and Projection operators in the MongoDB documentation to find an operator that helps determine whether a field exists within a document.)
When the Search button is pressed in the screen depicted, the getSales() function from the PosDAO.java class is called, the parameters of this function are the from date and to date.The getSales () function should return a list of Pos objects that matches the criteria specified, Note this function has to perform two INNER JOINs in to combine all three tables in order to get all the needed data to fill the Pos object. The database schema is also depicted. The PosDAO, Product, SalesDetails and Pos classes are shown BELOW Write the getSales() function public class PosDAO { private Connection conn; PreparedStatement stmt = null; public boolean openConnection(){ try { // db parameters String url = "jdbc:mysql://localhost:4306/swen2005"; String user = "root"; String password = ""; // create a connection to the database conn = DriverManager.getConnection(url, user, password); if (conn!= null){ return true;…
Create a Java application for Checkers called CheckersStockTakingApp. The application should consist of a client side, a server side and a database.4.1 Create a database called checkersproducts using MySQL or any relational database management software you are comfortable with. The database should have a table called products that consists of the following columns and properties:prodID AUTO NUMBER (primary)prodName VARCHAR (30)prodType VARCHAR (30)prodPrice DECIMAL (6,2)4.2 Create a server class that will do the following:• Run on port 8000 and listen to a client• Initially output a “server is starting” message to the screen• Make a connection to the database• Receive product details from the client• Add product details to products table• Send a message back to client to inform whether or not the product was added• Handle any exceptions• Close the server when the user types "stop" on the client side and output a message"Server stopping...." 4.3 Create a client class that will do the…
Consider the following scenario: you are asked to create a Java class MetaDisplay that contains a static void printTable(String r) method. The method takes a relation name r as input, executes the query "select * from r," and prints the result out in tabular format with the attribute names displayed in the table's header; the attribute names are displayed in the table's header. What JDBC method(s) can you use to get the information you require? t?
Can someone look at schema code and and tell me where I may have went wrong? Someone ACTUALLY look at my code and fix it so i can run it succesfully. Look at bold code and tell me if its right or not. CREATE SCHEMA library AUTHORIZATION ADEEL; create user gerstld; CREATE TABLE library.BRANCH ( ID int CONSTRAINT BRANCH_ID NOT NULL , Name varChar(90) CONSTRAINT BRANCH_Name NOT NULL , Address varChar(200) CONSTRAINT BRANCH_Address NOT NULL , CONSTRAINT BRANCH_pk PRIMARY KEY (ID) ); CREATE TABLE library.BOOKS ( Card_Catalog varChar(7) CONSTRAINT BOOKS_Card_Catalog NOT NULL , Author varChar(90) CONSTRAINT BOOKS_Author NOT NULL , Title varChar(20) CONSTRAINT BOOKS_Title NOT NULL , Edition int CONSTRAINT BOOK_Edition NOT NULL , ISBN int CONSTRAINT BOOK_ISBN NOT NULL , Copy_Number int CONSTRAINT BOOK_Copy_Number NOT NULL , Replacement_Costs_Cents money CONSTRAINT BOOK_Replacement_Costs_Cents NOT NULL , Publication_Year date CONSTRAINT…
Android question: Suppose you have a table named ‘food’ with the following attributes: Id: int (primary key) name: varchar(20) calories: int cost: float Write a piece of code representing a method in a Dao interface that is part of a Room database implementation. If the method is invoked, all food with ‘calories’ of more than 90 and costs less than 270 must be deleted. Note: suggest a name for your method.
Develop a Java application that should make use of Remote Method Invocation and a database. Your application should retrieve the fuel sales from the database then output the results in a graphical user interface. Your application should consist of the following: a) - A database: ï The database should be called Sells, and should have a table called provincialsales with the following table properties: saleID INT (Primary key), province(varchar), litres BIGINT ï You are allowed to use any RDMS you are comfortable with. b) - A Province class: ï The province class should implement the serializable interface and have getter and setter methods to get entries from the database c) - A remote object interface: ï The remote interface should be called Sales. It should have a method that returns a list that comprises of objects from the Province class. d) - A ConnectionImpl class: ï The class should be called ConnectionImpl and should implement the Sales interface. ï It should have a method to get…
explain the code package com.templatepattern; public class TemplatePatternTest1 { public static void main(String[] args) {String connectionString = "server=192.168.0.7";String username = "learner"; String password = "designPatterns";StudentRegistration sr = new DatabaseBasedStudentRegistration(connectionString, username, password);System.out.println();Person p1 = new Person("patrick", "nick");System.out.println("Registering " + p1);sr.register(p1);System.out.println(); Person p2 = new Person("zayn", "nick");System.out.println("Registering " + p2);sr.register(p2);System.out.println();} } abstract class StudentRegistration {// template methodfinal Student register(Person person) {if (checkPerson(person)) {startOperation();try {int studentId = getNewIdentity(person);Student student = new Student(person, studentId);completeOperation();return student;}catch (Exception e) {cancelOperation();promptError(e.getMessage());}}else {promptError(person + " is not a valid citizen.");} return…
LabProgram.java:8: error: class HorseDatabase is public, should be declared in a file named HorseDatabase.java public class HorseDatabase { ^ 1 error Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database.createTable() creates the Horse table.insertHorse() inserts one row into Horse.selectAllHorses() outputs all Horse rows.Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints ValueId integer primary key, not null 1Name text 'Babe'Breed text 'Quarter horse'Height double 15.3BirthDate text '2015-02-10'The program output should be: All horses:(1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')This lab uses the SQLite database…