Previously used winXP operating system running normally (very good) when switching to win7 operating system, this error, read errors from the SQL Server data, what is the error ? http://www.mediafire.com/view/4q5ux6e66ds4avb/ErrorOpenSQL.jpg/file

Member Avatar
Member Avatar
+0 forum 1

I have a form that uploads a news article with it's picture and then stores all the info correctly. I am using codeigniter with Active Record and would like to know how to display the image with the post it was uploaded with. here is my upload script: public function create(){ $data = array('error' => ''); $config = array( 'upload_path' => './uploads', 'allowed_types' => 'gif|jpg|png', 'max_size' => '204800', 'max_width' => '1920', 'max_height' => '1080', 'encrypt_name' => true ); $this->load->library('upload', $config); if(!$this->upload->do_upload()) { $error = array('error' => $this->upload->display_errors()); $data['title'] = 'Create a news item'; $data['main_content'] = 'news/create'; $this->load->view('templates/template', $data, $error); } …

Member Avatar
Member Avatar
+0 forum 4

Hello people, I've been working on a registration form project that needs to contain a captcha code that will be validated. Even if the captcha string inserted in the text box is correct, it displays the error "Captcha string is incorrect". Also, even if the captcha part did not exist, the form doesn't seem to save the data to my sql database. Can anyone please try to help me out or check if you can notice any obivous errors with my code? The following code is the PHP and HTML code used for the registration form <?php session_start(); $_SESSION['captcha'] = …

Member Avatar
Member Avatar
+0 forum 1

How to copy a store procedure one to another database in same server I work on a project. I want copy all or single store procedure from old financial year **db_17_18** to new financial year **db_18_19** I want to do it using sql server command. i try it but showing error Please help me.... i used : SQL_Server 2008 r2 server name : shop04 **What I have tried:** **try 1** select * into DB_18_19.dbo.P_Add_FY_Data.procedures from DB_17_18.P_Add_FY_Data.procedures WHERE type_desc='SQL_STORED_PROCEDURE' **Error1 :** Msg 117, Level 15, State 1, Line 1 The object name 'DB_18_19.dbo.P_Add_FY_Data.procedures' contains more than the maximum number of prefixes. …

Member Avatar
Member Avatar
+0 forum 2

I have a table that contains some cubes with servers and active status (see attached image): note: CUBE1 is repeated intentionally. The idea is the same cube is getting synced from the same server 1 as a data source (process_server) onto different target servers (query_server; say server2 is in region A and server 3 is in region B). The way the environment is set up is both servers have to be active/active status (meaning TRUE) except for some additional test cases, i am setting to false sometimes one or the other. I have the following script now calling the cube …

Member Avatar
Member Avatar
+0 forum 1

Hi Guys! I have a website but we don't host in GoDaddy or any hosting website, because we use SQL database. And we have a large database that we are using , the website is for productions. We store a lot of data. We use the IP address because we port forward it so that we can use it anywhere. Now, we are worried because we are exposing our IP address outside, and it might be the reason for hackers or any attacks to come to us. Can you help me or give me an Idea how can I change …

Member Avatar
Member Avatar
+0 forum 15

I'm a newbie in php and I want to create a single login page for Admin and user.When admin log in it should go to an admin page and when user log it shoult go to index page.I want help with my code, it works fine login normal users but i try it addind the admin part and it doesn't seem to work .Please help and Thanks in advance .. This is my validation code for the login <?php if(!empty($_POST)){ if(isset($_POST["username"]) &&isset($_POST["password"])){ if($_POST["username"]!=""&&$_POST["password"]!=""){ include "conexion.php"; $user_=null; $sql1= "select * from user where (username=\"$_POST[username]\" or email=\"$_POST[username]\") and password=\"$_POST[password]\" "; $query = …

Member Avatar
Member Avatar
+0 forum 6

Hi there, i'm trying to create a class schedule for subjects where students can view what's available and later on book a position in a class. Here are the images of what i'm trying to achieve: https://imgur.com/a/Ie4XO I want to retrieve the table name and ID of students that have booked a place in a class from the subject table and show them in the main table in the correct time slot. Is there any online resouces which can help me achieve this? i have already created the tables in my database, the tables but having issues on how to …

Member Avatar
Member Avatar
+0 forum 6

Can you help me to programe a window pop up in my site say in it write your email which code should i use in html and javascript

Member Avatar
Member Avatar
+0 forum 2

I need to insert an imagen into a SQL Server Database and i need to do it using jsp, but i don't know how to do it. Someone can teach me the best way to do that?

Member Avatar
Member Avatar
+0 forum 1

<?php $db = new Db(); $mysqli = Db::$_mysqli; if (isset($_POST['name'])) { $name = escape($_POST['name']); $email = escape($_POST['email']); $phone = escape($_POST['phone']); $password = escape($_POST['password']); $result = array(); /*check email is unique*/ $email_num = $db->GetNum("user","email='$email'"); if ($email_num == 0) { /*insert into database*/ $md5password = md5($password); $insert = $db->Insert("user","'','$name','$email','$phone','$md5password'"); /*success*/ if ($insert) { $result['type'] = "success"; $result['message'] = "Your are Register"; /*login the user in*/ session_start(); $_SESSION['id'] = mysqli_insert_id($mysqli); }else{ /*error*/ $result['type'] = "error"; $result['message'] = "Error Please Try again."; } }else{ $result['type'] = "error"; $result['message'] = "Email Already Register <span class='text-bs-primary'>Please Login</span>"; } if(!$error) { $sql="select * from user where (name='$name');"; …

Member Avatar
Member Avatar
+0 forum 2

This the code in products <?php require_once("inc/header.php"); require_once("inc/navbar.php"); /* if user is logged in then only allow the user to view the page */ if (!isset($_SESSION['id'])){ echo "<h1 class='text-center text-upper text-bs-primary'>please login to view your cart <a class='text-black' href='login.php'>Login</a></h1>"; exit(); } else{ $user_id = $_SESSION['id']; } $carts = $db->FetchAll("*","cart","user_id='$user_id' AND active='y'","`id` DESC"); if (empty($carts)) { echo "<h1 class='text-center text-bs-primary text-25 text-upper'>your cart is empty <a class='text-black' href='products.php'>Go Shop</a></h1>"; exit(); } ?> <div class="container padding-10"> <div id="cart-container-main"> <div class="text-center text-20 text-bold" id="cart-message"></div> <table class="table"> <th>Product image</th> <th>Product detail</th> <th>Price</th> <th>Tax</th> <th>Subtotal</th> <th>Remove</th> <tr> <?php $cod= 0; $main_subtotal = 0; $main_shipping_charge = …

Member Avatar
+0 forum 0

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP? (SELECT sum(oht_net) FROM order_header_total JOIN order_header ON oh_id = oht_oh_id WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))

Member Avatar
Member Avatar
+0 forum 2

automatically duplicate rows in sql server 2008 r2 select query i have two table name 1) tbl_Stock_Journal 2) tbl_Stock_Journal_Details i run a select query with where condition i have 5 data in table1 and in table 2 have 3 data when i run the query result is showing 15 row the query show on date wise i want to maximum data show and if other table in same date have no number of data then show blank or null please help me..... ALter proc P_GetStockJournalRPT -- 'all', 'all','2018-07-10' , '2018-07-10' @SJItmID varchar (100) , @SJDItmID varchar (100) , @Sdate date, …

Member Avatar
Member Avatar
+0 forum 4

we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database. using we want only date... [CODE]& xyzdtp.value.date &[/CODE]

Member Avatar
Member Avatar
+0 forum 12

Hello, I am planning to do my Thesis on SQLIA and now I am trying to understand something about SQLrand. SQLrand - a system for preventing SQLIA against web servers. The main intuition is that by using a randomized SQL query language, specific to a particular CGI application, it is possible to detect and abort queries that include injected code. Now, I do not understand how to randomized the SQL query language? https://www.w3schools.com/sql/func_sqlserver_rand.asp is that how you randomize the SELECT SQL command ? Please gives me some guidelines. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 3

Hey everyone i am just asking for a little bit off help if thats fine how can i make 11 fetch scripts into 1 script please [database ](https://i.imgur.com/BTGQF1P.png) i like to make this menu to display the coins i know you can do it but i dont know how since am not pro <ul class="nav nav-pills mb-3" id="pills-tab" role="tablist"> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false">Pick a coin</a> <div class="dropdown-menu"> <a class="dropdown-item" id="pills-btc-tab" href="#pills-btc" role="tab" data-toggle="pill" aria-controls="pills-btc"><img src="https://i.imgur.com/h2bZxBg.png" width="23" height="23"> Bitcoin</a> </div> </ul> fetch from mysqli i have btc here but i like to get every …

Member Avatar
+0 forum 0

Hi I am struggling with some code and was wondering any someone could please help me. My php skills are VERY limited and only get stuff done by reading forums like this and watching YouTube videos :-[. I am enjoying learning so that is why I am sticking with it and not reverting back to html which I am pretty well accomplished at. I have a phpMyAdmin database with 75 entries. My site has pagination setup where it shows 10 entries per page. I have setup one column in my database with enum and the values are 0, 1, 2, …

Member Avatar
Member Avatar
+0 forum 6

hello hope you all are going well, so my vacation is comming and i was wondering whta if i did a big project or small project, how hard is it to make my own multivendor website like amazon, i would like to do everything like the code in php, the database in mysql, without usinng platform like magento ! what is the steps to follow and do you have resources or link to any book or tutorial ?

Member Avatar
Member Avatar
+0 forum 10

I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this $query = "SELECT pubid, author FROM refs"; $sql=$con->prepare($query); $sql->execute(); $sql->setFetchMode(PDO::FETCH_ASSOC); while ($row=$sql->fetch()){ $id= $row['pubid']; $author = $row['author']; $name = explode('., ', $author); } How can one write sql/mysql query that does the same?

Member Avatar
Member Avatar
+0 forum 6

I have two tables like below tb1 Date Cr Dr 2018-04-29 100 50 2018-04-30 0 150 2018-05-01 250 100 2018-05-02 150 100 2018-06-10 300 250 2018-06-11 0 50 tb2 Date Cr 2018-05-01 350 2018-05-02 250 2018-06-10 300 2018-06-11 100 2018-06-15 200 2018-06-18 100 I need the following Result Apr May Jun Cr 100 1000 1000 Dr 200 200 300 Basically I have to add the respective Cr columns from both table and get the Dr from tb1 for the corresponding dates and create a monthly report. I have tried SELECT Date(tb1.Date) as sDate, SUM(tb1.Cr+tb2.Cr) sumcr, SUM(tb1.Dr) sumdr FROM tb1,tb1 WHERE …

Member Avatar
Member Avatar
+0 forum 7

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and just gives out errors like " * Ending quote ' was expected. (near "" at position 4438), and " 42 values were expected, but found 21. (near "(" at position 3967)* I'm attaching 2 screeshots here so that you guys can see the contents of this file,somewhere it says mysql …

Member Avatar
Member Avatar
+0 forum 2

Hi I need your help with regards on my trigger in sql server update. Want I wanted to do is to update the existing record in my database and then fire this trigger: USE [DB004] ALTER trigger [dbo].[trg_Updt_Item_Code] ON [DB004].[dbo].[RMIS_Item_Master_Ref] FOR UPDATE AS declare @trgDT as datetime declare @trgUser as varchar(20) declare @trgItemCode_new as varchar(50) declare @trgItemCode_old as varchar(50) set @trgDT = (select GETDATE()) set @trgUser = (select i.EntBy from inserted i) begin update RMIS_Item_Master_Ref set ItemCode =(select i.ItemCode FROM inserted i) where ItemCode = (select d.ItemCode FROM deleted d) end currently the output that i get is (0 row(s) …

Member Avatar
+0 forum 0

For example, you can order dishes on handheld devices that run on your Iphone, Androi, winphone, restaurant, coffee shop, and so on. Any programming language that runs on the above devices, for example simple you have to share yourself with.

Member Avatar
Member Avatar
+0 forum 4

I'm developing an online shopping website using HTML, CSS and Bootstrap. I just got stuck. * How do I create a responsive shopping cart that adds up all the shopping items/products and gives a full details and total price of items bought at checkout? * How do I access the login details of users that registers on the website? i also need to know what they have ordered on the website. how do I do this? * How do I handle the register or login part of the website? I've never created a website that requires login or register or …

Member Avatar
Member Avatar
+0 forum 3

I want to view records based on the selected drop down value so I used sql query with WHERE clause. When I echo that query, it is fetching the drop down value which I selects but it isn't showing me the records in the table. When I give the values in Where clause on my own like e.g. WHERE name='John', It shows me the record of John but when I write WHERE name='$select' and echo it, It fetches the selected value i.e. name=John in query but don't show the records. Here is my code: $con=mysqli_connect("localhost","root","","project_db"); if(mysqli_errno($con)) { echo "Can't Connect …

Member Avatar
Member Avatar
+0 forum 3

Hi I am struggling how to list all the permissions and with checkboxes. if anyone can help me with it this is the code echo "<table cellpadding='0' cellspacing='0' width='100%' class='table table-bordered'>"; echo "<tr>"; echo "<th>PERMISSION</th>"; foreach($user_groups->rows as $row) { echo "<th class='checkbox'>".$row['title']."</th>"; } echo "</tr>"; $users_permission_query = $this->db->query("SELECT * FROM users_permission"); foreach($users_permission_query->rows as $row) { $group_permissions_rows = json_decode($row['permission'], TRUE); echo "<tr>"; echo "<td>".$row['module']."<br />"; foreach($group_permissions_rows as $key => $value) { echo "{$key}<br>"; } echo "</td>"; echo "<td>"; echo "<table cellpadding='0' cellspacing='0' width='100%'>"; for($i=0; $i < count($group_permissions_rows); $i++) { foreach($group_permissions_rows as $key => $value) { echo "<tr>"; echo "<td><input type='checkbox' name='permissions[" …

Member Avatar
Member Avatar
+0 forum 4

Hi, How can i make query for this: Table1 Column1 Column2 LS11111 0 LS22222 100 LS33333 10 LS44444 0 LS55555 25 Table2 Column1 Column3 LS11111 100 LS22222 80 LS33333 25 Result i need is Column1 Column2 LS11111 100 LS22222 100 LS33333 25 LS44444 0 LS55555 25 Column1 is same on both tables, Column2 is pieces number in table1, and column3 is pieces number in Table2 I need maximum piece numbers. If table2 doesnt exist column1 value then shows table1 column2, and if it exist and is larger than table1 column2 then shows number from table2

Member Avatar
Member Avatar
+0 forum 3

Hello, Can anyone help me check if this SQL Injection Vulnerability Scan is FREE : https://suip.biz/?act=sqlmap And is the report truly shows whether the website is vulnerable to SQL Injection or truly save. This is the report example: ___ __H__ ___ ___["]_____ ___ ___ {1.2.3#stable} |_ -| . ['] | .'| . | |___|_ [']_|_|_|__,| _| |_|V |_| http://sqlmap.org [!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse …

Member Avatar
Member Avatar
+0 forum 1

Hello, i success display all the record when the button clicked <html> <head lang="en"> <meta charset="UTF-8"> <link type="text/css" rel="stylesheet" href="bootstrap-3.2.0-dist\css\bootstrap.css"> <!--css file link in bootstrap folder--> <title>View Users</title> </head> <style> .login-panel { margin-top: 150px; } .table { margin-top: 50px; } </style> <body> <div class="table-scrol"> <h1 align="center">All the Users</h1> <div class="table-responsive"><!--this is used for responsive display in mobile and other devices--> <table class="table table-bordered table-hover table-striped" style="table-layout: fixed"> <thead> <tr> <th>kepada</th> <th>nama</th> <th>jawatan</th> </tr> </thead> <?php include('db_connection.php'); $view_users_query="select * from permohonan";//select query for viewing users. $run=mysqli_query($dbcon,$view_users_query);//here run the sql query. while($row=mysqli_fetch_array($run))//while look to fetch the result and store in a array …

Member Avatar
Member Avatar
+0 forum 2

The End.