[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 …

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, …

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 …

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 …

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 …

helloo....guys need a favour from you....okay this is the scenario i have a attribute called document_no, now i would like to append running numbers behind it to fill in a new attribute eg: document_no = 123222 serial_no = 12322201 12322202 12322203 now the number starts from 01 and go on …

Hi, I'm creating a web page which links to a mysql database. I have managed to get all of the data to appear in a table and i have also been able to get the combobox to be populated based on a table in the database. The part which I …

I have a MySql database that uses a time field to track when the entry was inserted. Now I want to query the table for entries by a time range. I would prefer to use MySql to extract the records instead of extracting all records then iterating and comparing time …

hello there, i'm having a bit of trouble about this. im making a regiter page for our project and im using PHP, and im having a little problem, it says that: Could not execute the insert query.. but i got all my fields right?.. [ICODE]<?php include("config.php"); if(isset($_POST['submit'])) { $fname = …

I'm new to php mysql. i'm creating website for my community. help me out... My web page has one search page. user to feed few letters in the search box. it is proceesed and the result displaced in a table. here is my code [COLOR="Red"]for getting input : search.php[/COLOR] [CODE] …

Hi Friends I have pasted the code below which i was used in my project. But i am getting mysql_fetch_array() error. For your more information i have attached the screen shot of the error Pls give me solution [CODE]<?php // Inialize session session_start(); include("../config.php"); // Check, if username session is …

I am trying to store millions of records with address, city, state, zip, etc. I originally had one table with 17 different fields with the primary key being id. However, I soon realized after inserting almost a million, the website began to lag and was slow. What is the best …

Hello, I have a form from which I post some data into 3 tables: when I click on the submit button I don't get any error message from mysql_error(); but when I look to my 3 tables I see no one of them has received the data I just posted …

I have a script that I am using to retrieve zip codes within a certain radius using a foreach php statement. However, with these zip codes that I am getting, I want to add a comma between each value (for example: 11111,22222,33333) to use in a SQL query using the …

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\eUTM\login\logincheck.php on line 13 here is the code: <?php //login check require_once("dbconn.php"); $con=connectdb(); $idpengguna=$_POST['idpengguna']; $katalaluan=$_POST['katalaluan']; //login PELAJAR from table pelajar $pekerja_query="SELECT * FROM pengguna where idpengguna = '$idpengguna' AND katalaluan = '$katalaluan'"; $pekerja_result=mysql_query($pekerja_query,$con); $pekerja_row=mysql_fetch_array($pekerja_result); if(!$nama_id && !$katalaluan) { $err=1; …

[B]The Idea[/B] The idea is that my PHP page will execute specific SQL statements on a database depending on which form elements are filled in. Instead of having to write continuously lengthy IF statements to determine which statement to use, I would like to have the necessary statement "looked up". …

I want to map a field, city, from a MySQL database into Google Maps. I found a nice script to do it, but haven't been able to get it to work. If I hard code an array into locations (var locations = ['Seattle', 'New York']), it works fine. Passing this …

Hello, thanks for reading my thread. I'm still new to web development so I appreciate your help in advance. Here is the issue I am having: In my project, I have a index.php page with a sidebar menu and a div id called “content”.The user can select different menu items …

I have created a search bar using PHP that pulls from my database by keywords typed in the search bar and displays links and descriptions of URLs' associated with the keywords. Is there a way for robots to randomly type keywords in my search bar on my website to list …

hey people i wrote this code and i got a problem , i cant register a session . this is the login form : [CODE] <?php if(!isset($_POST['username'])) { $title = "- signin"; include "header.php"; include "nav.php"; ?> <form action="" method="post"> Username :<br /><input type="text" name="username" size="70" /><br /> Password :<br …

Hi Daniweb, I am confused, how to explode the numbers from database. Simply I can Explode, but after explode I have to relate the numbers to another table. If any one not clear abt my problem, pls reply Eg: 1, 2 Relate to Basket, football [CODE] $sql1=mysql_query("SELECT impid FROM customer …

How can I use explode function in php I already implode some data in mysql [CODE] // customer table cust_id, impid, 1, 1,2 // sports table sport id, sport name 1, football 2, basketball [/CODE] How can I explode and make a php/mysql query

[CODE]<?php include("includes/connection.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) {echo $City= $row['City']; echo $Name=$$row['Name'];} ?> </body> </html> [/CODE] i just …

Hi, i have made a form in which people fill out their details and its gets saved in database with [CODE] $today = date("F j, Y");[/CODE] now i want to make a search for that forms with date , like Search with in last 3 days or Last 6 months. …

hi everyone i need your help i want to write a code that gets for me the latest 5 out puts here is my code [CODE] <?php $con = mysql_connect("localhost","awah","pass"); if(!$con) { echo "cant connect to db".mysql_error(); } $select = mysql_select_db("awah_admin"); if(!$select) { echo "cant select db ".mysql_error(); } $query …

Greetings, I got no clue how to make / set a session. When i login on my page and then press a link i get out-logged, I've tried to read on PHP.net but i cant get it together. Anyone got an explaination or code i could go from to keep …

[B]Greetings![/B] Anyone here who can correct my code? I'm abit noob to PHP, just started learning. The Ban file function of mine does the echo but it wont stop the file upload. Any idea? have i inplented it wrong or do i miss a line? Love you long time if …

I tried lot of way to pass the checkbox values from page 1 to page 2. But I only get successes on fruit id, how can pass the fruit charges. [CODE] // how can I pass room charges"$result[room_charges]" to page 2 // page 1 $sql=mysql_query("select * from fruit"); while ($result …