10,946 Topics
 | |
| | I usually use wp clone wordpress plugin which basiclaly zipped the database and folder of wordpress to upload to a new install of wordpress. I can't use it however on a bridal woocommerce website. It tries then eventually gives me a 404 page not found error. The is has about … |
| | hi everyone, i want to store an image in database not by inserting but by updating (by using UPDATE query) and hers my code... everything else is updated successfully but its not storing image..please help me to solve the problem.. im using medium blob data type to store image this … |
| | i have a works to create table report like in attached image.  i don't know how to arrange the days and grouping as Time, thank you for help... |
| | I am trying to write a querry to pull just one playername out of a database by random, can anyone see what I am missing please ? open base< $sql="select playername from tablejollys where (ID % 1000) = floor(rand() * 1000) order by rand() limit 1"; $result=mysql_query($sql); echo ['playername'] ; … |
| | Hiy guys alot of you have been brilliant over the past few days. I'm creating my own website and I want to let users register and log in, into the site I'm now getting this error message Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL … |
 | Im tryin to add an admin to my database. Its not working but im not gettin any error messages ive tried a hundred different ways but its always the same it appears to be working but never actually does. Im hoping a more skilled eye can spot my mistake. Thanks …  |
| | I am trying to call a function which is store in some other location. But my index page is not able to make call to this function it seems. This behaviour is only after I uploaded my site on server. On localhost this function module is getting call with same … |
 | As part of my web app, users need to be able to move multiple images from one album to another. I'm writing an UPDATE function, as the current album is stored with the image (helpfully, the albumid is the only value that needs changing). Here is the function: function imageUpdate($image_key_array, … |
 | Its image gallery website . I have 5 main categories and each main category has 3 sub category. how can i implement this in a form by selecting the the main category 1st and then sub-category from mysql database and also input today date ? and then update/create the record. … |
| | I'm trying to show data from mysql database in JSF, but getting error: javax.servlet.ServletException: /index.xhtml @16,70 value="#{userBean.getUserList()}": The class 'com.dev.UserBean' does not have the property 'getUserList'. javax.faces.webapp.FacesServlet.service(FacesServlet.java:325) I'm using http://www.devmanuals.com/tutorials/java/jsf/database/viewdata.html tutorial UserBean.java package com.dev; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.faces.bean.ManagedBean; import javax.faces.bean.SessionScoped; …  |
| | Hi All, I have managed to get a few bits and pieces of code together, that I would like to try and combine to get the desired result for my form. The top section of the code is code that I had originally created myself and had some assistance in … |
| | I have this file named - " CUST.dbf ", how can i use this file to be able to import on MySQL for me to access the records on the table? Thanks in advance. more power  |
| | Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with …  |
| | I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', '919', '5555', '4444', '3333', '2222', '1111', '123', '3', 'text' '2014-04-11 13:33:24', '939', '5555', '4444', '3333', '2222', '1111', '123', '4', 'text' … |
| | I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? Thank you |
| | Ok I researched EVERYWHERE on the Internet and I just can't get this to work. In my php.ini under my WAMP php folder, I have this (enabling the extensions): [CODE];extension=php_mssql.dll extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll ;extension=php_oci8_11g.dll ;extension=php_openssl.dll[/CODE] Error: [CODE]Fatal error: Class 'mysqli' not found in C:\wamp\www\Elvonica\class\Database.php on line 11[/CODE] I have both … |
 | I am using this code to pull out data from database. But the $bathc_no variable is not fetching more than 1 row. Suppose, I have 3 rows in my mysql, Where the $batch_no for the 1st row is "13", 2nd row is "12" and for the 3rd is "15". I … |
| | I have set up a data base called assignment with a table called 'Parts' in it. But when i run the follwoing code on my local host i get the following error "Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lab9.php on line 8". Can anyone help … |
| | We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts. … |
| | Hey all, I am trying to update submissions from my SQL database from an edit page via an edit link in line with the submission which captures the ID of the database entry. When I click the edit link a new page opens and it has a form to update …  |
 | Here's how I'm thinking about inserting values into two tables. Each `reservation` will have a set of `services` the amount of which can vary, so I need to setup the query dynamically, here's my first sketch, although not tested yet. function saveBooking($fullBook) { $mysqli = new mysqli(HOST, USER, PASSWORD, DB_PRICE); … |
 | I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied … |
| | <?php include ('pages/dbconnect.php'); $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC"); echo "<table class='gridtable'>"; echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>"; echo "</tr>"; echo "</tr>"; $odl_dept = null; $odl_com = null; $odl_org = null; while($dep=mysql_fetch_assoc($rekdep)){ //List of department if($dep['dept']!=$odl_dept){ echo "<td>".$dep['dept']."</td>"; } //display blank td if the same department … |
| | I heard about decision making system like crystal report and I want to know how to implement CR with PHP? I have some basic knowledge about PHP,Mysql and Wordpress.  |
| | Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if … |
| | Please help. How to connect vb6 to mysql. What are the codes? Thanks.! |
| | hello how I can call google chart and sent to morethan three column from database in one chart thank you |
| | Hi All, My MySQL experience is fair but when it comes to doing some of the more complex queries I get stupid fast. That said, in the past, I have written queries that INSERT data to the DB based on clicks. In this case I want to use the same … |
| | Want to remove everything after the .com address in a mysql table ... Suppose Sample Before: domain.com/friend Sample After: domain.com  |
| | can any one give me sample code.. |
| | hi Team, i am facing 1067 error while starting My SQl service in windows. share your suggestions for this request. OS: windows 7 pro 64bit AV: Symantec 12.14013 Thanks Shiva  |
| | I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you |
 | good evening people,i'm creating an application where i'd like to import and save a list of people in an excel sheet to my database in mysql, using php, And i'd like to modify it through a form using php! Can anyone have an idea or something which will help me … |
| | halo sorry i distrub a i like to ask about vb and MySQL project  |
| | hi ! i ve just started doing mysql. i am making a web application in which employees database is reqiured to be shown in the table. i ve made a database name "educrm" and table name is "info", which i ve done in mysql through xampp(phpMyAdmin). i am showing u … |
| | I have a list of id like this from mysql JM.1 JM.2 JM.2.1 JM.2.2 JM.2.1.0 JM.2.1.1 JM.3 ... ...etc I want to make a display as well JM.1 JM.2 ---JM.2.1 ---JM.2.2 ---------JM.2.1.0 ---------JM.2.1.1 JM.3 ... ...etc How to display using PHP and How To using CSS like that, Or is … |
| | Hi I am trying to convert the following mysql function to mysqli. Thanks in advance David <?php /*------------------------------------------------- This class contains generic database functions to view, add, edit and delete all facets of a database -------------------------------------------------*/ require_once ("sitesettings.php"); class Database extends SiteSettings { var $Query; var $Connection; function Database() { … |
| | Hi I have another issue in Update. Could not be updated. pls help me if (isset($_POST['update']) && $_POST['update'] != "" ) { $id=$_POST["id"]; $name = $_POST["name"]; $address = $_POST["address"]; $tel = $_POST["tel"]; $fax = $_POST["fax"]; $email = $_POST["email"]; $website = $_POST["website"]; $type = $_POST["type"]; try { $sql="UPDATE bk_customer SET name='$name',address='$address', … |
 | Hey guys, I'm trying to start a yes/no vote div which, when clicked, increments MySQL entry either way. I've seen several examples of how to do this type of thing online, but can't seem to grasp this process on my current layout. I'll show a little as possible to not … |
 | I have a code that i want to throw an error if there is no items to delete or if there is items it proceeds with deleting the items, here is what i have so far: if (isset($_REQUEST['removeall'])){ if($_REQUEST['removeall'] == 1){ mysqli_query($mysqli,"DELETE FROM assets WHERE cust_id = $custID AND del_flag … |
| | In my new project I decided that I will use RedBean ORM system with Codeigniter PHP Framework. How can I get all records from table with simple relation? I know, that I can use R::exec or R::getAll queries but I want to make sure if there any other solution(s). TABLE … |
 | Hi all. sory but im beginner on web creating. I need create catalog. first page i need create item add form. after page i need create items catalog. all on mysql sory for bat English :) who can help me. i have login register index pages. |
 | Hi, Set up DB, sql file. Looks ok. Get Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a2108135'@'localhost' (using password: NO) in /home/a2108135/public_html/connect.php on line 27 Line 26-27 $dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword) or die("Could not connect to database"); @mysql_select_db("$MySqlDatabase") or die( "Could not select database"); Any help, thanks!!! L-D |
| | I have a form which shows results if a proper roll number is entered... the results are fetched from http://results.vtu.ac.in and only the table is shown... now i want to add the data of the table to my database using php. Is there a way to do it..? for example … |
 | I am trying to code a mysql query that will enable me select and insert multiple vaules from one table to another table in the same mysql database. I want to automatically populate the values from my id,levy from my tb_residents into table 2 resident_payments uid , rate . I … |
| | I can't seem to get a response from my query method. I have a database connection from method ping_server and use mysqli as connector. Can anyone help me figure out why I cannot print results from mysqli_fetch_array. dbclass.php class db { private $connection; private $selectdb; private $lastQuery; private $config; function … |
| | i have a checkbox to show the below contents. how can i store the value of checkbox whether checkbox is checked or not and i have to get the value when checked any one suggest me am beginner to php |
 | can anyone help to check my coding? what i need is to enter the groupcode and when i click search,it will retrieve all the modules. but only one module that appear instead of all. <?php $server="localhost"; $username="root"; $password=""; $connect_mysql=mysql_connect($server,$username,$password) or die ("Connection Failed!"); $mysql_db=mysql_select_db("reportdatabase",$connect_mysql) or die ("Could not Connect to …  |
| | Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. … |
 | Hi, I am trying to insert data into 3 tables using mysql.. At first, I was able to insert in the first table (staffinfo), after coding for the second table insert (empinfo), It inserted into second table without inserting in first table AND finally it echoes 1 record added Successfully … |
The End.