10,946 Topics
 | |
| | Hi i am trying to insert pdo multiple checkbox value in one column into database and display it to the user, but i am getting this error Error: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined.I cant see the error and dont know how to fix it. :( That is … |
 | I have a code in two files and I want to convert it from mysql to mysqli. func.php: <?php $con = mysql_connect('*','*','*'); mysql_select_db("*",$con); function search_results($keywords){ $returned_results = array(); $where = ""; $keywords = preg_split('/[\s]+/',$keywords); $total_keywords = count($keywords); foreach ($keywords as $key => $keyword) { $keyword = strtolower($keyword); $where .= "LOWER(`keywords`) …  |
 | Hello Dears, I need to show all list of website authors on /author page like my website http://quotemessages.com/author here I want to show All authors can someone guide me please when I access it normally in WordPress it shows me 404 error :( I want to show alphabetical list of … |
 | Hi Everyone, I have a real noob question please, I am trying to update a mysql database using the code below, I know the invoice number variable is correct, But for some reason the database is not updating, Can someone point me in the right direction please, I have tried … |
 | **I can't update inserted data via GUI, Its working well on inserting records before I modify it, and when am trying to modify in order to update inserted data its not update as I expect to happen. I can display inserted data well by echo them to GUI Below is … |
 | Guys, i am getting an unexpected T_While Error on my code, I cannot figure it out. can you help? ` <?php` $sql = "SELECT id, u_name, u_email, subj, phone FROM tb_cform "; $result = $conn->query($sql); echo '<table><tr><th>Name</th><th>Email</th><th>Subjec</th><th>Phone</th></tr>'; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "<tr><td>".$row["u_name"]."</td><td>".$row["u_email"]."</td><td>".$row["subj"]."</td><td>".$row["phone"]."</td></tr>"; … |
 | hi..so i am facing problelm how to upload data on my websites in which format (.pdf,etc) should upload data and how to do it. |
| | Hello everybody, I'm stuck with this and I hope there is somebody who can help me. I have a Form <html> <form action="" method="POST"> <input type="text" name="credentials[firstname]"> <input type="text" name="credentials[lastname]"> <input type="text" name="credentials[email]"> <input type="text" name="game[points]"> <input type="text" name="game[wins]"> <input type="submit" name="submit"> </form> </html> and I want to post the … |
 | Hello ladies and gents, i hope you are all well! Just recently joined this site looks great and easy to use. I am just getting into php and msql i have managed to create a table that spits out the data but i am looking for a really simple way … |
 | My code works with echo but if I use return it wount display the wanted data, but i want to use code with return so the data will display wherever the shortcode is inserted and not just at the top as it is with echo. So here are the codes … |
 | Guys,I have my table data ,I want to retrieve them to pdf file using php,The problem is,when I use 'where condition' in a select statement, I do not receive any data,but when I do not use ,I get data from one row from the database table.Any help please!! <?php session_start(); … |
 | I get the error "Warning: mysqli_close() expects parameter 1 to be mysqli, null given in" and I can't find a problem. Can anyone help, here is my code. $username = $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; $CheckSQL = "SELECT * FROM users WHERE email='$email'"; $check = mysqli_fetch_array(mysqli_query($con,$CheckSQL)); if(isset($check)){ echo …  |
| | Hi everyone hope you are ok i have mistake in my php and i cant find it. please help me I need to create 3 php . create table , insert_pdo ands select data. That is my html: ` <form action="" method="get"> <!-- Search box --> <input type="text" name="search_text" id="search_text" …  |
 | Hiya Folks, Why is not mysql getting UPDATED, do you reckon ? <html> <head> <title> <?php $user?> Home Page </title> </head> <body> <body background=".png"> <?php session_start(); require "conn.php"; /*Check if user is logged-in or not by checking if session is set or not. If user is not logged-in then redirect … |
| | Having an issue passing info from the modal to the model so that I can do a where statement. The first line below is the link to open the modal. Works fine no issues. <td><a href="javascript:;" class="openModal" data-toggle="modal" data-target="#email_details_<?php echo $SP->fit_tv_rollout_info_id;?>"> <span class="glyphicon glyphicon-info-sign" aria-hidden="true"></span> </a></td> <div id="email_details_<?php echo $SP->fit_tv_rollout_info_id;?>" … |
 | **id Autor Title ** 1 xyz DCN when i click Dcn go to load book pdf url help me |
 | Hi, i have a db system where i fetch results from two tables. A user and transaction table. In the transaction table i have two columns which are sender and reciver id which refence in the user table. how do i get a sender name and receiver name in a …  |
| | Hello People, Do you know why iframe is not opening to the url (variable value) ? Here is latest update of the code but still it shows not the variable value as the iframe URL. Variable calls db row data. Mysql column "Latet_View" has an entry on position zero: http://www.google.com … |
 | Need Help to create **Gmail** style realtime chat app for my website. I found server for realtime chat here https://xmpp.org/software/servers.html (I will go for [ejabberd](https://www.process-one.net/en/) or [Openfire](http://igniterealtime.org/) **or** which one should I choose?) **Goals** 1. send & receive chat request 2. accept or reject request 3. show sent/pending chat request … |
 | Please guy am new to php am writing a project now.....but I want to be sure how to merge a user to another user with same amount or figure (project idea ponzi scheme like mmm)  |
 | I wish to get good training about HTML scripting,i need to be developing web based aps,therefore i ask for experts in scripting languages like ASP.NET,PHP&Python but first,i need to go with HTML. |
| | Hi, I have used current_timestamp, i am submitting same values then current_timestamp not updating. I have used below for updating timestamp. (timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) Kindly help me to update timestamp, on every hit |
| | hi im new in php im trying to create a log-in system but i got an error need your help guys THIS IS MY LOGIN PROCESS <?php require 'connect.php'; $employeeno = $_POST['employeeno']; $name = $_POST['name']; if(isset($_POST['LOGIN'])) { $query = "SELECT * FROM tbl_employee_information WHERE employeeno='$employeeno' AND name='$name'"; $query_run = mysqli_query($query,$db); … |
| | Programming Buddies, Looking at this youtube channel, do you think as a beginner in php (starting at php 7), the channel is good for me to learn php 7 (and no previous version to avoid learning deprecated stuffs) and pdo of php 7 ? Check his php series and then … |
 | Last night, a friend mentioned to me that one day he was trying to fetch a random 5 rows from a MySQL database. He researched online, and was eventually presented with a working solution in which he would generate five random numbers. Then, he would query the database for items …  |
 | hi ive got a html table echoing through php and im having problems displaying image in the table heres what i have so far if($fetch_image['user_image']!='') { echo '<td>'.$fetch_image['user_image'].'</td>'; } else { echo '<td>'.<img src='images/blank_big.jpg' height='150px;' width='150px;' />.'</td>'; } and here is the fetch section $user_image = mysqli_query($conn,"select * from user_images … |
| | good got job nearly finished but one slight glitch i have 2 entries in database but only one is showing twice in table results how can i get to show both results heres code fetch and connection block <?php include("config/db_connect.php"); //include("config/ckh_session.php"); $sql = "SELECT * FROM meets"; $result = mysqli_query($conn, … |
| | Hi All, I'm currently designing a website for my business and would like to have a system that pulls products from my database via PHP and adds them to my products section, but I'm unable to find anything that explains how to do it for the kind of setup I … |
| | Hi, I am using php 7 and I do not know why the following 2 different codes for user the user registration page is not working.*The login page php is working, though. I would appreciate the communities feed-backs. Thank You! |
| | <pre>Hi, I'm a beginner in php. Starting my learning at php 7 and not 5 or earlier. I don't understand why php 7 is acting weird. It give different result at different time. Do you guy mind checking if I got the coding wrong or if I've come across a … |
| | im asking can it be done??! with example plz thanks |
| | How do facebook, twitter, and other social media app store the data of the user's chat history or chat log? Is it on the database or on a separated file? How can i create a professional chat application on my website?  |
 | HI, I have the below php code that i am attempting to use to search the database for a value that has been inputted in the form. This connects to the database and works fine but brings back no results. I found the following error: Warning: mysqli_num_rows() expects parameter 1 … |
| | HI, I have attempted to put a login page on to my web page that i am developing as a learnig curve. I am almost there i think, i have created a table in my database that stores the username and passwords and i have a php script that i … |
| | hi im attempting to add mysqli_real_escape_string into form to make more secure and after i added it in code below $event_type = $_POST['event_type']; $event_date = $_POST['event_date']; $event_country = $_POST['event_country']; $event_postcode = mysqli_real_escape_string($conn, $_POST['event_postcode']); $event_title = mysqli_real_escape_string($conn, $_POST['event_title']); $event_description = mysqli_real_escape_string($conn, $_POST['event_description']); $event_ltm = $_POST['event_ltm']; like so and go to fill … |
| | SO Basically i have this problem with this test build of a little project im rewriting and so far its not looking to good I have multiple tables that are all the same, they have been set up this way for simplicity as far as i can tell. Tables +----+----------+-----------------+---------------+-------------------+ …  |
 | I want to make knew website but can under stand how to write it . so please help me out . |
| | Hi everyone.. I would like to know how to upload an image into mysql database using php. Can anyone please help me in this regards. |
 | Hi Everyone Dont know if this is the right place to ask this but i Just wanted to consult anybody of you that might have an idea on what this core dump message means. Yesterday my website is down for almost 30 min and when i called the hosting provider … |
| | Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected … |
| | how to export my table data which is in mysql database to a csv file I am not getting any error or exception but my csv file is empty after successful running this code. code what i did: import java.io.FileWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; import java.sql.SQLException; …  |
 | TABLE_ROWS 13 1 8 5 2 3 5 2 7 6 3 4 3 32 my select query results a table like this .Here i want to assign each item to each variables . a=13 b=1 etc... i tried with forech but i did not get out put.Here is my …  |
| | How can I do a bulk insert of rows but only if specific combinations of columns don't already exist? Those columns are not unique to the table. (Otherwise I could easily use INSERT IGNORE). Rather, I just need this to happen for one particular SQL query. |
 | I'm trying to retrieve the values of checkboxes in a custom post type. My complete function: function getTeam() { global $post; $team = new WP_Query(); $team->query('post_type=coaches'); $workshops = get_field('workshops'); if ($team->found_posts > 0) { echo '<ul>'; while ($team->have_posts()) { $team->the_post(); $listTeam = '<li>'; $listTeam .= '<a href="#" class="js-modal">'; $listTeam .= … |
 | Hello Sir, I am developing social networking website using jsp and servlet . I have created login page using mysql but now i am not able to make posting status and commenting system on that post.Please provide me solution. thankyou aayush |
| | Hi, Not done any programming for a few years so am somewhat rusty again. I have two tables **users** table and **users_profiles** table. I want to update **users_profiles** table on the condition that **user_uid** matches on both tables (**users.user_uid** and **users_profiles.user_uid**) and where **users.user_login ** = 'johndoe' and **users.user_uid** = … |
| | Can Somebody help me? i have an error whenever i want to save the data i have retrieved from different table in mysql. my system is doorlock system. im going to choose an item in the combobox and when i click the button, the data i'd chose from the combo …  |
| | Ok... back to my PHP/Wordpress adventure. In my testimonials post type I have added 5 custom fields and 2 fields are not mandatory which means they can be empty. One of them is the url field which I want to output within my while loop with a different HTML when … |
 | Hi to all the old familiar faces, have not been here for a while... I have read up on tons of samples and answers (and even more on how cryptography works) but none answers my scenario. I am creating a new user from desktop app in VB.Net. User need to … |
 | I want to collect basic user information when they land on an index page, such as: IP Country City State Zip Code I've looked into sites such as ipinfo.io that offer a service regarding these details, but think it may be easier to collect the same info via PHP. From … |
The End.