10,946 Topics
 | |
 | hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" … |
| | hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" …  |
 | <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object … |
| | i have created a database with username,age,contact,email.now i want a column in which we can show whether the user is active or not.what sholud we do?if we create a column named as status,what sholud be type of column?boolean or binary or something else...??? i am using php to edit delete …  |
| | `$data= "echo * from table1 where id=$_post[ID] "` can anyone see why this line duz not compute please ? |
 | I am not able to insert data from CSV file with "¤" Character. Please help me to solve the problem. Thanks a lot in advanced. CSV File: FirstName¤LastName¤City¤Year |$| Bill¤Gates¤NW¤2013¤|$| David¤Beckham¤London¤2010¤|$| PHP Code: $csv_file = "Contacts.csv"; $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 1; do { $insert_csv = … |
| | I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i … |
| | I installed a new script onto a Linux server using cpanel. > ERROR: Nothing parsed, nothing printed > Invalid query > SELECT * FROM `dating_country` WHERE `id` IN () > MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | Dear Respected Members/Users, I Cannot add/insert mysql last insert id in the third table. Kindly please help me out in adding the para_id into the last insert query. I have demonstrated in the Image file which will help alot in getting my point. Waiting for response. thanks.  |
| | why does this thing keeps on showing? what should i do?  |
| | hello guys i have created the below codes. the first one is the mysql select statement which works fine when i echo. the second one is an html/css table i created. i am stuck to the point where i can merge both of them so that i get a nice …  |
| | Hi All, I want to select rows from dynamic created tables i.e we have tables like web_analytics_mm_yy(ex: web_analytics_06_13, web_analytics_05_13, web_analytics_04_13 and so on) web_analytics -> table name mm_yy -> month_year. I know this can be acheived in PHP by using for loop { // CONSTRUCTING SQL STATEMENT USING // UNION … |
| | firstly I apologise in advance if this has been asked 100 times over.. I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a … |
| | I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) … |
| | Hello, I was wondering how i would create the Units table for this. Would i just set both Unit_ID and Customer_ID in the Units table as foreign keys or do i need to have a primary key like Customer_Unit_ID then have the two foreign keys? Customers Customer_ID Customer_Full_Name Contact_Name Address_1 … |
| | There has got to be a better way of doing this. First of all pay no attention to the lack of validation and error checking. I just want the core of the script to work first. Also, Block 1 and Block 2 execute, Block 3 does not. Whats the best … |
| | hi, i want to store date time whan i click radio button(name login time)in mysql. if i click logout radio button it should store logout time. ples help me... php and mysql code ... |
 | Hey guys, here is the table structure: Table name: globalsettings column names: setting, value, description An example query could be this: $query = "SELECT * FROM globalsettings WHERE setting = 'name'"; Okay, so here is what I am trying to do (I am using PDO for DB activity, but just … |
 | Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry … |
| | Hi All, I am a beginner in php and working on admin side of a small website. I have attached a PHP CKEDITOR to the admin page so that the admin may edit the pages text. Here, i am a bit confused about one thing and that is about how … |
| | hi everyone im having issues with some results i need, basically i have a view page that needs to output results based on earnings per month. all results are collected and outputted in rows, is there anyway in php i can group all the results by the earning month instead … |
| | [B]insert.php[/B] [CODE]<?php $dbun = "$_POST[dbun]"; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); $sql="INSERT INTO $dbun (sn, date, particular, dr, cr) VALUES ('$_POST[sn]','$_POST[date]','$_POST[ptr]','$_POST[dr]','$_POST[cr]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> [/CODE] [B]DB name = my_db[/B] [B]user.php[/B] …  |
| | I need to store the values of a textarea tag using a form to submit the value and finally store to a mysql database table. Here is what I have, I am sure its something dumb, but its been a while since I have used php. [CODE] <?php if(isset($_POST['submit'])){ $con … |
 | hi, i am new to mysql and also to php, i am trying to add a feature to a webpage, for showing some latest records from a mysql databse. i managed to show records from mysql database, but the problem is i only trying to show the first four records … |
| | Hi, I am trying to learn how to use a data base to store photos and such, I can now get info into the base and can get all the records to display , this is not what I had planed, So that lead me on a surch for answers … |
| | Hi, In Virtual Box I've installed Fedora 17 and setup LAMP development environment. I've set the static ip to access the localhost and the applicaions/projects. Now I would like to configure it as to access them using the static IP from the host machine (Windows 7 OS). How can I …  |
| | Hi there, This question relates to data structures, performance and approach to a problem. It is best explained with example so bear with me. For the record, I will be using a combination of PHP, MySQL and Apache server on a dedicated Linux server. The problem is how we would … |
| | Hi folks. I'm developing a MySQL database driven, PHP web application that will be used by the general public and I'm starting to get a bit paranoid about database security. While creating the site I was using a single, full privileges database user to connect on each page that required … |
| | Hello, I need to know what's the best way to search tables with million records. I have a table called <people> and this table has the column: <status> Status might be more than one word like: "I am happy today and the weather is nice". Also, it might be in … |
| | Alright guys I need some assistance with this. Ok In a few days I will start my project but I need to how to do something, Read Below: I need to find out how to display a Users specific table within My MySQL database for example here is a picture … |
| | My code: <?php include("db.php"); if (isset($_POST['username']) && isset($_POST['password']) && isset($_POST['email'])) //Prevent SQL injections $username = mysql_real_escape_string($_POST['username']); $email = mysql_real_escape_string($_POST['email']); //Get MD5 hash of password $password = md5($_POST['password']); //Check to see if username exists $sql = mysql_query("SELECT username FROM usersystem WHERE username = '".$username."'"); if (mysql_num_rows($sql)>0) { die ("Username taken."); } … |
 | windows xp was crashed, so after formatting & installation of windows I installed (overwrite of all existing files) **XAMPP** which was on different drive, other than **C:\**. As it was not lost when windows was crashed, I just overwrite the all files, this had happened with me lot of time … |
| | Hello I have these database countries ->country_id ->country_name ->language counties ->county_id ->county_name ->language towns ->town_id ->town_name ->language locations ->location_id ->location_name ->language streets ->street_id ->street_name ->language and i have users that select country,county,town,location and optional street at a selected language and i want to show the show the informations of address … |
| | I have code to upload a image to a folder (storing location and image info in a mysql database) with a separate page to display the images in albums on a website. Can I change this existing code to allow me to upload multiple images at once? here is the … |
| | <?php $username = $_SESSION['username']; $result = 'sample'; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } $sql = "Select FirstName from Person Where LoginID = (Select LoginID from UserLogin Where Username = '$username')"; $result = mysql_query($sql,$con); echo $result; ?> I'm kinda new to this server-side scripting … |
 | could you please help me we're doing our independent study about visual c# 2008 could please teach ne how to connect mysql to C#? thanks for the help:)  |
 | This is a school project which I am a bit lost on. I have two tables with a relationship between course +-------------+----------------+ |id(primary) |coursename | +-------------+----------------+ enrolled +-------------+----------------+----------------+ |id(primary) |studentName |courseid(FK_from| | | |course.id) | +-------------+----------------+----------------+ I can insert a new course into the course table using the INSERT syntax … |
| | I've just run into a problem, when pulling location data using a link table. There can be two entries in the link table, like so: item_id | contentent | country | state ------------------------------------- 123 | 1 | 2 | 20 123 | 1 | 2 | 21 When I echo … |
| | I know that I can limit a query by 10 for instance, and have the top rows returned, but I have a situation where I want to return all rows, but I want to be able to mark the rows that fall in the top 10 a certain way. For … |
| | Hi all, I'm new to codeigniter, and i want to know how to approach or a small example as to how to get the following: 1) If I have a form, and it has fields say asking for number of some category for example: first in a drop down we … |
| | I have two forms the first one is as follows:  In the first one, I enter the customer details and the type of house he wants, and the number of rooms he has, and I have set a session once I hit the next button. This is spanning … |
| | I had saved files in folder "uploads".I want to display uploaded filename in the table. There are two files. london.jpeg & usa.pdf Table: no Name File 1 abc london 2 xyz usa When one click on london or usa, one should able to see the file. I need urngent help. … |
| | Hello everyone :) I have this lines of codes and i get : > Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp22\htdocs\folder\index.php on line 52 ( 19 in the code below ) <form method="POST" action="index.php"> CODE : <input type="text" placeholder="Type the code" name="searchfor" /> <input type="submit" … |
| | |
| | Hello, i want to know if somebody could help me to make this script safe. Like how to put mysql_real_escape_string. Or how to use preg_split, or htmletities.... <?php include 'extern/connect.php'; $categories = file_get_contents('extern/categories.php'); $footer = file_get_contents('extern/footer.php'); $logo = file_get_contents('extern/logo.php'); $report = file_get_contents('extern/report.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" … |
| | Hi im trying to random showing items from data base and when echoed the same ones appear? If anyone could help that would be great. This is the query SELECT * FROM TABLE1, TABLE2 WHERE FIND_IN_SET(TABLE2.FIELD1, TABLE1.FIELD1) and `FIELDNAME` >= RAND() LIMIT 10 |
| | Hi guys, I'm trying to set a database for a shopping cart. Here is some of the code: [code] CREATE TABLE `tbl_cart` ( `ct_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `pd_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', `ct_qty` MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '1', … |
| | Hello, I have been trying to insert multiple rows from a web form into a MySQL DB. I have a dynamic table on one page that sets up the arrays and posts the form to another page which does the MySQL bit. Here is the the page with the form. … |
| | Importing a db table structure into a database using PHP MyAdmin the following table will not import. i can find no errors on the table, perhaps i am missing something. > > -- -------------------------------------------------------- > > > > -- > > -- Table structure for table `conversations` > > -- … |
| | I have a query in php that has an offset in it. I want the offset value to be a variable but I am not sure how to do so. This is my query but it comes up as an error. $query = "SELECT * FROM comments WHERE `commenter_username` IN … |
The End.