10,942 Topics
 | |
| | Hi every one. I want to create a software for my windows phone 8.1 but already stucked on online database. I tried to use this VB code that I use for 1 of my softwares Mysqlconn = New MySqlConnection Mysqlconn.ConnectionString = "server=db4free.net;Port=3306; user id=a****; password=******; database=****" Try Mysqlconn.Open() Dim Query … |
| | how to insert multiple checkbox values in multiple rows mysql database using php pdo? Please give multiple insert option Here is my script: $create = sizeof(isset($_POST['create']) ? $_POST['create'] : array()); $edit = sizeof(isset($_POST['edit']) ? $_POST['edit'] : array()); $delete = sizeof(isset($_POST['delete']) ? $_POST['delete'] : array()); $view = sizeof(isset($_POST['view']) ? $_POST['view'] : … |
 | Hi i have a table called hospitails. the table structure is as below **Hospitals:-** Hospital_id Bigint name varchar(45) city_id bigint district_id bigint state_id bigint now i need to search hospitals based on name,city_id,district_id,state_id. the query must cntain all the 4 fields. when user does not provide any of the value … |
 | 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 … |
The End.