[mysql] Forum Topics

Hi Wanted to utilize the php/mysql insert into the FPDI pdf export tool. I have it working just as plain text which is nice. But, i'd like to to have mysql place db entries into it. I've declared my sql connection, just using dreamweaver at the moment. I'm struggling to …

Hiya, It seems to me that if I put a condition on ```` mysqli_stmt_fetch($stmt); ```` to check if user credentials was ok enough for the data to be fetched, then the whole purpose of using the following function is defeated. ```` password_verify() ```` This is what I mean .. ```` …

I have a database which contains authors and books. Some of those authors and books contain slashes in the name or title fields. When I query the database for authors, it matches just fine, with or without slashes. When I query books, however, it only finds books without slashes in …

I need to check db for matching user credential on login script. There must be atleast one matching row. Else, script should alert user not registered. Need to check the db using the function ````mysqli_stmt_num_rows()````. Assignment is to list all the various valid ways this function can be used to …

Helle Fellow Programmers! Unlike last time where I was checking for matching rows count using mysqli_stmt_rows_count(): https://www.daniweb.com/programming/web-development/threads/539306/login-with-prepared-statements-mysqli-stmt-num-rows-function On this thread, I am checking for matching rows count using Sql's COUNT function. This means, both threads are not same so mods do not close them. Issue is, on both threads, no …

Hiya, Which of these IF CONDITION codes are valid ? And can you rank the valid ones according to your choice by giving reasons to your choices ? Thanks! 1. ```` $conn = mysqli_connect("localhost","root","","buzz"); $sql = "INSERT into users (username,email) VALUES (?,?)"; if($stmt = mysqli_prepare($conn,$sql)) { mysqli_stmt_bind_param($stmt,"ss",$_POST[username'],$_POST['email']); if(!mysqli_stmt_execute($stmt)) //FIRST CHOICE …

What are some essential skills every web developer should have?

I want to populate report in browser, i prepare this report in i-net clear report, and report file having extension of rpt. I also want to pass parameter

Hello, I do not see $data defined, so what is it ? ```` function prepared_insert($conn, $table, $data) { $keys = array_keys($data); $keys = array_map('escape_mysql_identifier', $keys); $fields = implode(",", $keys); $table = escape_mysql_identifier($table); $placeholders = str_repeat('?,', count($keys) - 1) . '?'; $sql = "INSERT INTO $table ($fields) VALUES ($placeholders)"; prepared_query($conn, $sql, …

Howdy once more, Just got another question on Sql and Php Prepared Statement. How would you confirm a successful row insertion to a mysql table ? Which one of the following lines would you add the IF condition to in order to check insertion successful or not ? 1). mysqli_stmt_execute() …

I am not that much of an expert in PHP as it has been few months since I started playing with it. Currently I am working on creating a basic CRUD operation in PHP. I follow this tutorial on CRUD in PHP (https://www.cloudways.com/blog/execute-crud-in-mysql-php/ ) to create it on a local …

I am making a edit blog option for a website. I am done with the code. Whenever i click the edit button it redirects to the form action file and shows a blank page. Here are my codes. # edit-blog.php # <?php include_once('header.php'); include_once('sidebar.php'); include_once('controller/BlogController.php'); $_SESSION['ap-old']['title'] = $_POST['title']; $_SESSION['ap-old']['short_description'] = …

create table customer ( cname char(20) not null, street char(30), city char(30), primary key(cname) ) create table branch create table account ( bname char(15) not null, bcity char(30), assets integer, primary key(bname), check(assets>0) ) ( account # char(10) not null, ( bname char(15), balance integer, primary key(account#) forigen key (bname) …

Thank you for looking at this problem, details are all below. Below is the code <form style="overflow: hidden;" method="post"> <input type="checkbox" aria-label="Checkbox for following text input" name="kursus[]" value="<?php echo $row['IDKursus']; ?>"> <div class="d-flex justify-content-between mt-3"> <button type="submit" class="btn btn-success" name="daftar_kursus">Daftar Kursus</button> <button type="reset" class="btn btn-primary">Reset</button> </div> </form> if (isset($_REQUEST['daftar_kursus'])) { …

I have a programming code problem, I need help to solve the problem. How to explode data array using MYSQL and using NOT IN. The program code is below <form style="overflow: hidden;" method="post"> <div class="table-responsive"> <?php $sql = "SELECT * FROM kursus WHERE KodKursus NOT IN (SELECT kursusList FROM pensyarahkursus …

Good Evening People, No matter what I do in mysql, why I get this following error where the rows do not get deleted ? **Error SQL query: Copy Edit Edit DELETE FROM `phpmyadmin`.`pma__column_info` WHERE db_name = 'buzz' AND table_name = 'submitted_links_index2' AND column_name = 'title' MySQL said: Documentation #1142 - …

Hi

So I'm new to php but I've managed to create a drop-down that fetches products and displays them, I want to display quantity in the drop-down below it and I have set that up too it fetches other data if the query is modified. The problem is I don't know …

Hi, Are these MySql queries (with Php) correct ? Wild Card match. Fuzzy Match query. Imagine there are 7 columns in the Mysql table. $sql = "SELECT * from $tbl WHERE $col_1 LIKE ? OR $col_2 LIKE ? OR $col_3 LIKE ? OR $col_4 LIKE ? OR $col_5 LIKE ? …

> Hi, this should be simple but I'm having trouble and need help, please. I just want to update the "expiry" value in the "ctltbl" and relocate depending on the value. The update doesn't happen and it goes to sysnav even when expiry is 0. "ctltbl" is 1 row. <?php …

I want to insert the returned values into an array and after to display random string I have this code by it doesn't return back a random value Inside the vid1,vid2,vid3 columsn there is Video Name text that pointing to the video in my File Manager folder $sql = "SELECT …

Work with visual basic 2019 and Mysql database Save and edit record with a imge in picturebox is ok but when i scroll the datagrid i get a datagrid error so i can not show the picture when i scroll picturebox1.image blocking my program

Hi, I am trying to create a login page using the sql's mysqli_stmt_num_rows() function. Issue is, no matter if I give correct password or incorrect, I always get message 'Incorrect user Credentials'. Why is that ? The details on Mysql Looks like this: id|domain|password 0|gmail.com|373b29d2837e83b9ca5cec712a5985843df271cc Obviously, password is hashed using …

Php Programmers, Getting to build a login page using the php's password_verify_() function. Issue is, no matter if I give correct password or incorrect, I always get message 'Incorrect user Credentials'. Why is that ? The details on Mysql Looks like this: id | domain | password 0 | gmail.com …

This function is usefull for peoples with a link directory where the links are stored inside a (MySQL) database. The PHP script is easy to use to find out if a reciprocal link still exists on the corresponding webpage. It takes care about the trailing slash in urls and can …

Help me! I have this number 1726.16723958045672098127. How Can I register in my db MySql. Why is the number truncated?

how to display a record from mysql database list with php

What is best way to get one row from a mysql table (with many columns) so I can use several several fields from that row for calculations in a C program? After executing a succesful SELECT command using mysql_query, is there an alternative to using mysql_store_result?

> Hi, I'm having trouble coding the if/else statement. No matter what value the expiry has, line 17 is echoed. If it is =>1 I want to sysnav.html. <?php $link = mysqli_connect("localhost", "root", "", "homedb"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } //MySqli …

Hi,This code creates a friendly link on user mentions in comments... However, it is not case sensitive and vice versa. Examples; @test works @Test doesn't work The regular expression takes both values. But the query is not catching. I figured it would be a case-sensitive collation on the database. But …

Hi,This code creates a friendly link on user mentions in comments... However, it is not case sensitive and vice versa. **Examples;** **@test** works **@Test** doesn't work What do I do? text = "@test @Test"; $pattern = "/\@(\w+)/"; preg_match_all($pattern,$text,$matches); if($matches){ $sql = "SELECT * FROM users WHERE username IN ('" .implode("','",$matches[1]). …

i have 3 tables : users, deposit, withdraw **table users :** id , username, referral 1. 1, a1, null 2. 2, a2, a1 3. 3, a3, a2 4. 4, a4, a1 5. 5, a5, a2 **table deposit :** id, users_id, amount, status, approve_date 1. 1, 1, 10000.00, approve, 2022-10-01 14:52:53 …

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 …

I'm wondering how to update my database using a modal and multiple data from another form. This is how it looks like,  When you click any checkbox there, the release request button will enable.  When it was clicked there's a modal will pop up:  Now, the modal …

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 …

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 …

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

Hi ppl I am developing website for my friend's very small resort, please see [url removed] this resort have 8 rooms in total and all rooms are of same type so every room is equally priced. I just need code or logic to check availability of given [B]no. of rooms[/B] …

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.  Here's what it looks like.  When I try to select one …

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 …

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!'); } …

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

can someone suggest me how to build referral system with code referral and bonus table mysql

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 …

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 …

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 …

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

I have a table with the below sample output. uid atime adate A_in_out 11 8:16 14/05/2014 I 11 13:35 14/05/2014 I 11 17:23 14/05/2014 I 11 21:09 14/05/2014 I 12 14:06 14/05/2014 I 12 22:39 14/05/2014 I 13 8:00 14/05/2014 I 13 17:12 14/05/2014 I I want to build a …

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

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 …