Consult about database


#1

the database is already connected but it doesn’t take the data from the website.


#2

What is your INSERT code?


#3

CREATE DEFINER=root@localhost PROCEDURE inser(in ID_Caso double,
in cus_name varchar(50),
in OpenDate date,
in TimeZone varchar(50),
in Severidad
varchar(50))
BEGIN
/DECLARE nombre varchar(45)/
insert into casos(IDCaso,cus_name,OpenDate,TimeZone,Severidad) values(ID_Caso,cus_name,OpenDate,TimeZone,Severidad);
END


#4




            <?php
           error_reporting(E_ALL ^ E_NOTICE);
            $con=mysqli_connect("localhost","root","") or die("Problemas al conectar la base de datos");
            mysqli_select_db($con,"dataprotectorcasos");
            $query = mysqli_query($con,"Call inser('$_POST[IDCASO]','$_POST[nom]','$_POST[fec]','$_POST[zon]','$_POST[sev]')");
   
            if($query >=1)
            {
                echo '<script type="text/javascript">alert("INSERTADO CORRECTAMENTE");</script>';
            }            
            ?>

#5

What’s that code?
Is that mySQL?
And insert should be like that

INSERT INTO `table` (value1,value2) VALUES('123','test')  WHERE `row`='a_condition_here'

#6

is mysql and is working fine using xammp and mysql workbench


#7

Are you using the exact login details? id2551129_dataprotectorcasos with id2551129_root as well?


#8

yes, that part is correct but i was reading that i need t change the localhost by something like this: $mysql_host = “mysql20.000webhost.com”; this comes from CPanel but i do not have access


#9

localhost is the hostname for 000webhost MySQL databases.

You can only run scripts on your hosting account via the website.

You cannot use RemoteMYSQL via your PC on an application etc nor can you remotely access it any other way.