72 Topics

Member Avatar for
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
293
Member Avatar for ianhaneybs

I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats …

Member Avatar for le5691
0
57
Member Avatar for Kando_1

Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is …

Member Avatar for Dani
0
68
Member Avatar for Channel_5
Member Avatar for derick_3

<?php $pdo = new PDO('mysql:host=localhost;port=3306;dbname=crud', 'root', ''); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $title = $_POST=['title']; $description = $_POST = ['description']; $price = $_POST = ['price']; $date = date('Y-m-d H:i:s'); $products = $statement = $pdo->prepare("INSERT INTO products (title, image, description, price, Create_date) VALUES (:title, :image, :description, :price, :date)"); $statement->bindValue(':title', $title); $statement->bindValue(':image', ''); $statement->bindValue(':description', $description); …

Member Avatar for Dani
0
36
Member Avatar for Ąfnąn_1

Create database with the name of "university". You have only two table with the name of "signup" and "student". In Student table you will collect all data of student like cms, name, address ,age, mob and cnic. Perform Multiple Task which are given below. 1) Create Login and Signup page …

Member Avatar for rproffitt
0
44
Member Avatar for messiahjoseph39

Good day, I am actually a young programmer, who wants to develop a webpage that enables someone to take a practice test. It was given to me as an assignment that determines if I will remain a programmer. I know little about PHP codes but none in Mysql. I came …

Member Avatar for NeighborDave228
0
166
Member Avatar for nishita_1

please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg)

Member Avatar for Santanu.Das
0
315
Member Avatar for gamersADDA

#Parse error: syntax error, unexpected '$Email' (T_VARIABLE) in C:\xampp\htdocs\test1\connect.php on line 3 <?php if(isset($_POST ["password"]) $Email=$_POST['email']; $password=$_POST['password']; $conn = new mysqli('localhost','root','','test1'); if($conn->connect_error){ die('Connection Failed : '.$conn->connect_error); } else{ $stmt = $conn->prepare("insert into login(email,password) values(?,?)"); $stmt->bind_param("ss",$Email,$password); $stmt->execute(); echo "login Sucessfully..."; $stmt->close(); } ?>

Member Avatar for effu
0
184
Member Avatar for AliGulSoomro1

I have a database, where I store Job Openings, Where I store Job Descriptions with formats in RichText Box like: bullet points, ordered lists and bold text etc... But when I save data in MySQL Database and Retrive it from Database it comes format less. Can anyone help me regarding …

0
132
Member Avatar for Glen_4

I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the …

Member Avatar for Glen_4
0
354
Member Avatar for Rhemiel

This is the process I want to attain: 1. I have 4 buttons 2. Each 4 buttons have categories under it 3. When those categories is selected it shows list of datas 4. The datas are like powerpoint empty slides Can Someone give me some idea how to create relational …

Member Avatar for alan.davies
0
345
Member Avatar for prochotap

In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and …

Member Avatar for rproffitt
0
351
Member Avatar for Thodoris_1

Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, …

0
323
Member Avatar for savedlema

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and …

Member Avatar for Daniel_87
0
738
Member Avatar for random_1

Hello, I have a products page which lists the pics of the products. I added pagination with bootstrap classes. I have 10 products in my database. I want to limit per page to display only 6 so then the second page should display 4. The issue im facing now is …

Member Avatar for AndrisP
0
298
Member Avatar for jeffersonalomia

Hi, I would like to ask for help with regards on my problem on my phpmyadmin - mysql database. I am using wamp server 2.5. So here's the scenario, I try to insert data on two tables (accounts, user_info) on mysql @ phpmyadmin using php ajax. Now the problem is …

Member Avatar for diafol
0
258
Member Avatar for genieuk

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** = …

Member Avatar for genieuk
0
747
Member Avatar for davy_yg

Hello, I am trying to reset mysql myphpmyadmin password: Cannot log in to the MySQL server Username: root Password: 12345 And have not been successful yet reseting it. This is my config.inc.php <?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] …

Member Avatar for davy_yg
0
327
Member Avatar for Bchandaria

when ever i am inserting any of the symbols like cosec^2Ɵ (cosec power 2) it will display inline. i won't that to be displayed with raise to 2 or subscript or superscript of it. How to get Displayed that using utf-8 unicode characset ?

Member Avatar for ryantroop
0
174
Member Avatar for lewashby

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 …

Member Avatar for cereal
0
4K
Member Avatar for nadiam

hello, I am having a problem opening my database. Before this I could directly go to phpmyadmin after logging in to cpanel without entering username/password. Today, I was directed to a page to enter username/password before going to the database so I did but I got this warning: Warning in …

Member Avatar for diafol
0
2K
Member Avatar for anmol.raghuvanshi1

i have continued my developing my code on e-commerce website to grant the discount to client on basis of coupon code entered <?php /** * Consider and apply voucher codes * Types of voucher code * - = FIXED AMOUNT OFF * % = PERCENTAGE OFF * s = SET …

Member Avatar for matrixdevuk
0
341
Member Avatar for anmol.raghuvanshi1

hello every one i have one small doubt i have the following code i want the user to enter the coupon code which has been randomly generated and saved in database now i want that when user enter the coupon code it is cross checked from database i.e entered coupon …

Member Avatar for broj1
0
290
Member Avatar for anmol.raghuvanshi1

hello every one i am creating form of 15 question length for 5 questions it worked but when i increase the length of question to 15 or 18 dont work plz help me it's urgent <?php //Start session session_start(); //Include database connection details require_once('connection/config.php'); //Array to store validation errors //$errmsg_arr …

Member Avatar for diafol
0
269
Member Avatar for kaprikorn07

Hi All, Please let me know the steps to install PHP, MySQL and PHPMyAdmin on RHEL machines.

Member Avatar for veedeoo
0
188
Member Avatar for zeeshan009

Hi All, I am developing a website in which i am selecting some values form database by a query When i am running query on PHPMyAdmin i am getting desired results but when i am using this query in actual PHP code, i am getting value of Last row. Can …

Member Avatar for gabrielcastillo
0
222
Member Avatar for stokie-rich

Hi guys i'm creating a new table in sql to allow users to register with my website, this is the sql code that I'm suing does this seem ok to you? CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( `Firstname` …

Member Avatar for parijatziw
0
369
Member Avatar for suika

Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, …

Member Avatar for hapticz
0
668
Member Avatar for azapovjednik

hello all I am a beginner... I want to move a wordpress site from a local computer to live server... live server: plesk parallels I followed some tutorials and it says: you must create a new mySql database on server... ok I went to parallels plesk panel and I created …

Member Avatar for azapovjednik
0
1K

The End.