Posts by Murilo Cabral • 431 points
71 posts
-
0
votes2
answers74
viewsA: Help with JOINS in 3 tables
I solved the problem with INNER JOIN, using the Wampserver Localhost 2.5 worked right, bringing the correct result regarding the sale requested in the search. But when I do FTP to the server, it…
-
3
votes2
answers74
viewsQ: Help with JOINS in 3 tables
I found a tutorial talking about JOINS and implanted in the survey for sales made. But it was almost all right, only at the time of the search for the sales code, instead of bringing me only the…
-
1
votes1
answer76
viewsA: Difficulty writing 3 different input names with foreach
I solved guys, changes were made in INSERT, and so was the code. Insert page: $codvenda = mysql_insert_id(); $codproduto = $_REQUEST['codproduto']; $quant = $_REQUEST['quant']; $preco =…
-
0
votes1
answer76
viewsQ: Difficulty writing 3 different input names with foreach
Hello, I am creating a shopping cart and need to record via form the products selected by the customer. Almost everything is working, missing only record the products in the table itemvenda. I made…
-
1
votes2
answers356
viewsA: Take id from last sale and register in the codsale field of the items table.
With Durtto’s tip and a lot of kick (Rs...), I managed to get the id of the sale and record in the field codvenda table itemvenda. So was the php code: <?php include '../conexao.php';…
-
1
votes2
answers356
viewsQ: Take id from last sale and register in the codsale field of the items table.
Hello, I have to register the sales made in two tables, (Sale and Itemvenda). In the sales table I have the fields id, codcliente, datavenda e total. In the table itemvenda have the fields id,…
-
0
votes1
answer43
viewsQ: You doubt Draggable’s position
I need to ask you a question! I’m creating a Dashboard to Administer a site, but I’m having a hard time figuring it out, because when I place an image on the scale I want, but when I update it, it’s…
-
0
votes3
answers10359
viewsA: Access only via login and password, Inhibiting direct access via url
Hello friends I am answering my own question, because I managed to solve with the help of a Youtube tutorial https://www.youtube.com/watch?v=-yUMdFWrPJc (That I would like to share with friends),…
-
1
votes3
answers10359
viewsQ: Access only via login and password, Inhibiting direct access via url
I made an access login system, but I would like the user to be obliged to access it with the login and password, inhibiting direct access via url. Anyone can access the page via URL by entering the…
-
-1
votes1
answer1674
viewsQ: Avoid date and time duplicity for the same scheduling professional
Friends I’m trying to create an agenda for a dental clinic, but I’m having a hard time preventing the client from scheduling a date and time that has already been scheduled for that selected…
-
0
votes2
answers246
viewsA: Problem with INSERT using PDO
Perfect friend, that was right now worked right, I’m entering the code with the changes. <?php if(isset($_POST['enter'])){ $nome = $_POST['nome']; $tel = $_POST['tel']; $cel = $_POST['cel'];…
-
1
votes2
answers246
viewsQ: Problem with INSERT using PDO
I have this code below that is working perfect, but I would like to change it to work in PDO but I’m having problem in the registration with BD, when I change to PDO. He refers to mistakes on line…
-
1
votes1
answer1177
viewsQ: Change image upload from mysql_query to PDO
I would like to change this code that is working with mysql_* for PDO: <?php if ( isset($_POST['enviar']) ) { $arquivo = $_FILES['arquivo']['name']; $update = mysql_query("UPDATE cabecalho SET…
-
2
votes1
answer979
viewsQ: Prevent duplicate registration with PDO
I’d like to prevent the same source from registering for duplicities. The code used for registration is below: <form name="enter" method="post" action="" enctype="multipart/form-data">…
-
0
votes0
answers80
viewsQ: Problem with INSERT PDO
Hello friends I am very layman in PDO and I would like the help of friends to try to create an INSERT that registers a font name in the BD source table. Next, I created this code below, based on the…
-
2
votes1
answer1150
viewsQ: Problems with SELECT option with PDO
Friends reissued the PDO connection below: <?php $conn = new PDO( 'mysql:host=localhost;dbname=pbfjacar_site' , 'pbfjacar_murilo' , 'smc100164' ); $stmt = $conn-> prepare('SELECT font FROM…
-
4
votes1
answer354
viewsQ: Change a Select mysql to a Select PDO
I have a select of sources registered in a table, and I currently use this code to list them so that the user can choose the desired source. <select name="tipo_font_end"> <?php $select =…
-
1
votes2
answers372
viewsQ: Problem with PDO and mysql_query connection
Hello, I created the connected.php file as below: <? $conn= new PDO("mysql:host=localhost;dbname=site", "root", ""); $count = ('SELECT * FROM conteudo'); $stmt = $conn->prepare($count);…
-
1
votes1
answer97
viewsQ: Problem working with Draggable and Resizable in the same image
I created a code and I’m having problems with it. I’ve tried them both individually, both Draggable like the Resizablee, and worked perfectly, altering the data in the input, and when updated…
-
0
votes1
answer320
viewsQ: Assign value to input text
I have the code below that is working perfect, IE, whenever I move the images appears to me the left and top scales of the same. However it is appearing with LI and I need it to appear in the VALUE…
-
1
votes1
answer273
viewsQ: how to get image positioning using draggable
how can I get through a scale input (left and top) of positioning the image that is being moved with draggable. The purpose of this doubt is so that you can save in the Database using PHP and Mysql,…