11,093 Topics
 | |
| | I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer. … |
| | am using dev c++ updated version for my project am using myql c api problem is when i run my application it stop and says that mysql.dll is missing , currently when i place mysql.dll in the app folder it cant give me the error , so i want to …  |
 | trying to search by the file name keep getting a "expects parameter 1 to be resource, boolean" error what am i missing? $pagename = basename($_SERVER['PHP_SELF'], ".php"); mysql_select_db("tagpoint", $con); $sql="SELECT * FROM tagpoint WHERE title = '".$pagename."'"; $result=@mysql_query($sql); $row = mysql_fetch_array($result); |
| | is it possible to use a string array in mysql using the set data type and add a valuse to it, like a list of names? |
| | Hello, how do i add an hour to time with DATE_ADD in DATE_FORMAT? Here is my code : <?php session_start(); include('includes/main_funcs.php'); $db = db(); $reponse = $db->query('SELECT name, message, DATE_FORMAT(time, '%H:%i') AS forTime FROM chat ORDER BY ID DESC LIMIT 0, 10'); while ($donnees = $reponse->fetch()) { echo'['.$donnees['forTime'].'] <strong>'.htmlspecialchars($donnees['name']).'</strong> : … |
| | I have been having problems with this code and i cant find out why I am trying to add a new element to an array. it says it goes throu butwhen i check its empty: $sql="UPDATE $title SET arole = CONCAT_WS(',', arole, '$name') WHERE op = '$name'"; if (!mysql_query($sql,$con)) { …  |
 | Hi, I want to select all records from a table where the DateAdded field's date and time (Default value Timestamp field) is more than say 3 hrs ago. eg: something like SELECT tbldata.* FROM tbldata WHERE (tbldata.DateAdded <= now()-3); I can get it working with days difference but do not … |
| | I have a script that uploads documents, it uploads them in the destination folder, but not the info about the document. Pleasa help i need this as soon as possible. No errors show. <?php $UploadDirectory = 'C:/wamp/www/agenda1/uploaddok/uploads/'; //Upload Directory, ends with slash & make sure folder exist $SuccessRedirect = 'http://localhost:8080/agenda1/index2.php'; … |
| | Hello, I know I shouldn't use mysql_. So I have a mysql_query which updates my table (for a hit counter). However, when I open the page, I get to see this: > You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | So, i want to display data from a table in my db (Mysql), i click the buttonto get the data, it sends request via Ajax and Ajax calls getdata.php file. The table which is supposed to return the data returns in everyfield the written code like "$head" and "$value". I …  |
| | plz tel me how to write a jsp pgm to take values from mysql?plz help me  |
| | I am converting a traditional website to WordPress for an animal rescue charity so members can have a blog and more easily update various pages. All has gone well but I am stuck on one key aspect. Viewers of the original site can click on a page that will then … |
| | Hi, I been learning **OOP** slowly. I'm stuck how to resolved an **function query() on a non object issue**. My files are very basic: This is my **db.php** file: <?php global $db; class foo_mysqli extends mysqli { public function __construct($host, $user, $pass, $db) { parent::__construct($host, $user, $pass, $db); if (mysqli_connect_error()) … |
| | $query = "SELECT * FROM customers WHERE firstname = '$firstname', lastname = '$lastname'"; $result = mysql_query($query); i keep getting Error: Query was empty  |
 | i tried reverse engineering option in Mysql workbend 5.1, 1stly i imprted DB's script and then created it, Its done :) but when i try to create ERD via Reverse Engineering option , then it doesn't show relations ships btw tbl, it only brings table to front ! why ? … |
| | Hello, When I run the project using my localhost, everything works fie. But when I use an other server I get this error: No suitable driver found for jbdc:mysql:// public void populateList2() { Connection con = null; Properties conProps = new Properties(); conProps.setProperty("user", "abn859"); conProps.setProperty("password", "100011399"); try { con = … |
| | Good Morning. I am writing a little function to record the visits to a landing page, and want to do it in such a way as to not count multiple visits from the same IP address within a 24 hour period. What I was wondering is if there is a … |
 | Hi everyone, Heres my problem: I've installed Qt 4, and there is **no** qmysql.dll/.a in C:\Qt\4.8.4\plugins\sqldrivers\. I am running a MySQL database program and I get Database error: Driver not loaded. Theres not really a lot of help anywhere on google so hopefully DaniWeb will yet again prove itself as … |
 | Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF … |
| | Status field contains values Open,Awaiting,Approved,Rejected. To store a value what is the best datatype in mysql? Is it TINYINT OR VARCHAR? TINYINT occupies less memory if we store numbers instead of strings ( 1 => Open, 2 => Awaiting ...). Is it cause any performence issue when using joins? I … |
| | Hello all: I would like to query my mysql table for a total number of records inserted during a specified day of the week within a specified time period. More clearly: count number records inserted on Tuesdays during the time period of 2013-01-31 - 2013-02-03. The first day of the …  |
| | Here is my code:- //choose the table and return records $result = mysql_query("SELECT id, state,country_id FROM state ORDER BY country_id"); $string .= '"'.$val.'", '; $country = null; //get group while($row = mysql_fetch_assoc($result)) { if ($row['country_id'] != $country) { echo '<br>'.'<br>'."[".($row['country_id'])."] = parentarray ["; $country = $row['country_id']; } // get list … |
| | Please help. I am trying to change data in my MySql database. I am able to input new data, but when i try to change anything, it doesn't work. Here is my code: <?php $id = $_REQUEST['id']; $newname = $_REQUEST['newname']; $newemail = $_REQUEST['newemail']; $newpassword = $_REQUEST['newpassword']; mysql_connect("localhost", "root", "") or … |
| | I'm pretty new to AJAX so this may look like simple questions but..., so i want my file to be stored in a table in a db i have on my localhost, i'm using iframe <iframe id="upload_target" name="upload_target" src="#" style="width:0;height:0;border:0px solid #fff;"></iframe> what source do i provide, what about the … |
| | Hi I have some code that has 2 querys to fill 2 dropdown boxes. I need to get an id from one depending on which selection is chosen, put it in a variable to use in the second query. My code is below with comments of what I want to … |
| | Hello, I have this code over here: <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> <title>Admin area - Sydcul URL Shortener</title> <meta name="description" content="Free URL shortener"> <meta name="keywords" content="sydcul, url, shortener, tiny, url, tinyurl, bit, ly, bitly"> <meta name="author" content="Sydcul"> <link href="../stylesheet.css" rel="stylesheet" type="text/css"> <link rel="icon" type="image/ico" href="../favicon.ico"> </head> <body> <center> <h1>Admin … |
| | 1. I am trying to use this code snippet, to learn how to create a dropdown menu, populated by a mysql database. 2. I have worked out the kinks of the database credentials. 3. I have created and populated a test database. 4. This does actually work, now that it … |
| | HI basically this is my problem. I have created a database and I have created a table. I am trying to verify my username and password. HERE IS THE HTML PART. <body> <h1>Members login</h1> <form method="post" action="check_login.php"> <label for="username">Username:</label> <input type="text" name="username"/> <label for="Password">Password:</label> <input type="password" name="password"/> <label for ="submit">Submit:</label> … |
 | Sirs, please suggest a good way to handle large amount of data. This is my newbie idea: - create a database on one of high powered pc(dedicated for whole company) - then sync every changes to another copy of this database to the online hosting service with security note: theres … |
| | Hello, My script uses the user 'www-data' (my webserver) when connecting to the MySQL Database, while I tell it not to. <?php include ('config.inc.php'); $connection = mysql_connect($host, $user, $password); mysql_select_db($database, $connection); $shorturls = mysql_query('SELECT shorturl FROM `' . $prefix . 'urls`'); $shorturl = rand(100000, 999999); foreach(mysql_fetch_array($shorturls) as $row) { if($row['shorturl']==$shorturl) … |
| | Hi all. I hope I chose the forum to post in, it's an in between kind of question. I'm looking into options to develop my final year project. It's a formative assessment of a theoretical course to grasp students' understanding. The focus is on the ability of students to relate … |
| | Hello guys, I am still encountering a problem regarding my combobox. I am trying to populate it from my MySQL table but I am unable to so far.... Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader …  |
| | Hi guys. I'm just wondering why this function always returns true, no matter what the $user_id is. The $user_id variable is determined by what is retreived from the $_SESSION. I am well aware that mysql_* functions are being depreceated etc, no need to tell me :P Thanks guys! function user_mod() …  |
| | I have quiz ID(Q1 for example) and below is the number of items in that quiz. My problem is, I need to display a dash when query cannot find a record in my database, if there is a record it will show up and the missing records will be filled …  |
| | i currently using mysql for database i want to use mysqli can any one tell me any other php server is required for it or i can use it in my bitnami wampstack 5.3.17.0 apache server. |
| | Hi Everybody I tried and failed to display images of employees in jTable. I have a MySQL Table which have 4 fields - ID,Name.Phone,Photo(Blob data type). Now I am able to retrive data from this table and display it in JLabel with other data in JTextField, but How can I …  |
 | Hello Community, I was wondering if there is a way to backup my mysql database. |
| | Hello Community, I was wondering if there is a way to backup my mysql database. |
| | I know there are other post conserning this but they dont seem to help me. When I run the varaible `$results` through the function `Mysql_num_rows()` it returns as an error saying its not a valid result. Also same for the `mysql_fetch_array()`. function results(){ if ($_POST['search'] != "") { $search = … |
| | If I have relation schema R(A, B, C, D, E) with functional dependencies: AB->C, CD->E, C->A, E->D: a)find all the (minimal) keys for R b)state the normal form for R and describe functional dependencies that violate higher NF c)decompose R into 2 (or more) relations that are in highest possible …  |
| | I'm trying to get an xml file from an ftp and then insert select data into mysql db. I'm shooting in the dark but from googling this is what i've tried so far: $curl = curl_init(); $file = fopen("import.xml", 'w'); curl_setopt($curl, CURLOPT_URL, "ftp://company@company.company.se/company/import.xml"); #input curl_setopt($curl, CURLOPT_FILE, $file); #output curl_setopt($curl, CURLOPT_USERPWD, … |
| | Hi, I, getting a new xml file everyday to one of our external ftp servers. I want to get that file and then insert select data into my mysql. What I'm thinking is that I would use curl to get the file, then simplexml and then insert into database. But … |
| | <?php mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("agenda") or die(mysql_error()); $q = mysql_query("INSERT INTO kontakte (emri, mbiemri,e-mail,nr,adresa,shenime) VALUES( '{$_POST['emri']}' '{$_POST['mbiemri']}', '{$_POST['e-mail']}', '{$_POST['nr']}', '{$_POST['adresa']}', '{$_POST['shenime']}') "); if (!$q) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } ?> <html> <head></head> <body> <div … |
| | I have three tables: collections [clientID][isbn] books [title][isbn][author] clients [cliendID][firstName][lastName] I am making a seach functon on php. The function will search the clientID and display the name (from the clients table) and what book that client has (fro collections table). What should I do for the query? $query = … |
| | I am making a mysql query that gathers comments for a user, it works properly, I connect to the database and recieve the comments for a user, but it is not showing the first comment for the user. Here is the code function comments(){ //connect to db connect_db_members(); //start query … |
| | CREATE TABLE `camioneta` ( `codigo_vehiculo` varchar(20) NOT NULL, `cabina` varchar(50) DEFAULT NULL, `capacidad` int(11) DEFAULT NULL, `num_puertas` int(11) DEFAULT NULL, PRIMARY KEY (`codigo_vehiculo`), CONSTRAINT `fk__camioneta__codig__300424b4` FOREIGN KEY (`codigo_vehiculo`) REFERENCES `vehiculos` (`codigo_vehiculo`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; |
| | Hi everyone. I'm trying to verify whether the variables $username and $password_recovery (both are unique - impossible for them to be the same) both come from the same row in the rable 'users'. This is the query I am using: return (mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `username` = '$username' AND … |
 | i have two tables the following structures. CREATE TABLE `tblbranches` ( `branchID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `branchCode` varchar(30) NOT NULL, `branchName` varchar(30) NOT NULL, `regionID` tinyint(3) unsigned NOT NULL, `branchAddress` varchar(400) NOT NULL, `cityID` smallint(5) unsigned NOT NULL, `countryID` smallint(3) unsigned NOT NULL, `branchContact` varchar(50) NOT NULL, `branchFax` varchar(20) … |
| | I have the following php code that queries my Database called get_cost.php.The query is working as it displays all content of my TABLE si, kindly assist! <?php /* * Following code will list all the products */ // array for JSON response $response = array(); // include db connect class … |
| | I want to know what method to use to view Images from my MYSQL database using PHP. i know that for basic data it is getString(). what about for images? |
The End.