10,946 Topics
 | |
| | Hello, i want to allow my users to reset their passwords if they forget it. My problem is that i lose the code sent to user via email, if this is the link sent to user via email http://localhost/citi/forgot.php?code=8b15388bc5ca7e2821ab6ce59b465f684942dd7901f4e31439575ab72028f84f , when the user get to forgot.php and type in the …  |
 | I have this code below for export mysql database to excel..however, if i run this it will only export the html code of the page not the sql query..please help..thank you. <html> <head><title>Exports</title> <link rel="stylesheet" href="css/css.css" /> <h2>EXPORT DATE/YEAR</h2></head> <form action="" method="post"> <table> <tr> <td><input size="40" name="searchString" type="text"class="ed" /> <select … |
 | whenever i use mysql_connect() It gives Fatal errror of using unidentfied function i'm using mysql version 4 on windows 7, what to do? it looks like php never heard of that function, wonder if someone does have a straight forward solution? |
| | help me..view direction and marker on database mysql? |
| | Hello. I have and event.php page and del_single.php page. event page has a form: <form action='del_single.php' method='get'>//<-i already have the method as get <input type='hidden' name='event_id' value='$id'> <input type='checkbox' name='check[]' class='check' value='$id'> <a href= '#' value='$id' name='e_n' onclick='getsum(".$id.")' >$name</a> <label>$formatDate</label> <input type='submit' name='del_single_event' value='Delete'> </form> as you can see i … |
| | There is a String object called detailMessage in java.lang.Throwable class, which says the reason of any exception thrown in java code. This object is initialized through a constructor using super(string message) statement or setter or whatever from subclasses like Exception and again from its subclasses like SQLException. When SQLException is …  |
| | Hi i have installed prestashop 1.4.8.2, i want report from mysql, Number of orders per customer with customer name & customer id plus i want total amount of order customer wise. can you help me with SQL query so i can generate this report from phpmyadmin. thanks, regards, Ritesh |
| | Hi there, wanna ask if the sql syntax order by and group by the same? eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group … |
| | Hello, I need for my game inventory function a mysql query which checks the next available free slot id. example: I have item on slot 1, 2, 3 and 5. Slot 4,6,7,8,9 ... are free.. Now I need query which would get the number 4. Something like SELECT * FROM …  |
| | Hi, I need to retrieve only 1 row for each 'message_id', with the Latest Date('sent_date'): ------------------------------------- message_id | sent_date | ------------------------------------- 805 | 2010-08-04 17:48:24 | <--- 805 | 2010-08-03 17:48:24 | 1007 | 2010-08-07 17:48:24 | 1007 | 2010-08-09 17:48:24 | <--- 1007 | 2010-08-08 17:48:24 | ------------------------------------- The … |
| | please help me out by giving a very easy code  |
| | hey i have this code that always evaluates to true but it should only in the case of there being a value in the database i have selected, maybe im doing this wrong or maybe its something else but i cant seem to figure out the problem :( any assistence … |
| | I need to add a check box on the end of each value in my html table that will be checked if the user would like to remove that value from the mysql database, my current cod elooks like this: <?php $con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con)); // … |
| | i got this code from the internet to export mysql query to excel using php..i just modify it to meet my need. i need some help on this..thanks.. <?php $DB_Server = "localhost"; $DB_Username = "root"; $DB_Password = ""; $DB_DBName = "dcde"; $DB_TBLName = "po"; $filename = "filename"; $sql = "Select … |
| | I have five tables as listed below. Question: is it possible to join all five tables and output the result as show below? <table> <tr> <th>Subject</th> <th>Last update (date from table. nr.3)</th> <th>Last update (date from table. nr.4)</th> <th>Last update (date from table. nr.5)</th> </tr> <tr> <td>Mathematics</td> <td>2014-06-01</td> <td>2014-07-05</td> <td>2014-03-15</td> … |
| | This code is to create a simple database to insert records into a table ... but the table appears to be empty with the following errors after entry>> errors: Notice: Undefined index: FirstName in C:\xampp\htdocs\my_php_files\insert.php on line 34 Notice: Undefined index: LastName in C:\xampp\htdocs\my_php_files\insert.php on line 35 Notice: Undefined index: … |
| | Hello and many thanks to all for your attention. I need to draw an HTML menù (<ul><li>...) over data retrieved from a table with a schema like this: id(int autoincrement), parent_id(int), childs_count(int), description(varchar). Where id fields is a identifier for a category and parent_id identify parent category for child. I …  |
 | Hi Friends, I am developing a Music download system. I thought to have two database tables. One for songs and other one is for artists because some songs have two or more artists. Then I created two tables call `songs` and `songartists`. Following are the structures of that tables. `songs` …  |
 | Hello everybody.I am amking a programm in vb net and mysql. My question is the following: i have one main form which it loads ,it loads all the database data in a datagridview.When i press the button"add customer" it opens anew form where i enter the person details.Then when i … |
| | Hi.. I'm trying to extract the day, month, and year from a datetime to use it within a 'WHERE' statement. Table: workshops workshopid - int(10) workshopgroupcoursecode - text title - varchar(255) description - text Table: workshops workshopscheduleid - int(10) workshopid - int(10) startdatetime - datetime enddatetime - datetime timedescription - … |
| | I need to create a table to track page visits to landing pages on a website based on the page name / the member ID / the Year / the Month and maintain the count of visits based on each unique combination Basically, I think I can create a table … |
| | I need to copy only some selected rows from a table and insert these rows into another table (having the same structure) in another database. Is it possible? |
 | Hello, I wonder what's the difference between *.frm, *.MYD, *.MYI ? I have tried to transfer filelogs.frm to another xampp server and it works on one machine while it doesn't on the other one. Do I have to have all of the extension in order for the xampp server to … |
| | how to insert data into mysql database using a textbox in php? |
| | Hi there, I am struggling with a bit of code and need a bit of help please.. I have information in a database that I want to display in a table, then allow users to choose a number of items and click 'add to cart'. It works fine if I … |
| | Ok, so this is cool. On my site, I learned how to create a simplified "wall" like facebook has... sort of. It's great for me to have done that because I am self taught with all of this. There is a problem, however. My <option> is not displaying the names … |
| | hi want to know how to save save list box values to database. thanks  |
 | i got complete details in html table and willing to update 2 values |
| | Hello, I wonder what is mysql table name requirements? I have tried creating mysql table with these names: group_mgt --> squprime.group_mgt table does not exist file_uploads_log --> squprime.file_uploads_log table does not exist In order to make the table creation works I have turn group_mgt to group AND turn file_uploads_log to … |
| | i have dove every thing, uncommented the extension for mysqli in php.ini but no way i can't connect to mysql or mysqli throught php 5.0.11 i appreciate any suggestions thnx;  |
 | I am using My SQL Database. I have two databases of My SQL which are used in a appplication simultaneaously as backend and log databases. So i need to stop services of log database only to view some results relating to my application. Is there any way to stop the … |
| | Hi, I would like to loop the data-attribute to contain all column names and values from a mysql table. This is what it looks like today: while ($row = $result->fetch()) { echo "<div id='{$row['namn']}' data-column1='{$row['column1']}' data-column2='{$row['column2']}'... So some kind of magic :) loop inside there so I don't have to … |
| | How can I send some data to a MySQL database? I'm using php. |
 | I am still trying to get a grasp on the php/mysql interaction. Why does something like this not work and without all the error catching, can one do something like this? [CODE] $result = mysql_query("SELECT * FROM stadium WHERE gametime = `$_z`;"); $row = mysql_fetch_row($result); $bababa[name] = $row[0]; $bababa[town] = … |
| | <?php include"header.php"; if(empty($_SESSION['UserName'])){ header("Location: http://localhost:1234/city"); exit;} $result = mysql_query("SELECT * FROM menu"); echo "<td><a href='http://localhost:1234/city/menu_update_insert.php'> <img src='images/create.png'>Add New Record</a> </td>"; echo "<table border='0'> <tr class='tableheader'> <th>PageName</th> <th>MenuName</th> <th>ParentMenuId</th> <th>LinkWidth</th> <th>OtherUrl</th> <th>Status</th> <th>CreatedDate</th> <th>OnMainMenu</th> <th>FooterMenu</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr class='tablerow'>"; $rpId=$row['PageID']; $result1=mysql_query("SELECT * FROM page WHERE ID=$rpId "); … |
 | I'm using: Windows 7 Home Premium 64-bit operating system Netbeans IDE 8.0 WAMP Server 2.5 Here is my issiue. I am attempting to follow the E-commerce tutorial in the Netbeans Java EE & Java Web learning trail (Section 3 "The NetBeans E-commerce Tutorial - Setting up the Development Environment"). In … |
| | I use the following code to generate a uuid concat with CMRC it works fine uuid is generated in lower case i.e. CMRC+someString in lower case I could not find anything to resolve this i had to post this on here for help how can I convert this generated uuid … |
 | Hi there, I have a little bit of a problem, i keep getting the following message when i try retrieve info from my database: "mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given" Here is my PHP code i don't see the error could someone please help? <?php require("connect.php"); //Check … |
| | I'm creating an Web-Based Inventory System, currently stucked at this module where I need to scan QR code. The process flow that I want to achieve should be like this: 1. Scan QR code containing the inventory ID wirelessly using an Android app 2. Show the information retrieved from the … |
 | hp $mysql_hostname = "localhost"; $mysql_user = "root"; $mysql_password = ""; $mysql_database = "farm_house"; $prefix = ""; $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database"); mysql_select_db($mysql_database, $bd) or die("Could not select database"); $myysql= "SELECT customerinformation.CustomerFullName, customerinformation.CustomerID, customerinformation.Housenumber, customerinformation.Sector, customerinformation.StreetNumber, customerconsumption.MilkDelieveredCow, milkrate.CowMilkRate, (customerconsumption.MilkDelieveredCow*milkrate.CowMilkRate) AS t_amount_cow, customerconsumption.MilkDeliveredBuffalow, milkrate.BuffaloMilkRate, (customerconsumption.MilkDeliveredBuffalow*milkrate.BuffaloMilkRate) AS t_amount_buff, …  |
| | Table: numdata id numb 1 123 2 456789 3 123 4 456789 5 123 6 456789 7 123 8 456789 9 123 10 456789 11 123 12 456789 13 123 14 456789 ...... What i would like to do is combine the data in numb only, so the desired data … |
 | I am retriving image from mysql database and want to hyperlink this processed image but not able to find solution for ($i = 0; $i < $rows; $i++) { $description = mysql_fetch_array($result); $img_str= base64_encode($description["nImage"]); echo '<a id="zoom" href="data:image/jpeg;base64,'.$img_str.'"><img src="data:image/jpeg;base64,'.$img_str.'" width="150" height="150" /></a>'; if($i%3 == 2) echo "</br>"; } |
| | Hi friends, In my site, simply I want to save the configuration data, site details in the php file. For an example, in vBulletin they are using config.php file to save all the general details. // ****** DATABASE TYPE ****** // This is the type of the database server on … |
| | hi all! it might look similar to previous question but actually different.. i'm trying to calculate stock value. for this i want to use "average last purchase value" of item. like if closing stock is 14 and purchase detail is like this 2014/2/2 15pc @ 38000 2014/2/15 5pc @ 36000 … |
| | This code was to create a simple database with a table and add records with the following. toIm having trouble with the 'id' auto_increment. <?php $con=mysqli_connect("localhost","root","distortion","my_databs"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Create table $sql="CREATE TABLE empl(ID INT NOT …  |
| | I have two tables with column name price I want to order by price from both columns so if is in first table 100eur and in second is 200eur I want to order results like this: 200, 100 SELECT a.price, b.price FROM table1 AS a INNER JOIN table2 AS b … |
| | Hi All, As usual I here with a PHP & MySQL problem. Most of you know, I am developing Music Download system. Today I have created Widget to display last 5 songs. <?php include('datab.php'); $get = "SELECT * FROM `songs` ORDER BY `id` DESC"; $getres = mysql_query($get) or die(mysql_error()); if(mysql_num_rows($getres)> …  |
| | <?php $host = "localhost"; $usr = "root"; $pwd = ""; $db= "DB"; conOpen($host,$usr,$pwd,$db); function conOpen($host,$usr,$pwd,$db){ $con=mysql_connect($host,$usr,$pwd) or die ("Connection Failed "); mysql_select_db($db,$con);} $rows_per_page=5; // database connection stuff here $result=mysql_query("Select * from newsimage"); $pages=ceil(mysql_num_rows($result)/$rows_per_page); if (!isset($screen)) $screen = 0; else echo $_GET[screen]; /* $start = $screen * $rows_per_page; $sql = "SELECT … |
 | Hey guys I'm new on web development, I'm just started with php and mysql , I've been using php for a couple of months,, thanks !:) |
| | Hi guys. i have an event page that displays events from database. in my database I have a column with datetime format. is there a way to only get the date or time separate from each other in a select to be displayed? php: <?php require "connection.php"; $sessid = $_SESSION['sess_user_id']; … |
The End.