10,946 Topics
 | |
 | my code is messing up. help: if (mysql_query("CREATE DATABASE $dbname",$con)) { echo "Database Created<br>"; $dbase = $_POST["CallSign"]."char"; mysql_select_db($dbase, $con); $sql = "SELECT * FROM $dbase"; $result = mysql_query($sql); if ($result) { echo "CallSign Accepted<br>"; mysql_select_db("my_db", $con); $sql="INSERT INTO users ( CallSign, Email, FirstName, MiddleName, LastName, Gender, BirthMonth, BirthDay, BirthYear, Location, … |
 | Hello everyone! :) Could you please help me? I am still a noob and I'm having a hard time about displaying selected values from mysql database into popup window? This is my code where user can see the table of the electoral officials: -----CUT----- <div id="page"> <div id="blanket" style="display:none;"></div> <div … |
| | So im trying to make a password login and im getting errors. i got past my Unable to jump to row 0 error with this: **mysql_num_rows($result) >= 1** but now it wont jump to the row when the password is correct ether :/ here is the code; whats wrong with … |
 | Hello,I cant access my two table date together in one search option.like table name: name_search & skill_search.here is the code.please check it and if possible solve it. <?php $connect=mysql_connect('localhost','root',''); $mysql_db=mysql_select_db('my_database',$connect) or die(mysql_error()); if (isset($_POST['search_name']) && isset($_POST['search_skill'])) { $search_name= $_POST['search_name']; $search_skill= $_POST['search_skill']; if(!empty($search_name) && !empty($search_skill)){ if(strlen($search_name,$search_skill)>=4){ $query = "SELECT name FROM … |
| | Hi guys i first thank you for helps. and i have a script i use that for application authentication In fact the users must use your user name and password to use that App then after authentication of they user and pass passed they allow to use that application. and …  |
| | Hey evryone. For some reason, I can't seem to insert anything into this table that I have in a database It connects just fine and the variables that I'm retrieving are just fine, which leads me to believe that my INSERT statement is incorrect. Any ideas? Here's the code: function … |
| | I am getting data from my order table in a html form, with its id under checkbox, now i want to select some id by checkbox & want to get the total quantity from the mysql table in a new html form/page. I hope, i am able to make u …  |
| | Im not seeing it but its not working here is the code: mysql_select_db("my_db", $con); $sql = "CREATE TABLE stream ( waveID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), userID int, wave varchar(25), waveTime TIMESTAMP DEFAULT NOW() )"; // Execute query if(!mysql_query($sql)) { echo "Couldn't do it"; } else { echo "alright"; … |
| | I am using mysql to fetch this result from the database.I need to caluclate the rank of a prticular user id from this result.What is the easy and smart way of doing it? SELECT a.UserId,d.AreaId,d.SubjectId, SUM( a.Marks ) AS sum, COUNT( a.Marks ) AS count, SUM( a.Marks ) / COUNT( … |
| | i have a lot of mysql data (2 Lakhs data) how to collect data with in a seconds ? any idea thanks in advance |
| | Hi every one I have a very simple form and it just will not submit to the db. Could some one please tell me where I am going wrong? <?php if ( $_SESSION['logged_in'] ): ?> (1) <?php endif; ?> <?php if($_POST['formSubmit'] == "Submit") { $errorMessage = ""; if(empty($_POST['social_media'])) { $errorMessage … |
| | Hi, please first you visit this site http://www.webdo.x10.mx/ this is my practice site.I just starting my php carrer.here i create a search option with button but its not working as my expectation.i think its code is OK".here the code.. <?php $connect=mysql_connect('localhost','root',''); $mysql_db=mysql_select_db('my_database',$connect) or die(mysql_error()); //db name:my_database if (isset($_POST['search_name'])) { $search_name= … |
| | Hi, This is my first post.I just starting php Hope everyone reply me as possible as. I have signup problem.When i filled the form and click sign up button then it nothing show any result i mean its not home.php "welcome" message and also not store date in my mysql … |
| | We are running a C program where for every one second there is a function callback. Below is the snippet of the code listed. It is ran over every second without missing so we notice sometimes when is busy doing the insert part and the next select is up and … |
| | Here are my two pages I am using to edit. One is the HTML form and the next is the code to insert the changes. I have looked overthis code for a few hours and have not seen anything wrong. I hope it is not something super simple or I … |
 | Hi all, I realise that this has been asked probably many times. I have searched but have not been able to find the relative answer - most likely not searching properly?? Anyway, what I would like to do is to display multiple images relating to one topic, ie. One member … |
| | I need to store both text and images to be stored in the same field? How can this be implemented in php using a mysql database? I have used BLOB to store images in the past . Which datatype should I use for this problem? And how will this work...? … |
| | Hello Everyone, I am trying to pull some info from a MySQL database. The problem is that, for every four rows that are fetched, I need to add a div tage before and after, so here is an example of what I want: This is the static way I have … |
| | Hi, I'm new to php and i'm trying to build simple database and I having a problem with getting id value with $_GET here is snippet of my code: $id = (int)$_GET['id']; echo $id; if(isset($_POST['upd'])){ $sql = "UPDATE dvds SET title = ?, folder = ?, spot = ? WHERE …  |
| | Hi i'm doing an android app which requires that i retrieve data from a MySql database stored in a webserver I am using a rest approach to do this the data is being retrieved through a json object. I would like to ensure once the data is retrieved its handled … |
| | Hello all, I have a drop down that is populated using php and mysql. when the user makes a selection, I run the function showUser(), however, nothing happens when i make a selection, can anyone help with what I'm doing wrong? The JS [CODE] <script type="text/javascript"> function showUser(str) { if … |
 | I want to have a list of months and years when content was posted to my website. Example: /// **Archive** *July 2012 June 2012 May 2012 April 2012* /// Then, clicking one of list items takes you to a page with every post from that month. I know I should … |
 | hi all, i just want to ask if its possible to have a two or even more database connection in a php run application like db_connect---db1 fetch data db_connect--db2 fetch data db_close --db2 if its not possible. how can i get data from other database table appriciate youre answers. |
| | My question requires a little background first: I'm working on a Web project where there are four theatres owned by a single company, so not only will the four theatres each need their own Website (each with its own unique branding), but the umbrella company will need one as well. … |
| | hi need to show the duplicates on a column table when they have two other values in common on other column. form_name + field_value name1 | value_x name2 | value_y how can i create the query to search when values x, y, etc have form_name name1 and name2 ? thanks |
| | Hi, I’m making an online database (with some help). What I’m having trouble figuring out is how it might be possible to sell ‘records’…or rather the ability to add records. I would sell access to the database based on the number of records a user buys. Once you buy a … |
 | Hi! I'm hoping someone can help me here, I've been looking at highcharts as a way of graphing my dynamic data from my sql db....What I've come up with so far is below, it's strange, it seems correct, the data is correct, however, I can't get my chart to render, … |
| | Dear all, i am new to php and i am trying to update db table through php form ... there is a form that takes inputs from php form and then update the db ... Below is the update php page ... <?php $host="localhost"; // Host name $username="lpr"; // Mysql …  |
| | I'm trying to create a PHP script, which would be added to .php files (articles) on my website. This script would automatically add the article in question to a previously created database (and would subseqgently be used to timestamp articles). What would a script like that look like? |
| | Hi, I have been trying to import the data from a CSV file (10,000 rows) into a database using SQL and PHP <body> <div id="container"> <div id="form"> <?php $user="root"; $database="test"; mysql_connect("localhost",$user); @mysql_select_db($database) or die( "Unable to select database"); //Upload File if (isset($_POST['submit'])) { if (is_uploaded_file($_FILES['filename']['tmp_name'])) { echo "<h1>" . "File … |
 | So I've been working on a page to locate shops based on zip code and mile distance. I used this tutorial as a walk-through http://htmlcampus.com/build-a-zip-code-store-locator-application-in-php/ Now I've changed a couple of things like the mySQL table is called locations instead of zip_codes. I've tested it and it connects to the …  |
 | I am urgently seeking assistance with the following error: *Commands out of sync; you can't run this command now* here's the code: $sql="select pr1.".$_SESSION['lang'].", pr1.id, pr2.".$_SESSION['lang'].", pr2.id from `project` as pr2 join project as `pr1` on(pr1.id=pr2.parent_project) where pr2.id=?"; $stmt = $mysqli->stmt_init(); $stmt->prepare($sql) or die ("Error preparing statement: ".$mysqli->error); $stmt->bind_param('i',$_GET['id']); $stmt->execute() … |
 | I have city and its corresponding locality. When user clicks city then its locality will show in Dropdown-Checkbox. How I can do with jQuery, AJAX and MySQL. |
| | hello i want to know that how pass parameters to mysql query inside php function i have written function but giveing me error error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource function d_loader($r_ip){ global $con; $result = mysql_query("SELECT * FROM table WHERE h_ip ='$r_ip'"); $row=mysql_fetch_array($result);} |
| | I have problem that when i make autocomplete with jquery and webservice it works fine.but problem is that when i delete my table related to include autocomplete then it still working.but it give error it keep break point but accordind to break point it goes same thing means it show … |
| | **Hi**, #need to generate a report like Table Format(Excel Sheet) # this is an example view of the report which I need of it is for maintaining branch wise details In that product name contin in one table and stock of each branch will contain in another table -------------------------------------------------------------------- | … |
| | hello i have phpmyadmin installed now new version is realeased so i want to upgrade myphpmyadmin to latest i tried from ssh yum upgrade phpmyadmin but yum have no packages for it so pelase help with it i jsut want to upgrade it so that server other modules are not … |
 | Hi, I am trying to use mysql select query in a shell script but i need to know how to store a particular value from the output of the query in a script variable. my script file is given below. I need to store the value under field CheckSum in … |
| | I have two dropdwon box. First box has names of the states. Choosing a state will populate the second dropdown box that contains cities of that selected state. For all states city names are stored in mysql database table. now I am little confussed how to model the table and … |
| | Hey experts. I have two database, i want to fetch values from one of the table from one database and then insert that into another table on another databse, server is same. can i do it? if yes please give some suggestions how to make it hapoen. many thanks in …  |
| | i have created database for our site. but i wanted to know that how can i secure my website using session. |
| | Hi With the code snippet given in the following post http://www.daniweb.com/web-development/php/threads/126361/csv-file-uploading-into-a-mysql-database I am able to import csv data into phpmyadmin. However, I am getting an error if csv data contains a text with apostrophe (‘) symbol (e.g. my book’s name is abc). Appriciate any suggestions to resolve this error. Thank … |
 | Hi. I wanted to make a page that I can update a table in a database. But for some reason, I get this error: ***Warning: mysql_query() [function.mysql-query]: Access denied for user 'a1092592'@'localhost' (using password: NO) in /home/a1092592/public_html/folder/file.php on line 10*** and this error: ***Warning: mysql_query() [function.mysql-query]: A link to the … |
| | Hi guys, Just looking for some advice on database design. I'm relatively competent in MySQL (competent at a push, haha) and I'm in a bit of a pickle right now when I'm trying to generate products for a Magento store. Well, Magento is where it ends up, I currently use … |
| | Hi, I want to change this code as given 1 result. I don't need 10 line results. I just need 1 line result. When I tried to change 10 with 1 it doesn't work. Please help me about that. while( $row = mysql_fetch_array($query) ) { $id[] = $row['id']; } $id …  |
| | Hi, I'm creating a website/database that my dad and his partner will use to help manage there business. update new appointments / manage customers ect. My dad wanted to host it on our server, however I'm not confident about setting up security so I was just going to use a … |
| | how to add email adress validation code so the validation will dispaly after immideately entered email adress in text box of email adress  |
 | Hey everyone, I'm having a little trouble with creating a 'dynamic' calendar with events called from a MySQL database. So basically I would like to have the Month automatically change when the month changes, and highlight the days which have events scheduled, and make those days links to my thickbox … |
| | I just installed Windows 8 Release Preview and my existing wampserver does not work. I tried installing easyphp and after the service was successfully started it can't find the localhost. Is there any fix to this or other local servers to run php and phpmyAdmin the easy way ? Thanks … |
| | I have two ajax mysql php 2 drop down select that I am populating... i'm doing something stupid... anyone have any suggestions... or pointers....? 1.php <?php require_once('dbconfig.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() … |
The End.