Select database for query:

Warning: mysqli_connect(): (HY000/2005): Unknown MySQL server host 'localhost:8889' (1) in /home/rjmprogr/public_html/MySql/StoredProcedure/xourmysql_storedprocedure.php on line 98

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/rjmprogr/public_html/MySql/StoredProcedure/xourmysql_storedprocedure.php on line 104

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/rjmprogr/public_html/MySql/StoredProcedure/xourmysql_storedprocedure.php on line 105
Error:
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, null given in /home/rjmprogr/public_html/MySql/StoredProcedure/xourmysql_storedprocedure.php on line 108

Please input SQL for (and before) Table Creation: DROP TABLE IF EXISTS PLACE; DROP TABLE IF EXISTS LATLNG; DROP TABLE IF EXISTS LINE; CREATE TABLE LATLNG ( pointid int NOT NULL, lng decimal(11,8) NOT NULL, lat decimal(10,8) NOT NULL, PRIMARY KEY (pointid)); CREATE TABLE PLACE ( placeid int NOT NULL, originid int NOT NULL, lngp decimal(11,8) NOT NULL, latp decimal(10,8) NOT NULL, radius int NULL, PRIMARY KEY (placeid), FOREIGN KEY (originid) REFERENCES LATLNG(pointid)); CREATE TABLE LINE ( lngfrom decimal(11,8) NOT NULL, latfrom decimal(10,8) NOT NULL, lngto decimal(11,8) NOT NULL, latto decimal(10,8) NOT NULL, distance decimal(25,8) NOT NULL); DROP PROCEDURE IF EXISTS GetLMax; DROP PROCEDURE IF EXISTS GetPlaceMax; DROP PROCEDURE IF EXISTS AddLine; Please input SQL for (and before) Stored Procedure 1 of 3: DELIMITER // CREATE PROCEDURE GetLMax(OUT lpm INT) BEGIN SELECT COUNT(*) INTO lpm FROM LATLNG; END // DELIMITER ;

Please input SQL for (and before) Stored Procedure 2 of 3: DELIMITER // CREATE PROCEDURE GetPlaceMax(OUT placecm INT) BEGIN SELECT COUNT(*) INTO placecm FROM PLACE; END // DELIMITER ; Please input SQL for (and before) Stored Procedure 3 of 3: DELIMITER // CREATE PROCEDURE AddLine(id_xf FLOAT, id_yf FLOAT, id_xt FLOAT, id_yt FLOAT) BEGIN DECLARE pid, cid INT DEFAULT 0; CALL GetLMax(@pid); CALL GetPlaceMax(@cid); INSERT INTO LATLNG VALUES (@pid, id_xf, id_yf); INSERT INTO PLACE VALUES (@cid, @pid, id_xf, id_yf, 10); SELECT * FROM LATLNG, PLACE WHERE originid=pointid AND pointid=@pid; CALL GetLMax(@pid); CALL GetPlaceMax(@cid); INSERT INTO LATLNG VALUES (@pid, id_xt, id_yt); INSERT INTO PLACE VALUES (@cid, @pid, id_xt, id_yt, -10); SELECT * FROM LATLNG, PLACE WHERE originid=pointid AND pointid=@pid; INSERT INTO LINE VALUES (id_xf, id_yf, id_xt, id_yt, st_distance_sphere(POINT(id_xf, id_yf), POINT(id_xt, id_yt))); END // DELIMITER ; Please input SQL for query ( maybe CALL AddLine(23.4, 45.6, 56.4, 79.4); ) CALL AddLine(142,-86,61,7); SELECT * FROM LINE;