[php-mysql] Forum Topics

i am running ubuntu 22.04 and php 8.1 / MariaDB , i am missing somthing here in my code just can't see it. the premise of the code is to look at the TrolleyID Field and if it's '00000' basically echo's "BAD-READ" else it's 'GOOD-READ' any help would be great …

Hi Everyone, I am looking for a way to add a username to confirm a seat choice for certain weeks, I already have the PHP Code to confirm the seat when choosing but on the image i would like for it to display the username so other people know its …

Good evening, I need a little help. After having extracted the data from a database table, I would need to print them on the screen in a certain part of an html page with 3 frames (exactly in section B of the "test" page as shown in the example)  …

Hello. Is there anybody here who's eager to help me building a webgame? It's mostly written in PHP and there are some Javascript and CSS files included. I put it on Github. I haven't been using a framework (yet). If you first want to know more, just ask (of course). …

Please Help me. I am coding PHP using below code but out put is not perfect. i am also attach output picture below. <?php require_once 'core.php'; include_once("../fpdf182/fpdf.php"); $pdf = new FPDF(); $pdf->AddPage(); $pdf->setFont("Arial","B",16); $orderId = $_POST['orderId']; $sql = "SELECT orders.order_id, orders.order_date, customer.customer_name, customer.customer_mobile, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, …

I'm struggling to build a PHP registration script using PDO prepared statements with positional placeholders. But the MySQL queries don't execute. `var_dump();` doesn't display any error. Please, I need your help to fix this. Your time and input are much appreciated in advance. Thanks. **register.php:** <?php // include configuration file …

I have a social network site which allows users to upload an image as a profile cover. I use PHP to upload the image to database and select it to display as profile cover.The image shows perfectly, but when I visit a different page and come back, the cover image …

i'd like some help writing an sql statement that brings back the shows in a specific category. For example an sql statement that will bring back shows from the action genre in the tables below 

Hi, When I was trying to create the IT Request Form and testing it out, I got some problems during the testing. The home page (index.blade.php) ended up getting an error called "Undefined offset: 1", maybe due to the table database problem.  The checkboxes in the Request Form (requestForm.blade.php) …

hi, I am stuck trying to figure out how to build a table to display agents names, (that I already have, mysql table etc...) but now I need to add columns dynamicaly. I need to add (programs in witch agents are enroled, and a status of the program ( in-progress, …

I'd like to get all of a mysql table's col names in a select box, and display the selected column name in a table. I just want to select one column at a time to display it in a single column table. I am assuming this can be done with …

Hello i made a ionic searchbar script returns the items[] ok but i want to connect it with my php authservice and return the results from a php function. I already connected my app with the authservice and i have returned JSON data in other pages so the authservice works …

I have an If Statement that isnt loading the right image any help would be great <?php if($formattedNum6 > $PeriodSalesTarget):{ echo '<img src="images/TargetMetGreen.png" alt="" />';} elseif($formattedNum6 > $CummulativePeriodSalesTarget):{ echo '<img src="images/TargetMet.png" alt="" />';} else:{ echo '<img src="images/TargetNotMet.png" alt="" />';} endif; ?> $formattedNum6 = 515,839 $PeriodSalesTarget = 1,366,000 $CummulativePeriodSalesTarget = 503,600 …

Can anyone tell me how to retrieve records from database one at a time.. I am attaching a sample code here: [CODE]include('connection.php'); $sql1="SELECT * FROM question_master"; $result=mysql_query($sql1); while($row = mysql_fetch_array($result)) { echo $row['Question']; }[/CODE] Let me explain the code.. There is a table named "question_master" (containing some questions) in database …

Hello i want to make a script that allows the user to record audio from his device mic and then store it as a .mp3 or .wav file on my database. Does anyone knows any tutorials or scripts? I found this one `http://stackoverflow.com/questions/16413063/html5-record-audio-to-file` but i dont know to make it …

I have scenario where one user can refer two codes to other one will become right and other left.Now this right can have two child left and right and so on same for left child user.... So this is binary tree like strucutre so i am selecting a user from …

Hello every one i am having one doubt i have a set of links[url].Now there is pave ackages like 6 links,25 links package. if two user select 6 link each day and both will have same links[url] .now i when user log in then on adversitment page he visit each …

Hi, I am looking to create a MySQLi class(MVC pattern), I already have the following functions: Query, Execute, Results. Below is a PDO version of a Bind statement and was wondering if you could do the following in MySQLi or something similar in MySQLi: public function bind($param, $value, $type=''){ if(is_null($type)){ …

hello i'm just training myself on web development so i wanted to create a drop down menu wich i have post before about it! so i get the html code and css and the javascrip code of the bootstrap header menu and i want to customize it for my website …

Hey everyone, I have a question about prepared statements for PHP and mySQL. I have been able to do them for a single row such as ID and such for a particular object, but is it possible to do a SELECT all command as well? I want to be able …

Good Morning, Hopefully there is someone around this morning that can give me a quick and easy answer. Is there a relatively simple way to prevent a page from reprocessing data when someone hits the 'Refresh' button? I don't want to disable the refresh, but just prevent reprocessing and creating …

Hey guys, I'm trying to reupdate a web application that I have going on right now. Originally, I had a php page connect to a database and have a dropdown menu with the list of user id's. When you select the user id, you can submit it and you will …

I have a custom function called "query" with PDO statement in the functions.php file: /** * Executes SQL statement, possibly with parameters, returning * an array of all rows in result set or false on (non-fatal) error. */ function query(/* $sql [, ... ] */) { // SQL statement $sql …

Hi everyone, tried to display next and previous records from the coding below but unable to do so.It suppose to display next records for the current user with the when user click "Next" but currently it doesn't display "Next" but only display "Random". When i clicked "Random", it displays next …

Hi everyone, am trying to display the next record with next button and previous record with previous button from 2 tables. But when i click next there is no record displayed eventhough there are records in the database. The same thing happens with previous button. Please advise. Thanks a lot. …

Hi everyone, am trying to display report based on quarter ie Quarter1,Quarter2 etc. However,after keying in record for Quarter2, the report below does not display Quarter2 record but still Quarter1 record. Please advise how to make the report display Quarter2 record if the current month is Jun etc. Thanks a …

Hi, am trying to display the filename after upload but can't display, instead error message "There are no files in the database" is displayed. Please advise. Thanks. <?php // Connect to the database $dbLink = new mysqli('localhost','user','','pq'); if(mysqli_connect_errno()) { die("MySQL connection failed: ". mysqli_connect_error()); } // Get the ID // …

Linux Mint I logged into phpmyadmin and set the password option to 'no password' and now I can't log in. If I enter the password I was using I get this error -> `#1045 Cannot log in to the MySQL server` and if I don't user a password at all …

hi i have a script that was made up for me a while ago it was working full but now its stopped can anyone see whats going off as the infprmation from the form is not echoing through to another page although its going to database heres database string to …

Hi everyone. Am trying to send email reminder for users to update their progress 1 month before end of every quarter. So every February and May etc the email notification will be autosend to the users from the system. Below is the code. Please advise if this is the correct …