10,940 Topics
| |
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 |
The End.