10,940 Topics

Member Avatar for
Member Avatar for haze man

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 …

Member Avatar for haze man
0
165
Member Avatar for riahc3

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. …

Member Avatar for riahc3
0
368
Member Avatar for Mike_16

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 …

Member Avatar for veedeoo
0
407
Member Avatar for Fernando_4

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); …

Member Avatar for Fernando_4
0
2K
Member Avatar for castajiz_2

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 …

Member Avatar for castajiz_2
0
2K
Member Avatar for Belton

<?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 …

Member Avatar for mglobs
0
256
Member Avatar for krupal5

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.

Member Avatar for chrishea
0
88
Member Avatar for showman13

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 …

Member Avatar for showman13
0
257
Member Avatar for vampshay
Member Avatar for Alireza_5
0
5K
Member Avatar for sama.alebrahimy

hello how I can call google chart and sent to morethan three column from database in one chart thank you

0
251
Member Avatar for phaedrusGhost

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 …

Member Avatar for phaedrusGhost
0
272
Member Avatar for mwnt2014

Want to remove everything after the .com address in a mysql table ... Suppose Sample Before: domain.com/friend Sample After: domain.com

Member Avatar for pixelsoul
0
111
Member Avatar for chaitu11
Member Avatar for shivap1711

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

Member Avatar for Jefferson_1
0
75
Member Avatar for riahc3

I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you

Member Avatar for riahc3
0
93
Member Avatar for djasy

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 …

Member Avatar for naidu65
0
5K
Member Avatar for aboy belo
Member Avatar for Reverend Jim
0
45
Member Avatar for Sudhanshu_2

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 …

Member Avatar for Sudhanshu_2
0
342
Member Avatar for Rahman_1

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 …

Member Avatar for diafol
0
249
Member Avatar for davidjennings

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() { …

Member Avatar for diafol
0
493
Member Avatar for Maideen

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', …

Member Avatar for Maideen
0
156
Member Avatar for PsychicTide

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 …

Member Avatar for PsychicTide
0
373
Member Avatar for patk570

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 …

Member Avatar for Fernando_4
0
193
Member Avatar for winbala5

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 …

Member Avatar for winbala5
0
254
Member Avatar for sigitas.darguzas

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.

Member Avatar for Fernando_4
0
185
Member Avatar for L-D

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

Member Avatar for L-D
0
258
Member Avatar for punith_1

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 …

Member Avatar for punith_1
0
434
Member Avatar for tundewoods

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 …

Member Avatar for pritaeas
0
375
Member Avatar for raminshahab

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 …

Member Avatar for raminshahab
0
348
Member Avatar for mohan@nano

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

Member Avatar for mohan@nano
0
92

The End.