10,940 Topics
 | |
 | Hey, I'm looking for decent MySQL tutorials for connecting a Database in Java. I'm using Java 8 so preferably would like tutorials that correspond with newest code. Thanks!  |
 | I have to make a select to get the info from db from a particular article id it it about an php to mysql database field edit. Thanks in advance! <? include "db.php";//database connection $order = "SELECT * FROM comanda where ['id']=''"; $result = mysql_query($order); $row = mysql_fetch_array($result); ?> <form …  |
| | 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 … |
 | im working on a project .. SCENARIO:::in which we want to collect comment given by 3rd party users or end users and by seeing the comments we should give ratings! My IDEA:: i am grad student- intersted in algorithms and problem solving.. and my intention is to create a two …  |
| | how to insert text box value in mysql using laravel????????  |
| | hi guys , Need help on how to insert files (.docx,pdf and etc.) using laravel . |
| | Hi everyone, I am importing an excel file in php , in that file there are 10 lines,so it read that ten line and saves it in database. After that I inserted five more lines , while again I am inserting , it should avoid the 10 lines and should … |
| | Good Morning, This may be a simple yes or no, or hopefully if it is a no, someone can tell me how to work around it. I have a table that includes 4 columns named the same with incremented numbers in the names step1 / step2 / step3 / step4 … |
| | Dear All, I am looking for a tool which can help me generate reports and multiple types of charts. Can any one recommend based on their experience? I would like to manage to export minimal to excel and pdf too. I have seen one the php report maker unfortunately it …  |
| | I'm preparing a property website. Initially I had written the code for mysql and now moving on to mysqli in order to streamline, make more secure and use prepared statement I don't know much about this and just finding new information as an when needed. I used this tutorial to … |
| | Hello I use Ozeki ng to send sms through database user. The problem: After sending the sms, its status will not be "delivered". It remains "sent" despite the delivery reports arrive through the service provider connection. I followed this [setup guide](http://ozekisms.com/index.php?owpn=164) carefully, I installed the database user again and again, … |
| | Hi, i developing web application in core php. we have five panels superadmin, admin, medical, staff, customer. all records should be display superadmin and created by users. please help me to write a mysql query below my basic query. $user = $DB->prepare("SELECT `u_userid`, `u_username`, `u_password`, `u_rolecode`, `firstname`, `lastname`, `sex`, `age`, … |
| | sir whay this error msg is occurred :Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\aa\connect_db.php on line 4  |
| | how to update multiple update in database using checkbox with php mysql <form action="enableprofile1.php" method="post"> //user id <input type="hidden" name="id1[]" id="id1[]" value="<?php echo $sn; ?>" /> //user id //enable checkbox <input type="checkbox" name="enable[]" id="enable[]" value="1" <?php if($en=='1'){ echo 'checked';} ?> /> //enable checkbox <input type="submit" name="save" value="Save" class="fontBold"> </form> |
| | I have a Yahoo website that uses phpMyAdmin. I've been given the directive "Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" I do not know how to run this script (or any script) through phpMyAdmin. I've been looking online and … |
| | I'm sure this is simple, but I'm having a time trying to figure out how to add two fields from two different tables together. <?php include_once('conn/db.php'); $query = "SELECT SUM(`sold`) AS total FROM veggies"; $stmt = $con->prepare( $query ); $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row); echo "<small><u>Plants Sold</u>: {$total}</small>"; } …  |
| | I am trying to come up with a query to track a student cohort based on their start term. I want to see if the number of students that started in 2012 actually go down in 4 years time. For this example I am starting with fall 2012 (12/FA). I … |
| | I am new for MySQL my tables structures are as follows Table: registration ---------------------------------- | cardNo | mainAgentId |subAgentId| ---------------------------------- | 100 | 1 | 4 | ----------------------------------- | 101 | 1 | 5 | ----------------------------------- | 103 | 2 | 6 | ----------------------------------- | 102 | 1 | 4 … |
| | Hi, sorry for my newbie question but I can't understand what is the different between Logical and Conceptual database design. Can you provide me with some samples for those two types of design? Also what design is generated with MySQL Workbench for example when you import database schema? Is it … |
| | |
| | hello all; scratching my head because I have no clue why this query doesn't work. php5, mysql 5.1 [code]INSERT INTO cats (title,type,cat_parent,cat_descr) VALUES ('Category Name', '0','0','Category Description')[/code] BASIC insert query. and the error I get ad infinitum is this: [CODE]Error: You have an error in your SQL syntax; check the … |
| | CREATE TABLE cash_dtL ( Cash_id varchar(12) NOT NULL, Dateof date NOT NULL, Cash_in_hand number(8) NOT NULL, Cash_in_bank number(8) NOT NULL, Sy_dr number(8) NOT NULL, Property number(8) NOT NULL, FD number(8) NOT NULL, PRIMARY KEY (Cash_id) ); INSERT INTO cash_dtL values('001', '01-JAN-15', 1000, 12000, 1200, 0, 1200); INSERT INTO cash_dtL values('002', … |
| | Hello Everyone, i have table that have some code list if user enter same code from 2 different systems and enter at the same time both user's get data, what i want is the first one will get the data the second one will only see the message that this …  |
| | Hi, I have a sql statement which was running fine yesterday. After making a few changes to the website, it stopped working. I managed to get the statement work on my localhost, however, when I publish the same pages onto the server, I receive the "Operand should contain 1 column(s)" … |
| | Hi Friends i am trying to upload the photos in my dynamic place through my script. my path will be specified below [B]$uploaddir = ../gallery/categoryname/name/[/B] when i was trying to upload the photo is not moved in the above path. unfortunatelly is it moved to [B]../gallery/[/B] Please help me to … |
 | -Suppose I have a table "User_Gender" with fields "idGender,Gender_Name" that has Genders stored in it as Male and Female. -And I have a Select Input Field on My say html.php: <select name="Gender_Selector" onchange="document.forms[0].submit();"> <!-- USER GENDER FROM DATABASE IS CALLED HERE--> <?php $System->Genders();?> <!-- USER GENDER FROM DATABASE ENDS HERE--> … |
| | I'm trying to setup a database and PHP and i did the following: I installed PHP and abyss server. i created a php file in the server as shown in a book and Created a file with the following text in a textfile <?php phpinfo();?> Saved the file as phpinfo.php … |
| | Hi, I am new to yii and php and i want to deleveop a database design for school exam time table and maintain the time table for school management. How can I procced the same? Please help me? :( |
| | $sql = "select u.Id, u.username, u.email, (NOW()-u.authenticationTime) as authenticateTimeDifference, u.IP, f.providerId, f.requestId, f.status, u.port from friends f left join users u on u.Id = if ( f.providerId = ".$userId.", f.requestId, f.providerId ) where (f.providerId = ".$userId." and f.status=".USER_APPROVED.") or f.requestId = ".$userId." ORDER BY u.username ASC"; I don´t understand the …  |
| | I know there are a lot of articles about random numbers, but can't find an efficient way to do what I need. if I have a table that is designed with an auto increment ID for each record, it would be pretty simple to get the min and the max … |
The End.