11,093 Topics
 | |
| | I need to do a search that specifies in witch line of the search that the information was found. For example: select * from table where height=100; this code returns 50 lines, but i want, for example, in that search, the person 'Matheus' was in the 28th line of the …  |
| | Hi i m learning PHP.How can i insert a data in mysql by using onchange event in radio button, i m not used a submit button in my code can u help me by giving a solution of my prolblem by giving a little example. Thank you so much  |
 | Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the … |
 | Ok, what I'm trying to do is have next and prev buttons to navigate through a mysql database sorted by date. Currently, the code I wrote does this, but gets stuck on duplicate dates. $Next = mysql_query("SELECT * FROM $logbook WHERE Date>='$Date' AND ID!='$ID' ORDER BY Date LIMIT 1"); $Prev … |
 | I am inserting answer of each of my questions I need to get the question id and inserted into the answer table see my code <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post" id="quiz" class="container width_648"> <?php $getTheQuiz = $db->prepare("SELECT * FROM rec_employer_quiz WHERE ad_id=?"); $getTheQuiz->bind_param('i', $ad); if ($getTheQuiz->execute()) { $res = $getTheQuiz->get_result(); … |
 | i have a datagridview and a combobox. the combobox is auto populated by values from a database. i need to filter the datagridview using combobox. this is the code that i've done. it shows a error : Cannot find column [year]. can you help me??? Imports MySql.Data.MySqlClient Public Class ReportGradeLevel … |
 | Dear friends, Please guide me I want to display data in PHP form from mysql database. my code is below <?PHP //connect to database $username = "root"; $password = ""; $database = "mydatabase"; $server = "127.0.0.1"; $conn= mysqli_connect($server,$username,$password,$database); // checkintin connection if($conn->connect_error){ die("".$conn->connect_error); } // select data $sql = "SELECT … |
| | Hi I am using opencart for my website...i am developing ecommerce website for online jewellery store...i want to know if its possible to change price of jewelery according to their actual daily market rates....automatically it should be....please help me |
 | I have simple php code here, where basically asking to display the value of query : <?php $table = "tbl_product"; /******************MULTIPLE QUERIES*******************/ if($tbl_code==999){$condition = " WHERE (category = 'wellington') OR (category = 'hivis') OR (category = 'tools') OR (category = 'waterproof') ";} else if($tbl_code==998){$condition = " WHERE category = 'wellington' … |
| | Hi All, Please let me know the steps to install PHP, MySQL and PHPMyAdmin on RHEL machines.  |
 | Hi all, I have two db, one db "latestdb" which have latest six months records second db "backupdb" which have oldest records of "latestdb" and this records deleted from "latestdb" I have a query which should return records from both db. Query will return new records from "latestdb" and old … |
 | So I currently am trying to insert a row into a MEMORY table but only if the primary key doesn't already exist. I'm using INSERT IGNORE but I was reading, much to my surprise, that INSERT IGNORE is actually slower than INSERT ... ON DUPLICATE KEY, but that letting the … |
 | Hi All, While going through my project work, I just came across a situation, where I needed to alter my table. I needed to add a column at the beginning of the table, i.e. the first column of the table. We have syntax for appending a column to a table … |
| | Hello. I need some help to update two table.. This is my coding: $query = "UPDATE br.discharged_Date, b.book_Status SET br.patron_ID = b.patron_ID FROM borrow br INNER JOIN book b ON br.patron_ID = b.patron_ID WHERE b.patron_ID = '$patron_ID'"; |
| | Hello, I have page with several sections, in each section form with submit button which will load table and execute mysql queries. I need help to make long tables in more pages, or at least make scroll so user don't have to take long time to go from part to … |
| | first create the table [CODE] create table images ( image_id serial, filename varchar(255) not null, mime_type varchar(255) not null, file_size int not null, file_data longblob not null, primary key (image_id), index (filename) ); [/CODE] the file to output the images to the browser [B]picsrc.php[/B] [CODE]<?PHP //detect if image is called … |
 | Hey! Long time no speak ^.^ I've been trying to make a query which would follow this logic (Which works in phpMyAdmin): UPDATE member_food SET food_id=12 WHERE member_id=4 AND food_type="breakfast" However, when I do it in PHP: $sql_breakfast1 = "UPDATE member_food SET food_id ='$breakfast1' WHERE member_id='$id' AND food_type='breakfast'"; if ($mysqli->query($sql_breakfast1) … |
| | Hi, I am trying to connect to mysql from php Below is the sample code i used. [COLOR="Green"]<?php <?php $username = "root"; $password = "pwd"; $hostname = "localhost"; $dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); print "Connected to MySQL<br>"; mysql_close($dbh); ?>[/COLOR] The problem here is I … |
 | Hi..I sure hope you can help me ! 2 years ago you helped with a Update Form and I've been trying to adapt the form to my mySQL Database.As I'm just learning and trying to figure some of this out I've seemed to have hit a road block. . . … |
| | Hi, im trying to transform a string to make it a date $date1 = '$month/$day/$year'; //in jS value form type="number" $date2 = strtotime($date1); $date3 = date('Y-m-d',$date2); The problem is that when I SET date = $date3 the database saves 0000-00-00. what am I doing wrong?? |
| | Here is a simple way to insert into a database that isn't much harder than using string concatenation - which we all know is very dangerous due to SQL injection attacks. Put the code snippet into `database.php`. Now, in a script handling a form post, such as `post_reply.php`: <?php require_once("database.php"); … |
 | <?php require_once'start.php'; require_once'twitteroauth.php'; function cs( $string ) { if ( function_exists( "get_magic_quotes_gpc" ) && get_magic_quotes_gpc( ) ) { $string = stripslashes( $string ); } else if ( !get_magic_quotes_gpc( ) ) { $string = addslashes( $string ); } $string = @mysql_real_escape_string( @$string ); return $string; } if (!empty($_GET['get']) && $_GET['get'] == …  |
| | Hello everyone. I have just bought a new computer and I am currently working on creating an online cloud storage service. Every thing is going fine until I am struck with a problem. At first, registering a new user works and the data is inserted into database but after testing … |
| | This is a SMS DLR application from http://www.smsgatewaycenter.com which is sent by them to my client's url and I need to configure for my client the same from my client's url to his reseller's url. This script uses every 1 hour to post data to my client's reseller/customer. So, it … |
| | Hi. so i have this div like so:  see the "Add Spouse" link, when clicked will display another div:  the edit spouse works by submitting the data wihtout refresh using `$.post`: $(document).ready(function(){ $("#submitSp").live("click", function() { var id = $("#contactid").val(); var ssalut = $("#spouse-salute").val(); var sfname = … |
| | Hello All, I am facing a problem coming up with a SQL query for a certain issue: Table 1 ------------------- Client ID|Name of Client|Customer Type|Account Type| 01| A | AB | 30 | 02| B | AB | 30 | 03| C | CD | 30 | 04| D | … |
| | Hello All, I want to start by saying thank you for your help and reviewing my post. I am relatively new to MySQL and databases in general so please be polite. I need help with some of my queries. I have done some but these are complex queries for me. …  |
| | I am working on a quiz app image 1 shows the index.php page image 2 shows the first question image 3 shows the second question image 4 shows the third question image 5 shows the result after completing the quiz image 6 shows the database 'quizzer' and its tables image … |
| | hi i have a little problem, that i want to print the count of id, so i write this: $conn=mysqli_connect("localhost", "root", "","test") or die(mysqli_error()); $compt=mysqli_query($conn,"SELECT count(id) FROM `users`", MYSQLI_USE_RESULT); print $compt; to connect to db and extract the count id, i have an error and i dont know how to … |
 | Im trying to convert mysql query to mysqli but it doesnt work...why? From: mysql_query("UPDATE views SET views=views+1 WHERE viewID='1'"); To: $q1=$mysqli->query("UPDATE views SET views=views+1 WHERE viewID='1'"); Errors: Notice: Undefined variable: mysqli in C:\wamp\www\SICS\home.php on line 5 Fatal error: Call to a member function query() on a non-object in C:\wamp\www\SICS\home.php on … |
| | 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 … |
 | Gentlemen, I have a problem in entering a "DATE" in to MySQL table via a Java SWING interface. I used 'jdatepicker' to select a date & I use XAMPP server for MySQL database. Earlier I converted the selected date in to String values & feed as VARCHAR in mysql table. … |
| | hello, how could i create a timestamp or time_of_posting column in my site such that there is no sync problem bw server time and visitor's time... also that column will be used for finding if diff bw time_of_posting and current time is >11months and less than 12 months |
| | I have a form that has two parameters amenities and attributes. The amenities parameter has a dropdown menu that whose value gets populated from a separate table. The second parameter is attribute whose value will be entered by the user and will get saved in a database. View of database … |
 | <?php require_once('Connections/localhost.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . … |
 | |
| | hello,i have a column in my database named 'skills' where all the skills of a person are saved. if i want to find a person with multiple skills like he should be professional in cpppl,javapl,actionscriptpl,matlabpl i will do query like this select email from table where skills regexp 'javapl' and … |
| | Here is the code. I am trying to hi-lite rows that are generated that have a value of "Y" for column AA_letter_recd in yellow, the rows . The ones that have a value of "N" are not to be high-lited in yellow. Thanks. <?php /*Main Store Index */ // Script … |
| | this is my modal button this is within the table that why i use echo $rows['id'] <a data-id="<?php echo $rows['id']; ?>" type="button" class="btn btn-success btn-lg btn-block" data-toggle="modal" data-target="#myModal">View Order</a> this is my modal body <?php include('../conn.php'); $id=$_GET['id']; $list_query=mysql_query("select * from db where id='$id'"); $rows=mysql_fetch_array($list_query); ?> <form class="form-horizontal orderitem" role="form"> <div …  |
| | |
 | Hello, What variable types should I use for phone number. I tried to put integer(20) earlier then, I cannot record : 021888888 since it saves as 21888888 If I choose varchar(20) then it allows alphabets also, which it should. Any other ideas? |
| | |
 | Hi guys, Trying to develop a custom facet like search in Mysql. I have 3 tables for this: 1.Attribute class 2.Attribute class Name 3.Attribute class Value - attributeClassName Id - productId 4.Products Each product has one attribute class Each attribute class has many values Each value is contained in a … |
| | After Designing database--->Connection to database--->Data entered-->Data stored in database.My doubt is in which format data is viewed on the screen.(XML OR EXCEL OR PDF) |
| | hello; i have taken shared hosting plan ..my sql query on phpmyadmin is SELECT 'EMAIL','first','last' UNION select email,first,last from e where skills regexp "javapl" and deposit>=bid INTO OUTFILE '/home/user/etc/csvfiles/1412231915.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' but it shows error #1045 - Access denied for user 'user'@'localhost' (using password: … |
 | Hi All , i have my admin panel where i build a form which store information of model popup like its color , title etc and also fields is require to show in model popup. i means all features of model popup is generated by admin and saved to database … |
| | Hi, I'm creating a game where users play daily & earn points. I wanted to record the scores of each user each day for a month. At first, I thought to create 31 columns within the table & store the score in the appropriate date field. But, I think it … |
| | hello, i have a database in which three columns are there.name,datetime and timestamp...datetime and timestamp consist of the time people has put their entries into database.now i want to find out set of people older than 11 month.. i mean bw 11months to 12 months so that i can give …  |
| | Here is a php file that i HAVE...so at the moment it displays the latest news on the site but I want to add 5 more...how should my query be? <?php $stmt = $db->query('SELECT postID, postTitle, postURL, postDesc, postDate FROM posts where postid=(SELECT max(postID) from posts)'); while($row = $stmt->fetch()){ $output … |
 | i would like to make a simple website but with shopping cart function, it should include payment method of Paypal, Visa, Mastercard, Alipay, etc most popular trasaction ways. the web show be as simple as possible, most like a wordpress, but the administrator funcation should be easy-going, and operate by …  |
The End.