72 Topics
|
|
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 |
|
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 … |
|
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 … |
|
I want to create button delete all records in tables database with php |
|
<?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); … |
|
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 … |
|
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 … |
|
please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg) |
|
#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(); } ?> |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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, … |
|
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 … |
|
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 … |
|
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 … |
|
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** = … |
|
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'] … |
|
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 ? |
|
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 … |
|
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 … |
|
|
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 … |
|
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 … |
|
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 … |
Hi All, Please let me know the steps to install PHP, MySQL and PHPMyAdmin on RHEL machines. |
|
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 … |
|
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` … |
|
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, … |
|
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 … |
The End.