10,940 Topics

Member Avatar for
Member Avatar for Stefce

I am trying to insert into table with PHP and MySQL but the page only refresh it self when i press the button. I haven't done debugging, i have an IF statement that displays any errors that fires if the SQL query have errors. But the thing is even the …

Member Avatar for gce517
1
212
Member Avatar for Nine_2

I'm wondering how to update my database using a modal and multiple data from another form. This is how it looks like, ![1.png](https://static.daniweb.com/attachments/4/9f1a52cdeffddb99e65e6d73d8febd7b.png) When you click any checkbox there, the release request button will enable. ![2.png](https://static.daniweb.com/attachments/4/1db9299fc8e0995c48be16f9b41f4cc0.png) When it was clicked there's a modal will pop up: ![3.png](https://static.daniweb.com/attachments/4/4bc7fe8fc346f118c3c3282c341ac6bb.png) Now, the modal …

Member Avatar for devphp
1
685
Member Avatar for aibreansiyue

So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem …

Member Avatar for gce517
0
133
Member Avatar for sharmavinu0024
Member Avatar for jj.dcruz

I have this code foreach loop it will get the first data form my table every iteration on the next output. I would like to have a guidance on this <select class="selectpicker form-control" data-live-search="true"> @foreach ($IncidentTypes as $Incident) <optgroup label="{{ $Incident->incident_type ." ". $Incident->id }}"> @foreach ($Incident->IncidentSubType as $subTypes) <option> …

Member Avatar for Dani
1
230
Member Avatar for Ahmad_74

Hi ppl I want to known about the availability check of hall booking I'm developing a website which is based on the venue booking system but i want to add availability chrck form in it so the same hall not booked at the same start time or same date There …

Member Avatar for rproffitt
0
34
Member Avatar for forgot

I have a project that no one can or wants to engage in. The data is in a database table. The code displays a menu, selects a target (url - http://.....), displays the record - so far so good....then I want to click the button and redirect to the url.... …

Member Avatar for akvkota
0
120
Member Avatar for Nine_2

I have this form where I'm editing a student's information like changing the provider assigned to him. I'm having a problem with it since the dropdown menu is coming from MySQL database that has the full name. ![provdata.png](https://static.daniweb.com/attachments/4/c03e715e350cced146c03f6dd137b822.png) Here's what it looks like. ![provider.png](https://static.daniweb.com/attachments/4/0e91d237fb3e840d96ee1c350432a974.png) When I try to select one …

Member Avatar for Dani
0
122
Member Avatar for ianhaneybs

I am in the middle of making a web based system for shows and each show as a different closing date for entries. The closing date is stored in a database. I need to display a export to excel button once the closing date has passed for each show. I …

Member Avatar for Dani
0
104
Member Avatar for borobhaisab

Hi, I am not sure which mysqli error reporting function to use here. Which of the two is correct ? 1. if(!mysqli_stmt_prepare($stmt,$sql_count)) { echo __LINE__; echo '<br>';//DELETE echo 'Mysqli Error: ' .mysqli_stmt_error(); //DEV MODE. echo '<br>'; echo 'Mysqli Error No: ' .mysqli_stmt_errno(); //DEV MODE. echo '<br>'; die('Registration a Failure!'); } …

Member Avatar for Dani
0
104
Member Avatar for Vmr_574

Hello all, I would like to set a time after 2 requests that someone can make a request again does anyone have an example for this. thanks in advance

Member Avatar for Dani
0
104
Member Avatar for Ant_426

Hi. Please could someone help me understand what's happening here. I have a MySQL database which has a table with some data in the following format: 2022-03-15 06:55:39:<br/>LineOfSight:<br/>java.lang.Exception:<br/> UNAVAILABLE TELEMETRY BR$0 The field collation is utf8 and the data is stored as text. This data is provided via a 3rd …

Member Avatar for Dani
1
383
Member Avatar for Simran_14

This question is relation to a Node.js - express - Sequelize - MYSQL application. I am trying to test my application using Curl command but I am getting "Invalid Departure Time" error. This application is also using Luxon. I have tried all the possible fixes I could but nothing is …

Member Avatar for pritaeas
1
31
Member Avatar for Simran_14

Hello everyone! This question is related to using Sequelize with Node.js and MySQL. I have come across a small doubt and need your help. To enable CLS with Sequelize we initialize a CLS namespace using the following lines of code: ``` const cls = require('continuation-local-storage'); const namespace = cls.createNamespace('custom-sequelize-namespace'); const …

0
28
Member Avatar for abu taher

I want to make a pdf file in php. I write code like this: <?php require_once __DIR__ . '/vendor/autoload.php'; include('conn.php'); $res = mysqli_query($conn, "select * from smash"); if (mysqli_num_rows($res) > 0) { $html = '<table>'; $html = '<tr><td>ID</td><td>Name</td><td>FatherName</td><td>Address</td><td>Phone</td><td>Class</td><td>Qualification</td><td>Branch</td><td>rollno</td></tr>'; while ($row = mysqli_fetch_assoc($res)) { $html .= '<tr><td>' . $row['id'] . '</td><td>' …

Member Avatar for mtyide
1
628
Member Avatar for Vmr_574

hello, i hope someone can help me i have a table ip in my database if there is 5 times in it he has to forward it in php to another page. thanks in advance

Member Avatar for Dani
0
297
Member Avatar for Jaziel_1

I have created a form using HTML, now I won't save the input data into my browser's local storage DB. I want to same multiple inputs, not just one. how do I do it I believe I need to use javascript but I'm not strong with it and am still …

Member Avatar for 𝙹𝚊𝚜𝚖𝚒𝚗𝚎(ダーリン)
1
705
Member Avatar for rahull.singh098

The term SQL stands for Structured Query Language, it's a programming language that's used to update and communicate with the database. SQL skills are indispensable and are in demand as with the boost in technology, data is piling up. And, In today's world this data has become a necessity for …

Member Avatar for pritaeas
0
96
Member Avatar for kaykayandcoffee

I need help on how to calculate the total work hours in a 12 hour format. I have a database that has the columns for the time in and time out as well as the total hours. Try If txtSCANRFID.Text = "" Then Else reloadtxt("SELECT * FROM students WHERE RFIDNumber= …

Member Avatar for Schol-R-LEA
0
113
Member Avatar for Aisha_sg

hey I'm beginner learning php have hard time to Insert data to product in database with image because the category I did make it work but now I need to update data the same style that I add it with the Insert Code: <?php include('./pro_crud/config.php'); $sql_cat = "SELECT * FROM …

0
245
Member Avatar for FarrisFahad

I have a couple of scripts from the same template but different version. I am using php and mysql. I need to know how to update the mysql database and the script from version 1 to version 2 with a single click.

Member Avatar for Dan Fredeinburg
0
101
Member Avatar for ezeiruchibuike

Hello there, I created a "users" table on MySQL and created a few columns namely "accountbalance", "ledgerbalance" and "dailybalance" (all three: BIGINTs). I created a test user and added some random figures. I am trying to retrieve the value of this columns (unique to the user) and them pasted separately …

Member Avatar for Dani
0
427
Member Avatar for abu taher

I want to auto generate the id number. I write this code. But it's not work. I don't make primary key for id in database. function getData() { $data = array(); $data[1] = $_POST['name']; $data[2] = $_POST['fname']; $data[3] = $_POST['address']; $data[4] = $_POST['phone']; $data[5] = $_POST['class']; $data[6] = $_POST['qualification']; $data[7] …

Member Avatar for abu taher
0
170
Member Avatar for John_358

import net.proteanit.sql.DbUtils; import javax.swing.*; import javax.xml.transform.Result; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class EmployeeRegistriation { private JPanel Main; private JTextField txtName; private JTextField txtSalary; private JTextField txtMobile; private JButton saveButton; private JTable table1; private JButton updateButton; private JButton deleteButton; private JButton searchButton; private JTextField txtId; private JScrollPane tabla_1; public …

0
68
Member Avatar for RC_820

hii guys i have web site need to generate random progress like this ![messageImage_1650466235444.jpg](https://static.daniweb.com/attachments/4/4177f476696ea21823be5ca5550a7b39.jpg) can some one suggest me how can i make it

Member Avatar for Dani
0
88
Member Avatar for Vmr_574

Hi all, I hope someone can help me with the following. I have a script that reads a txt file and displays the correct values. I only want to add it to the database now, but I can't manage this. below the script <?php include '../includes/connect.php'; if(!$conn) { die(mysqli_error()); } …

Member Avatar for Nick_42
0
136
Member Avatar for Intan Farizatul

hi, i have some problem with my php code. when i run the php, the page keep loading and no output displayed. here is my code: $dayBeforeNew = $_GET['daybefore']; $dayAfterNew = $_GET['dayafter']; $sql = "SELECT reference.LOCID, reference.Region, Sitename, (SELECT `Data Total Traffic` from 4g_statistic where reference.LOCID = 4g_statistic.LOCID AND 4g_statistic.Day …

Member Avatar for Biiim
0
268
Member Avatar for forgot

Guys, what am I doing wrong? The database "expiry" value is > 0 but I go to expiredpage.html. ======================================================== the code: <?php $link = mysqli_connect("localhost", "root", "", "numbersdb"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } echo "<center>";echo date('m/d/y');echo "<br />"; $id='id'; $expiry='expiry'; if($expiry==7) …

Member Avatar for pritaeas
0
34
Member Avatar for Fireytech

I have a subform called "Contacts" embedded on my "Tickets" page. I want to create an edit button to jump to my contacts_edit.php page and use the 'ContactEntryNumber' (the unique key from my Contacts table) for the displayed contact record as the updateID. I have played with this and read …

Member Avatar for Fireytech
0
63
Member Avatar for FarrisFahad

Hello webmasters, I am trying to create a script using vanilla PHP. I am familiar with the language and I have created a cronjob before, but only using cPanel. I want to create cronjobs using PHP if possible with out the need to go to cPanel. I am trying to …

Member Avatar for Dani
0
67

The End.