php

[Solved] bind_param for php pdo for select

by

[ad_1] I rectified that above and got error on below public function getAllRecord($table){ $result = $this->con->prepare(“SELECT * FROM “.$table); $result->execute(); $results = $result->fetchAll(); $rows = array(); if ($results->rowCount > 0) { while($row = $results->fetch(PDO::FETCH_ASSOC)){ $rows[] = $row; } return $rows; } return “NO_DATA”; } Error:Notice: Trying to get property of non-object in C:\xampp\htdocs\inv_project\public_html\includes\DBOperation.php on line … Read more

[Solved] Autoincrement problem [duplicate]

by

[ad_1] You received the answer the last time you posted this question. MySQL maintains an internal counter that is incremented every time a new row is inserted into a table with an auto-increment column. The increment value does not go down when a row is deleted. To make things work the way you want, you … Read more

[Solved] php foreach array id value

by

[ad_1] You didn’t provided proper source code of your array. So I couldn’t understand properly I think, still I’m trying to answer. If your ID number and text both are stored in $list array values, like this – $list = array( ‘id1:text 1’, ‘id2:text 2’, … ); then you could do something like this $idArr= … Read more

[Solved] how can I run mysql script in php?

by

[ad_1] If you are using the GET method, us $_GET to get the submit form data. <?php $servername = “localhost”; $username = “root”; $password = “”; $dbname = “test”; session_start(); // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die(“Connection failed: ” . $conn->connect_error); } if(isset($_GET[“action”])&&($_GET[“action”]==”versave”)){ $gp_name = … Read more

[Solved] Making a delete.php file, code give me error

by

[ad_1] Your syntax is wrong. Why are you putting all the condition inside brackets. $id=(isset($_REQUEST[‘grants_id’]) ? $_REQUEST[‘grants_id’] : ”); replace this line from the below line. $id = (isset($_REQUEST[‘grants_id’])) ? $_REQUEST[‘grants_id’] : 0; if($id > 0){ // your code } [ad_2] solved Making a delete.php file, code give me error

[Solved] Calculate SUM in PHP

by

[ad_1] Incidentally, everything up to while ($row… can be rewritten as follows: SELECT p.product_name , p.birim , SUM(p.quantity) total FROM urun u JOIN product p ON p.product_name = u.urun AND p.quantity > 0 AND p.grup != ‘uygulama’ AND p.skt > CURDATE() GROUP BY p.product_name , p.birim; 0 [ad_2] solved Calculate SUM in PHP

[Solved] How to convert String Array to Real array PHP

by

[ad_1] So it looks like you are trying to string manipulate JSON to try to make some sort of associative array. Replacing the : with => is not the right move here… <?php include_once(‘simple_html_dom.php’); ?> <!DOCTYPE html> <html> <head> <title> HTML DOM Parser</title> </head> <body> <?php header(‘Content-Type: text/html; charset=utf-8’); set_time_limit(0); $html=file_get_html(‘https://www.monreseauplus.com/villes/’); $array[]=array(); $array3[]=array(); foreach($html->find(‘.ul. li.cat-item … Read more

[Solved] Does XAMPP include PHP?

by

[ad_1] From XAMPP home page: What is XAMPP? XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.XAMPP is the most popular PHP development environment XAMPP comes with PHP already bundled. You … Read more

[Solved] Import database from Excel [closed]

by

[ad_1] For MySQL. Excel sheet data prepared for importing must be saved as CSV text file. This file must be placed in some place accessible by MySQL. These steps must be performed by some program/script/tool external to MySQL. Then it must be imported using LOAD DATA INFILE statement into temporary table, imported data is processed … Read more